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.

Key Responsibilities:

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

#LI-GP2