Senior Data Engineer

Date Posted: 12/24/2025

Hiring Organization: Rose International

Position Number: 494959

Industry: Government

Job Title: Senior Data Engineer

Job Location: Edmonton, AB, Canada, T5K 2J5

Work Model: Hybrid

Work Model Details: Primarily remote with onsite meetings

Shift: 8:00 to 4:30 Alberta time

Employment Type: Temporary

FT/PT: Full-Time

Estimated Duration (In months): 13

Min Hourly Rate($): 75.00

Max Hourly Rate($): 90.00

Must Have Skills/Attributes: ADF, Analytics, CI/CD tools, Dashboards, Data Analytics, Data Migration, Kubernetes, PowerBI, Snowflake, SSIS, Terraform, Warehouse

Experience Desired: Databases and data integration, including PostgreSQL, MongoDB, Azure Cosmos DB, Synapse, and Talend (2 yrs); Exposure to AI/ML tools and workflows relevant to data engineering like Databricks and Azure (1 yrs); Experience with the Government IT infrastructure (1 yrs)

Required Minimum Education: Bachelor's Degree

**C2C is not available**

Job Description
*** Only qualified Senior Data Engineer candidates currently located in the Edmonton, Alberta area will be considered due to the position requiring an onsite Presence***

Required Education

• Bachelor's degree in computer science, IT, or related field of study

Required Experience, Knowledge & Skills

• Designing efficient dimensional models (star and snowflake schemas) for warehousing and analytics (3 Years)
• Ensuring data quality, security, and governance (3 Years)
• Experience and technical knowledge of Microsoft tabular models and DAX (3 Years)
• Experience as a Data Analyst, Data Engineer, or in a similar role (5 Years)
• Experience using Git, collaborative workflows, CI/CD pipelines, containerization (Docker/Kubernetes), and Infrastructure as Code (Terraform, ARM, CloudFormation) to deploy and migrate data solutions (2 Years)
• Experience with development for dashboards and reports (3 Years)
• Experience with manipulating and extracting data from diverse on-premises and cloud-based sources (5 Years)
• Experience with SSIS, Azure Data Factory (ADF), and using APIs for extracting and integrating data across multiple platforms and applications (3 Years)
• Experience working with Power BI (3 Years)
• Performing migrations across on-premises, cloud, and cross-database environments (2 Years)

Preferred Experience, Knowledge & Skills

• Experience leading custom software application development projects following a formal project life cycle methodology (2 Years)
• Experience with databases and data integration, including PostgreSQL, MongoDB, Azure Cosmos DB, Azure Synapse, and Talend (2 Years)
• Experience with the Government IT infrastructure, business direction, strategies, shared service initiatives, and/or applications (1 Year)
• Exposure to AI/ML tools and workflows relevant to data engineering, such as integrating AI-driven analytics or automation within cloud platforms like Databricks and Azure (1 Year)

Our client is seeking a talented and versatile Data Engineer to join a dynamic team. The ideal candidate will have a strong foundation in data engineering practices, combined with the analytical skills necessary to derive actionable insights from data. This role involves designing, implementing, and maintaining robust data pipelines and architectures, as well as performing detailed data analysis to support business decisions

Job Duties

• Design, build, and maintain data pipelines on-premises and in the cloud (Azure, GCP, AWS) to ingest, transform, and store large datasets. Ensure pipelines are reliable and support multiple business use cases
• Create and optimize dimensional models (star/snowflake) to improve query performance and reporting. Ensure models are consistent, scalable, and easy for analysts to use
• Integrate data from SQL, NoSQL, APIs, and files while maintaining accuracy and completeness. Apply validation checks and monitoring to ensure high-quality data
• Improve ETL/ELT processes for efficiency and scalability. Redesign workflows to remove bottlenecks and handle large, disconnected datasets
• Build and maintain end-to-end ETL/ELT pipelines with SSIS and Azure Data Factory. Implement error handling, logging, and scheduling for dependable operations
• Automate deployment, testing, and monitoring of ETL workflows through CI/CD pipelines. Integrate releases into regular deployment cycles for faster, safer updates
• Manage data lakes and warehouses with proper governance. Apply security best practices, including access controls and encryption
• Partner with engineers, analysts, and stakeholders to translate requirements into solutions. Prepare curated data marts and fact/dimension tables to support self-service analytics
• Analyze datasets to identify trends, patterns, and anomalies. Use statistical methods, DAX, Python, and R to generate insights that inform business strategies
• Develop interactive dashboards and reports in Power BI using DAX for calculated columns and measures. Track key performance metrics, share service dashboards, and present results effectively
• Build predictive or descriptive models using statistical, Python, or R-based machine learning methods. Design and integrate data models to improve service delivery
• Present findings to non-technical audiences in clear, actionable terms. Translate complex data into business-focused insights and recommendations
• Deliver analytics solutions iteratively in an Agile environment. Mentor teams to enhance analytics fluency and support self-service capabilities
• Provide data-driven evidence to guide corporate priorities. Ensure strategies and initiatives are backed by strong analysis, visualizations, and models
• **Only those lawfully authorized to work in the designated country associated with the position will be considered.**
• **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client's business needs and requirements.**

Benefits
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.

California Pay Equity
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.

Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/