• (Internal Title: Business System Configuration/Development II)
• 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

Please refer the Job description for details