Infrastructure & Capital Projects – Data Engineering Specialist, COM at Accenture Infrastructure & Capital Projects Inc. — Toronto, CAN | Base Career | Base Career
Microsoft FabricSQLAzureSynapse PipelinesPower PlatformPower BI
Full Job Posting
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
(Internal Title: Business System Configuration / Development II)
Data Science and Strategic Support Assist the Data Science Manager in achieving objectives and support the development and execution of strategic roadmaps for data management and mobilization. Own end-to-end delivery for defined data domains, such as cost, schedule, commitments, risk, and change, including ingestion, transformation, publishing, and ongoing operational support. Translate requirements from Performance Analytics & Insights into clear data contracts, scalable engineering solutions, and analytics-ready data products. Coordinate upstream changes with Business Systems and source system owners to maintain stable interfaces and minimize disruption to downstream consumers. Ensure curated data products are documented, fit for purpose, and adopted by downstream reporting and analytics consumers.
Assist the Data Science Manager in achieving objectives and support the development and execution of strategic roadmaps for data management and mobilization.
Own end-to-end delivery for defined data domains, such as cost, schedule, commitments, risk, and change, including ingestion, transformation, publishing, and ongoing operational support.
Translate requirements from Performance Analytics & Insights into clear data contracts, scalable engineering solutions, and analytics-ready data products.
Coordinate upstream changes with Business Systems and source system owners to maintain stable interfaces and minimize disruption to downstream consumers.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
Ensure curated data products are documented, fit for purpose, and adopted by downstream reporting and analytics consumers.
Collaboration and Teamwork Collaborate closely with multidisciplinary teams to foster a high-performing and collaborative environment. Partner with Project Controls subject matter experts to ensure datasets reflect controlled baselines, approved business logic, and established governance without replacing control authority. Work with governance stakeholders to align data retention, access, classification, and usage with organizational policies. Support enablement by presenting data products to consumers, documenting recommended usage patterns, and contributing to continuous learning initiatives. Lead cross-functional troubleshooting and incident resolution for owned data domains, communicating impacts, recovery actions, and follow-up improvements.
Collaborate closely with multidisciplinary teams to foster a high-performing and collaborative environment.
Partner with Project Controls subject matter experts to ensure datasets reflect controlled baselines, approved business logic, and established governance without replacing control authority.
Work with governance stakeholders to align data retention, access, classification, and usage with organizational policies.
Support enablement by presenting data products to consumers, documenting recommended usage patterns, and contributing to continuous learning initiatives.
Lead cross-functional troubleshooting and incident resolution for owned data domains, communicating impacts, recovery actions, and follow-up improvements.
Data Architecture and Management Ensure scalable and flexible data architecture that supports operational excellence, data reliability, auditability, and cost-effective growth. Design incremental refresh strategies using appropriate patterns such as change data capture, snapshots, and partitioning to improve performance and traceability. Implement orchestration patterns covering dependencies, retries, backfills, scheduling, and recovery, with clear runbooks, alerts, and operational readiness procedures. Implement CI/CD practices for data pipelines, including automated testing, deployment automation, versioning, and controlled promotion across environments. Monitor platform and pipeline performance, tune compute and storage consumption, and introduce observability through metrics, logs, traces, dashboards, and alerts. Participate in creating and maintaining data dictionaries, catalogs, source mappings, lineage, transformation logic, assumptions, and known limitations. Support efforts to reduce data debt by optimizing data structures, standardizing engineering patterns, and strengthening management controls.
Ensure scalable and flexible data architecture that supports operational excellence, data reliability, auditability, and cost-effective growth.
Design incremental refresh strategies using appropriate patterns such as change data capture, snapshots, and partitioning to improve performance and traceability.
Implement orchestration patterns covering dependencies, retries, backfills, scheduling, and recovery, with clear runbooks, alerts, and operational readiness procedures.
Implement CI/CD practices for data pipelines, including automated testing, deployment automation, versioning, and controlled promotion across environments.
Monitor platform and pipeline performance, tune compute and storage consumption, and introduce observability through metrics, logs, traces, dashboards, and alerts.
Participate in creating and maintaining data dictionaries, catalogs, source mappings, lineage, transformation logic, assumptions, and known limitations.
Support efforts to reduce data debt by optimizing data structures, standardizing engineering patterns, and strengthening management controls.
Analytics and Insights Apply advanced data modeling expertise to design and optimize dimensional or domain data structures for efficient storage, retrieval, analysis, and scalable reporting. Design models that align to business hierarchies and control structures, including WBS/CBS, activity codes, portfolio structures, and other approved enterprise dimensions. Implement conformed dimensions and standardized measures to support consistent cross-program analytics and reusable semantic foundations. Define and implement validation routines appropriate to dataset criticality, including tolerance checks, reconciliation, completeness checks, and anomaly-detection triggers. Apply performance optimization techniques such as partitioning, clustering, caching, and efficient transformation patterns. Support audit requests by demonstrating lineage, transformation evidence, and reconciliation for key reported figures. Proactively detect and reduce data quality issues through automated checks, stronger controls, root-cause analysis, and corrective actions.
Apply advanced data modeling expertise to design and optimize dimensional or domain data structures for efficient storage, retrieval, analysis, and scalable reporting.
Design models that align to business hierarchies and control structures, including WBS/CBS, activity codes, portfolio structures, and other approved enterprise dimensions.
Implement conformed dimensions and standardized measures to support consistent cross-program analytics and reusable semantic foundations.
Define and implement validation routines appropriate to dataset criticality, including tolerance checks, reconciliation, completeness checks, and anomaly-detection triggers.
Apply performance optimization techniques such as partitioning, clustering, caching, and efficient transformation patterns.
Support audit requests by demonstrating lineage, transformation evidence, and reconciliation for key reported figures.
Proactively detect and reduce data quality issues through automated checks, stronger controls, root-cause analysis, and corrective actions.
Reporting and Analytics Enablement Support the development of advanced reporting strategies using data engineering and analytics engineering practices to improve efficiency and consistency. Prepare semantic model foundations for BI tools through clear naming conventions, standard aggregations, reusable measures, snapshot strategies, and documented business definitions. Ensure transformations and models follow agreed standards for naming, lineage, versioning, testing, and maintainability. Build and maintain analytics-ready curated datasets that provide stable, documented interfaces for self-service analytics and enterprise reporting. Support self-analytics enablement through training, documentation, recommended usage patterns, and close collaboration with reporting consumers. Deliver engineering changes through disciplined release practices that minimize disruption and provide clear rollback and recovery procedures.
Support the development of advanced reporting strategies using data engineering and analytics engineering practices to improve efficiency and consistency.
Prepare semantic model foundations for BI tools through clear naming conventions, standard aggregations, reusable measures, snapshot strategies, and documented business definitions.
Ensure transformations and models follow agreed standards for naming, lineage, versioning, testing, and maintainability.
Build and maintain analytics-ready curated datasets that provide stable, documented interfaces for self-service analytics and enterprise reporting.
Support self-analytics enablement through training, documentation, recommended usage patterns, and close collaboration with reporting consumers.
Deliver engineering changes through disciplined release practices that minimize disruption and provide clear rollback and recovery procedures.
Working Conditions: Office-based (5 Days a week in office)
Office-based (5 Days a week in office)
Experience: Experience: 3-7 years of experience in data engineering, analytics engineering, or software engineering with a strong data focus.
Experience: 3-7 years of experience in data engineering, analytics engineering, or software engineering with a strong data focus.
Education: Education: Bachelor’s degree in Computer Engineering, Data Science, Software Engineering, or a related discipline; Master’s degree preferred.
Education: Bachelor’s degree in Computer Engineering, Data Science, Software Engineering, or a related discipline; Master’s degree preferred.
Licenses OR Certifications: DP-203: Azure Data Engineer Associate or equivalent Azure/Fabric data engineering certification; SQL and Advanced Data Modeling training strongly preferred. CSM, ITIL V4, and other relevant Microsoft, AWS, Azure, or GCP certifications are assets.
DP-203: Azure Data Engineer Associate or equivalent Azure/Fabric data engineering certification; SQL and Advanced Data Modeling training strongly preferred.
CSM, ITIL V4, and other relevant Microsoft, AWS, Azure, or GCP certifications are assets.
Skills and Competencies: Microsoft Fabric, including strong hands-on experience building and operating scalable data engineering solutions across Fabric workloads. SQL and advanced data modeling, including dimensional modeling, conformed dimensions, standardized measures, lineage, and semantic model readiness. ETL/ELT processes, data governance, data quality, data integrity, reconciliation, and automated validation controls. Azure data engineering services, Synapse Pipelines, Data Marts, Power Platform, and related cloud data solutions. Power BI and Tableau, including data modeling, semantic foundations, visualization, and report enablement. Python, Power Query, DAX, and advanced Excel for data transformation, analytics, automation, and investigation. Incremental processing patterns such as change data capture, snapshots, partitioning, and performance optimization.
Microsoft Fabric, including strong hands-on experience building and operating scalable data engineering solutions across Fabric workloads.
SQL and advanced data modeling, including dimensional modeling, conformed dimensions, standardized measures, lineage, and semantic model readiness.
ETL/ELT processes, data governance, data quality, data integrity, reconciliation, and automated validation controls.
Azure data engineering services, Synapse Pipelines, Data Marts, Power Platform, and related cloud data solutions.
Power BI and Tableau, including data modeling, semantic foundations, visualization, and report enablement.
Python, Power Query, DAX, and advanced Excel for data transformation, analytics, automation, and investigation.
Incremental processing patterns such as change data capture, snapshots, partitioning, and performance optimization.
Domain Knowledge Experience in transit, transportation, infrastructure, capital projects, or project controls domains is advantageous but not mandatory.
Experience in transit, transportation, infrastructure, capital projects, or project controls domains is advantageous but not mandatory.
Analytical and Software Skills Strong problem-solving and analytical skills with a results-oriented mindset and demonstrated ability to troubleshoot complex pipeline, data quality, and performance issues. Strong SQL skills and practical experience designing scalable data pipelines, transformation logic, and analytical data models. Substantial experience with project control tools and dashboarding software, with the ability to translate business and control requirements into governed data solutions. Ability to communicate technical concepts, operational impacts, and data limitations clearly to both technical and business stakeholders.
Strong problem-solving and analytical skills with a results-oriented mindset and demonstrated ability to troubleshoot complex pipeline, data quality, and performance issues.
Strong SQL skills and practical experience designing scalable data pipelines, transformation logic, and analytical data models.
Substantial experience with project control tools and dashboarding software, with the ability to translate business and control requirements into governed data solutions.
Ability to communicate technical concepts, operational impacts, and data limitations clearly to both technical and business stakeholders.
Additional Tools and Knowledge Familiarity with orchestration and streaming patterns and technologies such as Airflow, Kafka, or Kinesis, including monitoring, retry, backfill, and incident-response practices. Familiarity with Microsoft SharePoint, Primavera P6, Earned Value Management software, and enterprise data governance tooling is a plus.
Familiarity with orchestration and streaming patterns and technologies such as Airflow, Kafka, or Kinesis, including monitoring, retry, backfill, and incident-response practices.
Familiarity with Microsoft SharePoint, Primavera P6, Earned Value Management software, and enterprise data governance tooling is a plus.
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 $82,000 to $123,000
Comtech Group Inc. (Comtech), part of Accenture, is a multidisciplinary consulting firm providing integrated consulting solutions on complex capital projects, including Program and Project Management, Project Controls, Engineering, Technical Advisory, Construction Management, and Technology Integration Services.
Our team thrives on embracing and navigating technical challenges within the Transportation and Infrastructure, Industrial and Manufacturing, Energy and Utilities, and Buildings and Facilities markets.
Our core focus is supporting project owners through collaborative and integrated partnerships to deliver projects that improve the world around us.
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 ICP-Careers@accenture.com.
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 ICP-Careers@accenture.com and be rest assured that this will not negatively impact your opportunity for employment with Accenture.
About Accenture Infrastructure & Capital Projects Inc.
Consulting500000 employeesFounded 1989
Consulting and advisory services for large-scale infrastructure projects.
