Oil & Gas Data Analytics Engineer: BI & Data Modeling

Warwick Investment Group; Oklahoma City (OK); On-site; USD 110,000 - 150,000; Full time

Job summary

Warwick Energy seeks a Data Analytics Engineer to bridge data engineering and BI, turning raw data into structured datasets and scalable data models for analytics and reporting.

You will ensure high-quality data assets in the warehouse, enabling a single source of truth for decision-making and trusted insights across teams. Collaboration and continuous improvement are essential to power BI applications.

Qualifications

• Oil and Gas industry experience with 5+ years in data challenges.
• Proficient in complex SQL with CTEs and window functions.
• Clear documentation for data models, ELT processes, analytics.
• Deep data modeling knowledge and BI semantic layers.
• 5+ years building data models for BI tools (Power BI/Spotfire).
• Collaborative with cross-functional teams to align data solutions.
• Design scalable workflows; optimize data queries for performance.
• Version control with Git and Azure DevOps.

Responsibilities

• Bridge data engineering and BI teams to produce structured datasets.
• Design scalable data models and semantic layers for BI tools.
• Collaborate with data engineers to maintain robust data models.
• Develop analytics workflows with version-controlled processes (DBT).
• Ensure outputs meet business objectives and are accessible to users.
• Document data models, workflows, and analytics solutions clearly.
• Promote best practices in data analytics across teams.

Skills

Oil & Gas

SQL Expertise

Documentation

Data Modeling

BI Tools

Collaboration

Workflows

Version Control

Python

Data Governance

Snowflake

Microsoft Fabric

Cloud Platforms

Tools

Snowflake

Microsoft Fabric

Power BI

Spotfire

Git

Azure DevOps

Python (libs)

Job description

Warwick Energy seeks a Data Analytics Engineer to bridge data engineering and BI, turning raw data into structured datasets and scalable data models for analytics and reporting.

You will ensure high-quality data assets in the warehouse, enabling a single source of truth for decision-making and trusted insights across teams. Collaboration and continuous improvement are essential to power BI applications.