<p><strong>About the Role</strong></p><p>Our Edmonton-based client is seeking a Data Engineer for a 3-month contract to support their enterprise data modernization initiative. This role will focus on improving and maintaining the existing operational data store (ODS) and data warehouse, supporting the migration to the cloud, and enabling self-service analytics across the organization using Power BI and Microsoft Fabric. The successful consultant will work across multiple layers, from SQL and SSRS/SSIS to data modeling, MDM, and governance, helping the business better manage, trust, and use its data.</p><p><br></p><p><strong>Key Responsibilities</strong></p><ul><li>Assess and enhance the existing data warehouse and ODS for accuracy, performance, and usability.</li><li>Design, develop, and optimize ETL processes and data pipelines using SSIS, SQL, and related tools.</li><li>Maintain and develop SSRS reports and support ad-hoc business reporting requests.</li><li>Assist in the migration of data and custom applications to the cloud, including lift-and-shift and optimization stages.</li><li>Implement and configure Microsoft Fabric components (Data Factory, Synapse, Lakehouse, and Power BI integration).</li><li>Support and refine Power BI datasets, models, and dashboards for business self-service analytics.</li><li>Drive data cleansing and quality initiatives, ensuring consistency and governance across data sources.</li><li>Collaborate with stakeholders to define Master Data Management (MDM) and data ownership frameworks.</li><li>Serve as a data steward, helping to establish standards and best practices for governance and access.</li><li>Partner with business teams to tailor data models and reporting for different roles and personas across the organization.</li></ul>
