Data Engineer- BI Developer

About the Role

Diversified Energy Company (DEC) is a leading natural gas operator with a long-term focus on sustainable, low-decline production assets across the Appalachian Basin and beyond. Headquartered in Birmingham, Alabama, DEC is transforming how upstream energy companies use data to improve operational performance, increase shareholder value, and responsibly steward energy resources.

The Data Engineer / BI Developer is responsible for designing, building, and optimizing the data pipelines, transformation models, semantic views, and analytical infrastructure that power enterprise reporting and analytics at DEC. This role partners closely with the Senior Manager of Business Analytics, developers, and other cross-functional resources to deliver scalable, governed data solutions across the full platform stack. The Senior Data Engineer translates business and analytical requirements into reliable, high-performance data models and pipelines using Snowflake, dbt, SQL, and the Microsoft Power BI and Fabric ecosystem. This individual will serve as a hands-on technical contributor and cross-functional collaborator, working directly with the VP of Business Intelligence & Analytics and engaging with business stakeholders, the data engineering team, and IT partners. Success in this role requires strong coding discipline, platform depth in Snowflake, and the ability to deliver quality work in a fast-moving, maturing data environment.

Key Responsibilities

• Data Engineering & Pipeline Development: Design, build, and maintain ELT/ETL pipelines using dbt Core and Snowflake as the primary transformation and serving layer. Develop well-structured, tested, and documented semantic views following established medallion and semantic layer patterns. Implement change data capture and streaming ingestion patterns where required. Own end-to-end data flow from raw ingestion through consumption-ready analytical models.
• Snowflake Platform Engineering: Develop and maintain Snowflake Dynamic Tables for automated, low-latency data transformations. Build Snowflake Cortex Analyst integrations to support AI-powered data interaction and natural language query patterns. Design and implement Snowflake Semantic Views as part of the enterprise semantic and metric layer. Leverage Apache Iceberg Tables within Snowflake for open table format and cross-platform interoperability. Manage warehouse sizing, multi-cluster configuration, and auto-suspend policies to govern credit consumption. Perform query profiling and optimization including clustering strategy, search optimization, and result cache utilization. Support credit governance through resource monitor configuration and cost attribution reporting.
• BI Development & Semantic Layer: Develop Snowflake Artifacts for governed use across the organization. Develop certified datasets, governed report templates, and reusable components for the user experience layer.
• Architecture & Governance: Contribute to data architecture design including source system modeling and consumption layer structure. Support data governance practices including lineage, catalog metadata, column-level security, and row-level security. Assist with SOX compliance requirements including change control documentation and audit trail for data platform assets. Participate in data quality framework design. Implement and maintain CI/CD pipelines.
• Cross-Functional Collaboration: Partner with business analysts and reporting consumers to translate requirements into well-designed data objects. Provide technical direction and code reviews to the Snowflake development team. Engage with IT infrastructure, security, and enterprise architecture on platform and integration decisions. Contribute to the Power User Group and data stewardship program as a technical subject matter expert.

Technical Stack

• Data Platforms: Snowflake, dbt, Microsoft Fabric
• Visualization Tools: Microsoft Power BI, Snowflake Artifacts
• Languages & Query: SQL, Python, DAX
• Snowflake Advanced: Dynamic Tables, Cortex Analyst, Semantic Views, Apache Iceberg Tables
• Governance & Lineage: Atlan, column/row-level security, SOX change control, audit logging
• Cloud Platform: Microsoft Azure

Requirements

• Bachelor's degree in Computer Science, Information Systems, or a related field required
• 5+ years of hands-on data engineering experience in a cloud-native data warehouse environment
• Expert-level Snowflake proficiency including data modeling, performance tuning, warehouse management, and security
• Experience with Snowflake Dynamic Tables, Cortex Analyst, Semantic Views, or Apache Iceberg
• Advanced SQL skills including window functions, CTEs, query optimization, and execution plan analysis
• Strong ELT experience with dbt Core or dbt Cloud including models, tests, macros, snapshots, and sources
• CI/CD experience with Git-based workflows and pipeline automation
• Experience designing semantic models and/or medallion architecture patterns
• Demonstrated ability to work cross-functionally with technical and non-technical stakeholders
• Strong written and verbal communication skills with the ability to articulate technical concepts clearly

Preferred Qualifications

• Experience with Power BI development including semantic model design and DAX authoring
• Familiarity with Microsoft Fabric, OneLake, or Direct Lake mode
• Oil & Gas or energy sector experience