Data Engineering Specialist

Scalian • Montreal, QC

1d • 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
• Strong hands-on experience building scalable data pipelines and data solutions using Microsoft Fabric, Spark, SQL, Hadoop, Python, and medallion architecture
• Power BI Service governance: workspaces, gateways, security, deployment pipelines
• Ability to gather requirements and communicate with non-technical stakeholders

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
• Dynamic, specialized, and growing team environment
• Professional fulfillment activities (team buildings, happy hours, marathons, etc.)

What This Job Offers

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