Infrastructure & Capital Projects - Data Engineering Specialist, COM
Toronto, ON, Canada
CAD 82k-123k / year
Infrastructure & Capital Projects – Data Engineering Specialist, COM
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.
- 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.
- 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.
- 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.
- 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.
- Working Conditions:
- 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.
- Education:
- 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.
- 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.
- Domain Knowledge
- 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.
- 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.
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
Toronto
Equal Employment Opportunity Statement
All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law.
Job candidates will not be obligated to disclose sealed or expunged records of conviction or arrest as part of the hiring process.
Accenture is committed to providing veteran employment opportunities to our service men and women.
Please read Accenture’s Recruiting and Hiring Statement for more information on how we process your data during the Recruiting and Hiring process.
We work with one shared purpose: to deliver on the promise of technology and human ingenuity. Every day, more than 775,000 of us help our stakeholders continuously reinvent. Together, we drive positive change and deliver value to our clients, partners, shareholders, communities, and each other.
We believe that delivering value requires innovation, and innovation thrives in an inclusive and diverse environment. We actively foster a workplace free from bias, where everyone feels a sense of belonging and is respected and empowered to do their best work.
At Accenture, we see well-being holistically, supporting our people’s physical, mental, and financial health. We also provide opportunities to keep skills relevant through certifications, learning, and diverse work experiences. We’re proud to be consistently recognized as one of the World’s Best Workplaces™.
Join Accenture to work at the heart of change. Visit us at www.accenture.com.
