Data Engineering Specialist

Scalian • Montreal, QC

6d • Hybrid

About The Position

We are looking for a Data Engineering Specialist/Analytics Engineer to collaborate on one of our projects in the aeronautics sector. Scalian is a multinational engineering consulting firm with over 35 years of experience and nearly 6,000 specialists across 12 countries. We provide expertise in Operations & Technology and Information Technology to a variety of industries, including aerospace, defense, railways, and energy, supporting their development. At Scalian, people are at the heart of our priorities. By joining us, you will have the opportunity to achieve your professional goals in a collaborative and supportive environment.

Requirements

• 3-5 years experience in BI development, analytics engineering, or data warehouse development
• Expert SQL and hands-on experience building/modeling SQL data warehouses
• Strong dimensional modeling — fact and dimension design from complex data
• Advanced Power BI: DAX, M (Power Query), dataset design, and lifecycle management
• Python for ETL/ELT, automation, and analytics
• Power BI Service governance: workspaces, gateways, security, deployment pipelines
• Ability to gather requirements and communicate with non-technical stakeholders

Nice To Haves

• Working knowledge of procurement / supply chain business processes and KPIs (spend, savings, supplier performance, S2P/P2P)
• Previous work with ERPs such as Oracle R12, Oracle R11, Oracle Cloud, SAP Ariba
• Advanced Excel and Microsoft Office (Power Query in Excel, pivot models)
• Familiarity with Microsoft Fabric, Azure Data Factory, Synapse, or similar cloud data platforms
• Proficiency with AI-assisted coding and development — preference for candidates who use tools such as GitHub Copilot, or Microsoft 365 Copilot to speed up SQL, Python, DAX, and M development, prototype data models and transformations faster, and shorten build cycles, with disciplined review and testing of AI-generated code

Responsibilities

• Design, build, and maintain dimensional models (star schemas, fact/dimension tables) from complex source systems.
• Develop and optimize SQL data warehouse objects — tables, views, stored procedures, and transformation logic.
• Establish a clean, reusable semantic layer that standardizes business logic across reports.
• Build and maintain Power BI datasets, dashboards, and reports with optimized DAX and M (Power Query).
• Own the Power BI development lifecycle and deploy through Dev/Test/Prod pipelines.
• Automate data preparation and reporting tasks with Python where it adds efficiency.
• Manage Power BI workspaces, dataflows, refresh schedules, row-level security, and access.
• Monitor performance and continuously tune models, queries, and refreshes.
• Document data models, lineage, and business definitions for auditability and traceability.
• Partner with business teams to capture reporting requirements and prioritize the request backlog.
• Translate ambiguous asks into precise technical specs and deliver solutions that fit real needs.

Benefits

• Competitive salary
• Comprehensive benefits package (health and dental insurance, life and long-term disability insurance, group RRSP with company contribution, sick leave, etc.)
• Continuous training
• Personalized career path
• International work opportunities
• Team buildings, happy hours, marathons, and much more

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed