Data Engineering Specialist

Accenture; Toronto; Hybrid; CAD 118,000 - 145,000; Full time

Benefits offered by this job

Comprehensive employee benefits

Competitive compensation package

Job summary

A global technology consulting firm in Toronto is seeking a Data Engineer to support large-scale infrastructure programs. This role involves designing data transformation frameworks for analytics-ready datasets for Power BI reporting. The ideal candidate will have extensive experience with SQL, Snowflake, and Azure Data Factory, and will work collaboratively to manage data ingestion and reporting processes. Competitive salary range from $118,000 to $145,000 annually, with a hybrid work model at downtown Toronto.

Qualifications

• 4+ years of experience in data engineering or analytics engineering roles.
• Advanced skills in Power BI including DAX and data modeling.
• Strong SQL and data transformation skills in Snowflake.

Responsibilities

• Design and implement data transformation logic.
• Deliver Power BI–ready datasets aligned to standardized KPIs.
• Develop and maintain end-to-end ELT pipelines using Azure Data Factory.

Skills

Data transformation

Power BI

SQL

Azure Data Factory

Data modeling

Education

Bachelor’s degree in Computer Science, Engineering, or Data Analytics

Tools

Snowflake

Oracle Primavera P6

Job description

Overview

You’ve Never Been Satisfied with “Good Enough.”

You want to make an impact, not just manage projects, but change how the world gets built. At Accenture Infrastructure & Capital Projects, you’ll do exactly that. You’ll help develop and deliver the factories, grids, transit systems, and public infrastructure that keep communities moving - and do it smarter, safer, and more sustainably than ever before.

You’ll work alongside people who think big and act bold - project managers, engineers, technologists, and strategists who blend real-world experience with digital innovation and AI. Together, we’re transforming how capital projects are planned, managed, and executed, creating a better way to build for the future.

Because “good enough” builds the past. You’re here to build what’s next, on a team that outperforms every norm.

Visit us here to learn more about Accenture Infrastructure & Capital Projects

About the Role

We are seeking a Data Engineer to support large-scale capital infrastructure programs, with a strong focus on data transformation and preparation to enable trusted, analytics-ready datasets for Power BI reporting.

This role sits at the intersection of data ingestion, transformation, and analytics enablement, supporting engagements where owners consolidate data from internal enterprise systems and external supply-chain sources. Much of the value in this role comes from cleaning, standardizing, and conforming inconsistent data into common structures that support portfolio-level and executive reporting.

You will work closely with Data & Analytics Consultants and BI Developers to design robust ingestion and transformation frameworks using Azure Data Factory (ADF), curate analytics-ready data in Snowflake, and ensure downstream Power BI reporting is accurate, performant, and scalable.

Responsibilities

• Data Transformation & Preparation: Design and implement data transformation logic to cleanse, standardize, and conform data from both internal enterprise systems and external supply-chain sources.
• Normalize inconsistent supply-chain data into common dimensions, reference data, and standardized KPI definitions.
• Implement business rules, derivations, and calculations to ensure consistency across reports and dashboards.
• Manage slowly changing dimensions (SCDs), snapshots, and historical views to support trend and time-series analysis.
• Ensure all transformed datasets are analytics-ready and aligned to defined reporting use cases.
• Analytics Enablement & Reporting Support: Deliver Power BI–ready datasets aligned to standardized KPIs and reporting requirements.
• Design and maintain analytics-focused data models (facts, dimensions, snapshots) optimized for reporting performance.
• Support Power BI refresh strategies, including incremental refresh and dependency sequencing.
• Partner closely with BI developers and analysts to ensure semantic consistency between Snowflake data models and Power BI measures.
• Work within the client’s Snowflake and Power BI environment, writing complex SQL transformations to prepare EPC and PMIS data (e.g., Oracle Primavera P6 and related systems) for reporting.
• Data Engineering & Architecture: Develop and maintain end-to-end ELT pipelines using Azure Data Factory (ADF) into Snowflake, in support of transformation and reporting needs.
• Implement incremental loads, change data capture (CDC), and historical tracking to enable time-based analysis.
• Support scalable and maintainable data architectures aligned to enterprise analytics standards.
• Internal & Supply Chain Data Ingestion Automation (Enabling Capability): Design and implement automated ingestion pipelines for: Internal enterprise systems (e.g., PMIS, ERP, scheduling, commercial systems), and External supply-chain data (e.g., contractor cost, progress, schedule, commercial, and performance data).
• Handle ingestion from heterogeneous sources, including databases, flat files, APIs, and shared data environments.
• Build reusable Azure Data Factory (ADF) pipeline templates to support multi-system, multi-vendor, and multi-project ingestion patterns.
• Implement validation, reconciliation, and exception handling to manage inconsistent, late, or partial data submissions.
• Data Quality, Governance & Reliability: Embed automated data quality checks within ingestion and transformation pipelines.
• Monitor pipeline execution and proactively address failures, anomalies, and data integrity issues.
• Support data lineage, documentation, and governance standards across both internal and externally sourced data.
• Enforce consistent data structures, naming conventions, and KPI definitions.
• Process Oversight & Delivery: Collaborate with technical teams to monitor CI/CD pipelines (GitHub / Azure DevOps) and troubleshoot issues impacting reporting availability.
• Work closely with Data & Analytics Consultants to translate reporting requirements into scalable transformation and modeling solutions.
• Participate in Hybrid-Agile delivery, including sprint planning, backlog refinement, and iterative releases.
• Contribute to CI/CD practices for ADF pipelines, Snowflake objects, and analytics assets.
• Working Conditions: Hybrid: this role's work location is primarily based in downtown Toronto but will see some travel to various client sites at key project milestones.

