Infrastructure & Capital Projects - Data Engineer, COM (6-Month Contract)
Accenture
Toronto, ON-
Nombre de poste(s) à combler : 1
- Salaire À discuter
- Publié le 9 septembre 2025
-
Date d'entrée en fonction : 1 poste à combler dès que possible
Description
- (Internal Title: Business System Configuration/Development II)
- We are seeking a highly skilled professional for a 6-month contract position (with eligibility for extension) to support our client
- Work within the client’s CI/CD process (GitHub/DevOps) to design and manage data pipelines
- Design and architect ingestion methods while building secure pipelines and data transformations in the client environment
- Experienced Data Engineer to support a high-impact executive reporting initiative for a major capital infrastructure owner
- This role will work as part of a multi-disciplinary team integrating data from EPC contractor systems (e.g., Oracle Primavera P6, Deltek Cobra, EcoSys) into the client’s Snowflake data platform, enabling interactive executive dashboards in Power BI
- This role focuses on data ingestion, transformation, modeling, and automation - working closely with business analysts, Power BI developers, and the client's IT team
- Design, build, and maintain data ingestion pipelines using Snowflake (e.g., Snowpipe, COPY INTO) to ingest files delivered from EPC partners (e.g., via SharePoint or API)
- Develop and optimize SQL-based transformations and data models to support reporting KPIs across engineering, procurement, construction, and commissioning
- Implement and manage data validation routines to ensure data quality, completeness, and conformance to business rules
- Collaborate with Business Analysts, the Data Architect, and Power BI Developers to translate KPI definitions into technical data logic
- Work with EPC contractor data extracts in various formats (CSV, Excel, JSON), and normalize these into structured Snowflake tables
- Monitor daily/weekly data jobs and work with the team to troubleshoot and resolve ingestion issues
- Participate in technical design discussions and contribute to project timelines and documentation
- Experience:
- 5+ years of experience as a Data Engineer or similar role.
- Advanced-level SQL with proven experience in Snowflake-specific SQL syntax, functions, and query optimization
- Experience ingesting structured files using Snowpipe, COPY INTO, External Tables, or similar mechanisms
- Strong understanding of Snowflake architecture, including Virtual Warehouses, Storage/Compute separation, Micro-partitioning, and Time Travel
- Experience with data modeling best practices (star schema, SCDs, conformed dimensions) in Snowflake
- Hands-on experience building ETL/ELT workflows with dbt, Azure Data Factory, or custom SQL jobs targeting Snowflake
- Comfort working with stakeholders across technical and business teams to clarify logic and validate outputs
- Experience with JIRA, Git, and collaborative development practices
- Education:
- Bachelor’s degree in Computer Engineering, Data Science, or related discipline; Master’s degree preferred
- CSM, ITIL V4, and certifications in tools like Microsoft SQL Server, Power BI, Microsoft Fabric, Azure, or GCP
- Nice to Have:
- Exposure to Project Management Information Systems like Oracle Primavera P6, Deltek Cobra, EcoSys, etc.
- Snowflake certifications such as SnowPro Core, SnowPro Advanced: Data Engineer, or other Snowflake specialty certifications or performance optimization badges are a strong asset
- Experience supporting Power BI projects or building models that feed enterprise dashboards
- Familiarity with SharePoint-based data delivery or M365 ecosystems
- Understanding of capital project controls, scheduling, procurement, or commissioning
Our Commitment to Inclusion & Diversity
At Accenture, inclusion and diversity are fundamental to our culture and embedded in our core values. We are committed to creating a workforce where our people can feel comfortable, be themselves and contribute. Like Canada itself, Accenture employees represent a tremendous variety of cultures, ethnicities, beliefs, backgrounds and languages. We offer an inclusive environment regardless of personal characteristics such as ethnicity, religion, gender, sexual orientation, gender identity or expression, age or disability.
Requesting An Accommodation
Accenture is committed to providing equal employment opportunities for persons with disabilities or religious observances, including reasonable accommodation when needed. If you are hired by Accenture and require accommodation to perform the essential functions of your role, you will be asked to participate in our reasonable accommodation process. Accommodations made to facilitate the recruiting process are not a guarantee of future or continued accommodations once hired.
If you would like to be considered for employment opportunities with Accenture and have accommodation needs for a disability or religious observance, please call us toll free at 1 (877) 889-9009, send us an email or speak with your recruiter.
Other Employment Statements
It is currently our objective to assign our people to work near where they live. However, given the nature of our business and our need to serve clients, our employees must be available to travel when needed.
Job candidates are not required to disclose any offence for which a pardon has been granted.
To provide you with the most effective recruiting process, Accenture 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 the hiring team after considering your candidate profile in full. During the application process, you can choose to opt out of this artificial intelligence screening process and be rest assured that this will not negatively impact your opportunity for employment with Accenture.
Exigences
non déterminé
non déterminé
non déterminé
non déterminé