Analysis Skills, Apache, Architectural Design, Artificial Intelligence (AI), Automation, Business Analysis, Business Intelligence, Change Control, Channel Strategies, Cloud Computing, Code Reviews, Communication Skills, Computer Programming, Computer Science, Computer Security, Continuous Deployment/Delivery, Continuous Integration, Cost Reporting, Cross-Functional, DEC Computers, Data Management, Data Modeling, Data Quality, Data Sets, Data Warehousing, Database Extract Transform and Load (ETL), Document Management, Ecosystems, Engineering, Enterprise Architecture, Git, Information Technology & Information Systems, Interoperability, Metadata, Metrics, Microsoft Product Family, Multiplatform/Cross-Platform, Natural Gas, Oil and Gas, Operational Improvement, Performance Management, Performance Modeling, Performance Tuning/Optimization, Physical Demands, Power BI, Presentation/Verbal Skills, Programmable Logic Controller (PLC), Query Optimization, Regulatory Compliance, Requirements Management, SQL (Structured Query Language), Sarbanes-Oxley Act (SOX), Search Engine Optimization (SEO), Security Architecture, Snowflake Schema, Stewardship, Stock Market, User Groups, User Interface/Experience (UI/UX), Warehousing, Writing Skills
Diversified Gas & Oil Corporation (“DGOC”) is a wholly-owned subsidiary of Diversified Energy Company PLC, a US-based company listed on the New York Stock Exchange (NYSE) and London Stock Exchange (LSE) under the ticker symbol “DEC”. Diversified Gas & Oil Corporation (DGOC) is an established owner and operator of producing conventional and unconventional natural gas & oil wells and midstream pipelines and compression stations concentrated in the Appalachian Basin in the United States. Headquartered in Birmingham, AL, our field operations are located throughout the Appalachian Basin in the states of Tennessee, Kentucky, Virginia, West Virginia, Ohio, and Pennsylvania. In 2021, Diversified announced our expansion into our Central Regional Focus Area, which includes producing areas within Louisiana, Texas, Oklahoma, and Arkansas.
Responsibilities:
POSITION SUMMARY & RESPONSIBILITIES:
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.
Position Summary
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
Qualifications:
POSITION 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.
- Experience with Power BI development including semantic model design and DAX authoring is a plus.
- Familiarity with Microsoft Fabric, OneLake, or Direct Lake mode is a plus.
- Oil & Gas or energy sector experience is a plus.
Office Physical Requirements and Working Conditions:
- Prolonged periods working at a desk in front of a computer.
Additional Requirements:
- Must be able to lift up to 15 pounds at a time.