Data Analyst III

Airswift; Denver (CO); Hybrid; USD 80,000 - 100,000; Full time

Benefits offered by this job

Competitive salary

Health insurance

Flexible working hours

Professional development opportunities

Job summary

A leading consulting firm is seeking a Data Analyst III for a 12-month contract in Denver, CO. In this role, you will provide analytical support to the Drilling & Completions (D&C) team, transforming complex data into actionable insights. Required qualifications include expertise in SQL and Power BI, along with strong analytical and communication skills. The successful candidate will work independently and collaboratively with various stakeholders to enhance operational efficiency and reporting quality.

Qualifications

• 3+ years of professional experience as a Data Analyst or similar role.
• 2+ years writing complex SQL queries in production environments.
• 2+ years experience building and managing Power BI or Spotfire dashboards.
• Experience in a data-intensive environment supporting operations.

Responsibilities

• Extract, analyze, and interpret complex datasets for business decisions.
• Develop and maintain SQL queries for D&C reporting and analysis.
• Build and enhance Power BI dashboards for D&C teams.
• Utilize automation tools to streamline data analysis.

Skills

Expert-level SQL

Proficiency in Power BI

Strong analytical skills

Communication skills

Education

Bachelor’s Degree in Engineering, Computer Science, Data Science or related field

Tools

SQL Server Management Studio

Power BI

Excel

Spotfire

Job description

Airswift is seeking Data Analyst III for an initial 12 months to support a major O&G client.

Location: Denver, CO
Contract Duration: 12 months with the possibility of extension
Schedule: 9/80 - Hybrid

We are seeking a Senior Data Analyst to join our Rockies region team on a contract basis, providing dedicated analytical support to the Drilling & Completions (D&C) organization. This is a strategic role embedded within operations, where you will transform raw data into actionable insights that drive operational efficiency, well delivery performance, and capital optimization.

The ideal candidate will become a trusted data partner to D&C leadership, engineers, and field personnel, delivering high-quality analytics, dashboards, and automated solutions that directly impact business outcomes. This role requires a seasoned professional who can work independently, solve complex problems, and communicate findings effectively at all levels, including executive management.

Data Analysis & Insights

• Extract, analyze, and interpret complex datasets to derive insights that drive strategic business decisions.


• Develop and maintain SQL queries against enterprise data systems (OXYODS, OpenWells, operational databases) to support D&C reporting and analysis.


• Perform detailed analysis of drilling and completions performance, timelines, costs, and operational KPIs.


• Translate technical findings into actionable business insights and recommendations.

Dashboard Development & Visualization

• Build, enhance, and manage Power BI and/or Spotfire dashboards for D&C and Operations teams.


• Create insightful visualizations that communicate complex data clearly to technical and non-technical stakeholders.


• Maintain dashboard integrity by troubleshooting issues, reconnecting data sources, and optimizing refresh performance.


• Ensure reporting solutions align with enterprise BI standards.

Process Automation & Optimization

• Utilize automation tools to streamline data analysis and business processes.


• Identify manual, repetitive processes and implement automated solutions.


• Develop reusable SQL templates, stored procedures, and data pipelines for recurring analysis.


• Continuously identify optimization opportunities in data workflows and reporting.

Collaboration & Stakeholder Support

• Work closely with D&C engineers, operations leads, and business stakeholders to understand data requirements and provide analytical support.


• Collaborate effectively with data engineers, data scientists, and IT teams.


• Respond swiftly to ad-hoc data requests while maintaining quality standards.


• Document data lineage, business logic, and reporting methodologies.

Data Quality & Governance

• Develop data validation queries and perform continuous QC across source systems.


• Monitor data freshness and proactively flag anomalies.


• Support master data management for wells, pads, assets, and operational hierarchies.

Required Qualifications

• 3+ years of professional experience as a Data Analyst, Business Intelligence Analyst, or similar role.


• 2+ years writing complex SQL queries in production environments, including creating new queries from scratch and optimizing existing ones.


• 2+ years hands‑on experience building and managing Power BI and/or Spotfire dashboards.


• Experience supporting operations, engineering, or field teams in a data‑intensive environment.

Technical Skills

• Expert‑level SQL including CTEs, subqueries, joins, aggregations, window functions, and string manipulation.


• Proficiency in Power BI (preferred) or Spotfire for building dashboards and reports (required).


• Strong understanding of relational database concepts and data modeling.


• Proficiency in Excel for data manipulation and analysis.


• Experience with version control systems (Git, Azure DevOps) for code management is a plus.

Analytical & Problem‑Solving Skills

• Strong analytical, problem‑solving, and critical thinking abilities in a data‑intensive environment.


• Ability to perform detailed analysis and translate complex data into clear business insights.


• Strong attention to detail with focus on data accuracy and completeness.


• Comfortable working with ambiguous requirements and iterating toward solutions.

Communication & Collaboration

• Excellent communication, presentation, and data storytelling skills.


• Strong verbal and written communication skills with demonstrated ability to communicate professionally at all levels, including executive management.


• Ability to work effectively in a team, collaborating with engineers, operations, and business stakeholders.


• Self‑starter who can manage multiple priorities and deadlines.

Education

• Bachelor’s Degree in Engineering, Computer Science, Data Science, Finance, or related field.

Preferred Qualifications

• Drilling & Completions knowledge and/or upstream oil & gas experience strongly preferred.


• Experience with OpenWells or similar well data management systems (Landmark, PPDM-based applications).


• Knowledge of oil & gas operational metrics including well‑level data (API numbers, pads, formations, lateral lengths), drilling metrics (spud dates, drill days, directional surveys), and completion metrics (stages, proppant, pump schedules, frac timelines).


• Programming skills in Python or R for advanced analytics and automation.


• Experience with Microsoft Power Platform (Power Automate, Power Apps) for workflow automation.


• Experience with cloud data platforms (Azure, AWS).

What You’ll Work With

• Stakeholders: Drilling & Completions, Operations, Field personnel, Business units, Regulatory, HSE


• Databases: OXYODS, OpenWells, operational and financial planning systems


• BI Tools: Power BI, Spotfire


• Data Types: Drilling/completions data, well timelines, KPIs, cost data, milestone dates


• Tools: SQL Server Management Studio, Excel, Power BI, Spotfire, Git/Azure DevOps