Data Engineer- BI Developer

Diversified Gas & Oil Corporation

Birmingham (AL)

On-site

USD 100,000 - 160,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Diversified Gas & Oil Corporation, headquartered in Birmingham, AL, seeks a Data Engineer / BI Developer to design and optimize data pipelines powering enterprise reporting and analytics. You will transform business requirements into reliable data models using Snowflake, dbt, SQL, and the Power BI/Fabric ecosystem, partnering with BI leadership and cross-functional teams.

In this hands-on role, you will own end-to-end data flows, implement governance and security, and contribute to a maturing

Qualifications

Bachelor's degree required in CS, IS, or related field.
5+ years hands-on data engineering in cloud-native DW environments.
Expert Snowflake proficiency across modeling, performance, and security.
Experience with Snowflake Dynamic Tables, Cortex Analyst, Semantic Views, or Iceberg.
Advanced SQL skills (window functions, CTEs, optimization).
Strong ELT with dbt Core/Cloud (models, tests, macros, snapshots, sources).
CI/CD with Git-based workflows and pipeline automation.

Responsibilities

Design, build, and optimize ELT/ETL pipelines using dbt Core and Snowflake.
Develop semantic views and medallion architecture patterns.
Implement CDC and streaming ingestion.
Own end-to-end data flow from ingestion to analytics models.
Contribute to governance, lineage, security, and SOX controls.
Collaborate with analysts and stakeholders to translate requirements into data objects.

Skills

Data engineering

SQL

Python

Communication

Education

Bachelor's degree in CS or related field

Tools

Snowflake

dbt Core

dbt Cloud

Power BI

Fabric

Git

Job description

COMPANY PROFILE

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.

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

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.