Required Qualifications

• Bachelor’s degree in Computer Science, Engineering, Data Analytics, or related field.
• 4+ years of experience in data engineering or analytics engineering roles.
• Advanced Power BI skills including DAX and data modeling.
• Strong SQL and data transformation skills in Snowflake.
• Experience working with diverse data sources (ranging from PMIS tools like P6, EcoSys, etc. to SAP, SharePoint, etc.)
• Strong experience with data transformation for analytics and reporting.
• Hands-on expertise with Azure Data Factory (ADF) for orchestration and advanced ETL scenarios.
• Strong experience with Snowflake, including: SQL-based transformations; Data modeling for analytics; Performance tuning.
• Experience preparing data for Power BI consumption.
• Advanced SQL skills and experience working with messy, inconsistent datasets.
• Experience working in Azure DevOps environments, including boards (work items), Repos, and CI/CD pipelines, to support analytics and data engineering delivery.

Nice-to-have

• Domain Knowledge: Understanding of capital project controls, scheduling, or construction management.
• Certifications: SnowPro Core, Microsoft Power BI Data Analyst Associate (PL-300), and/or PMP/CSM.
• Ability to arrange priorities and escalate competing risks to meet deadlines.
• Keen eye for detail and adept problem-solving abilities.
• Must have demonstrated experience relaying and receiving information (written and verbal).
• Experience working with CI/CD pipelines, to support analytics and data engineering delivery.
• Effective skills in Microsoft Office.
• Equipped to work independently and as part of a team.

Compensation at Accenture varies depending on a wide array of factors, which may include but are not limited to the specific office location, role, skill set, and level of experience. As required by local law, Accenture provides a reasonable range of compensation, based on full-time employment, for roles that may be hired as set forth below.

The recruiting efforts for this position are intended to fill an existing position.

The base pay range shown below is intended as a guideline to reflect the majority of offers for this role. It does not represent a maximum limit — in some cases, actual compensation may exceed the range where appropriate.

Role Location Annual Salary Range

Toronto $118,000 to $145,000

Accenture Infrastructure & Capital Projects Inc. (Accenture I&CP), formerly Comtech Group Inc., now a wholly owned subsidiary of Accenture, is committed to providing accessible employment practices that comply with local legislative requirements. If you require accommodation during any stage of the recruitment process, please notify the People and Culture Team by emailing [e-mail]. Accenture I&CP offers our employees a competitive compensation package with comprehensive employee benefits, and an inclusive environment that fosters teamwork & entrepreneurial spirit. Accenture I&CP is an equal opportunity employer. To provide you with the most effective recruiting process, Accenture I&CP may use artificial intelligence to create insights on how your candidate information matches the requirements of the role you have applied to. The final decision will always be taken by then hiring team after considering your candidate profile in full. As a candidate you can choose to opt out of this artificial intelligence screening process by emailing [e-mail] and be rest assured that this will not negatively impact your opportunity for employment with Accenture.