Oil & Gas Data Analytics Engineer: BI‑Driven Pipelines

WARWICK INVESTMENT GROUP LLC; Oklahoma City (OK); On-site; USD 110,000 - 170,000; Full time

Benefits offered by this job

Health benefits

401(k) plan

Job summary

WARWICK INVESTMENT GROUP LLC in Oklahoma City seeks a Data Analytics Engineer to bridge data engineering and BI, converting raw data into structured datasets and building scalable data models for analytics and reporting.

You will collaborate across teams to ensure high-quality, auditable data assets powering Power BI and Spotfire dashboards, with a focus on scalable DBT workflows and data governance.

Qualifications

• 5+ years in oil and gas data environments.
• Complex SQL with CTEs, advanced formulas and window functions.
• Clear documentation for data models, ELT processes and analytics.
• Deep data modeling knowledge with semantic layers for BI.
• 5+ years building data models for Power BI and Spotfire.
• Ability to collaborate with business, data engineering and analytics teams.
• Design scalable data workflows and optimize queries for performance.
• Familiar with Git and Azure DevOps for version control.

Responsibilities

• Data Transformation: convert raw data into structured datasets for BI.
• Data Modeling: design scalable data models and semantic layers.
• Strengthen Data Infrastructure: collaborate to build robust data models for BI projects.
• Workflow Development: develop and maintain version-controlled analytics workflows (DBT).
• Business Alignment: ensure outputs meet business objectives and are accessible.
• Technical Documentation: document data models, workflows, and analytics solutions.
• Collaboration: work with cross-functional teams to promote best practices in data analytics.

Skills

Oil & Gas industry experience

SQL proficiency

Documentation skills

Data modeling principles

BI tools experience: Power BI

BI tools experience: Spotfire

Collaboration across teams

Scalable workflows

Version control knowledge (Git/Azure)

Snowflake

Microsoft Fabric

Cloud platforms (Snowflake/Azure/AWS/G

Python for data manipulation

Data governance principles

Tools

Snowflake

Microsoft Fabric

Git

Azure DevOps

Job description

WARWICK INVESTMENT GROUP LLC in Oklahoma City seeks a Data Analytics Engineer to bridge data engineering and BI, converting raw data into structured datasets and building scalable data models for analytics and reporting.

You will collaborate across teams to ensure high-quality, auditable data assets powering Power BI and Spotfire dashboards, with a focus on scalable DBT workflows and data governance.