JMontréalSenior Data Engineer, SSIS and SSAS
Context
A financial sector employer in Montréal is looking for a senior data engineer for a 24-month hybrid contract, with a possible conversion to a permanent position. The role supports critical, large-scale analytical data platforms.
What you'll do
- Design, develop and maintain robust, high-performance data pipelines and SSIS packages
- Implement full, incremental and CDC ingestion strategies, along with SCD type 1 and type 2 handling
- Develop and optimize advanced T-SQL on Microsoft SQL Server environments
- Maintain and optimize SSAS Tabular and/or Multidimensional models and contribute to data warehouse design
- Contribute to DEV, TEST and PROD deployments and to CI/CD and DevOps BI practices
Profile
- Senior profile with strong experience in data engineering, BI and data warehousing
- 5+ years of experience with Microsoft SSIS, required
- Experience with Microsoft SSAS, required
- Excellent command of SQL / T-SQL and on-premises Microsoft SQL Server
- Knowledge of Data Warehouse modelling, including Star/Snowflake schemas and Slowly Changing Dimensions