Infrastructure & Capital Projects - Data Engineer, COM (6-Month Contract)
Accenture
Infrastructure & Capital Projects - Data Engineer, COM (6-Month Contract)
Job 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
Qualifications
- 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
Life at Accenture
Work where you're inspired to explore your passions and where your talents are nurtured and cultivated. Innovate with leading-edge technologies on some of the coolest projects you can imagine.
Training and Development
Take time away to learn and learn all the time in our regional learning hubs, connected classrooms, online courses and learning boards.
Work Environment
Be your best every day in a work environment that helps drive innovation in everything you do.
Learn more about Accenture
Our more than 742,000 people in more than 120 countries, combine unmatched experience and specialized skills across more than 40 industries. We embrace the power of change to create value and shared success for our clients, people, shareholders, partners and communities.
Our Expertise
Meet Our People
From entry-level to leadership, across all business and industry segments, get to know our people harnessing technology to make a difference, every day.
Stay connected
Join Our Team
Search open positions that match your skills and interest. We look for passionate, curious, creative and solution-driven team players.
Keep Up to Date
Stay ahead with careers tips, insider perspectives, and industry-leading insights you can put to use today–all from the people who work here.
Job Alert Emails
Personalize your subscription to receive job alerts, latest news and insider tips tailored to your preferences. See what exciting and rewarding opportunities await.