Job Description

(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