Data Analyst II

Data Analyst II (Contract) - Drilling & Completions Analytics About the Role We are seeking a Data Analyst II to provide analytical support to the Drilling & Completions (D&C) organization within the Rockies region. This contract position is embedded within operations and focuses on transforming complex data into actionable insights that improve operational efficiency, well delivery performance, and capital effectiveness.
The ideal candidate is a strong analytical professional who can work independently, build meaningful dashboards and reporting solutions, automate data processes, and communicate findings effectively to both technical and business stakeholders.
Key Responsibilities Data Analysis & Reporting

• Extract, analyze, and interpret operational data to support business decision-making.
• Develop and maintain SQL queries across enterprise systems including OXYODS, OpenWells, and other operational databases.
• Analyze drilling and completions performance, operational KPIs, timelines, and cost metrics.
• Translate data into actionable recommendations for operations and leadership teams.

Dashboard Development & Visualization

• Design, build, and maintain Power BI and/or Spotfire dashboards.
• Create clear and impactful visualizations for technical and non-technical audiences.
• Troubleshoot reporting issues, manage data connections, and optimize dashboard performance.
• Ensure reporting solutions align with organizational BI standards.

Process Automation & Optimization

• Automate recurring reporting and data analysis processes.
• Develop reusable SQL queries, templates, and workflows.
• Identify opportunities to improve data quality, reporting efficiency, and overall business processes.
• Support development of automated data pipelines and reporting solutions.

Stakeholder Collaboration

• Partner with D&C engineers, operations teams, and business stakeholders to understand reporting needs.
• Provide timely support for ad hoc analyses and data requests.
• Collaborate with data engineering, IT, and analytics teams to deliver solutions.
• Maintain documentation for data sources, business logic, and reporting methodologies.

Data Quality & Governance

• Perform ongoing data validation and quality control checks.
• Monitor data consistency, accuracy, and freshness across source systems.
• Identify and investigate data anomalies.
• Support master data management for wells, pads, assets, and operational hierarchies.

Required Qualifications Experience

• 3 years of experience as a Data Analyst, Business Intelligence Analyst, or similar analytical role.
• 2 years of hands-on experience writing and optimizing complex SQL queries in production environments.
• 2 years of experience building and maintaining Power BI and/or Spotfire dashboards.
• Experience supporting operations, engineering, or field-based business functions.

Technical Skills

• Advanced SQL skills, including:
  • CTEs
  • Joins
  • Subqueries
  • Aggregations
  • Window functions
  • String manipulation
• Experience with Power BI (preferred) or Spotfire.
• Strong understanding of relational databases and data modeling concepts.
• Advanced Excel skills for data analysis and reporting.
• Experience with Git, Azure DevOps, or similar version control tools is a plus.

Analytical & Problem-Solving Skills

• Strong analytical thinking and problem-solving capabilities.
• Ability to convert complex data into clear, actionable business insights.
• High attention to detail and commitment to data accuracy.
• Ability to work effectively in a fast-paced environment with evolving priorities.

Communication & Collaboration

• Excellent verbal, written, and presentation skills.
• Ability to communicate effectively with technical teams, business users, and leadership.
• Strong stakeholder management and collaboration skills.
• Self-motivated with the ability to manage multiple priorities and deadlines.

Education

• Bachelor's degree in Engineering, Computer Science, Data Science, Finance, Mathematics, or a related field.

Location

• Ability to work a hybrid schedule in Downtown Denver, Colorado.

Preferred Qualifications

• Experience in upstream oil and gas, particularly Drilling & Completions.
• Familiarity with OpenWells, Landmark, PPDM-based applications, or other well data management systems.
• Understanding of oil and gas operational metrics, including:
  • Well and pad data
  • API numbers
  • Formations and lateral lengths
  • Drilling performance metrics
  • Completion and frac data
  • Operational timelines and milestones
• Experience with Python or R for analytics and automation.
• Experience with Microsoft Power Platform (Power Automate, Power Apps).
• Familiarity with cloud data platforms such as Azure or AWS.

Tools & Technologies Databases

• OXYODS
• OpenWells
• Operational and financial planning systems

BI & Analytics Tools

• Power BI
• Spotfire
• Excel

Development Tools

• SQL Server Management Studio (SSMS)
• Git
• Azure DevOps
• Other SQL query tools

What You'll Work With You will support a wide range of stakeholders, including:

• Drilling & Completions teams
• Operations leadership
• Field personnel
• Business units
• Regulatory teams
• HSE organizations

You will work with drilling and completions data, well timelines, operational KPIs, cost metrics, and performance reporting that directly support upstream operations.
Why Join This Opportunity?

• Support critical Drilling & Completions operations in the Rockies region.
• Work with large-scale enterprise data environments.
• Deliver insights that influence operational performance and capital efficiency.
• Drive automation and process improvements.
• Collaborate with cross-functional teams across operations, engineering, and business functions.

Contract Information This is a contract position. Compensation, benefits, and employment terms will be administered through the staffing agency. Please contact your recruiter for details regarding pay rate, benefits eligibility, and contract duration.
Equal Opportunity Employer We are committed to providing equal employment opportunities to all qualified individuals. Employment decisions are based on qualifications, merit, experience, and business needs without regard to race, color, religion, national origin, sex, age, disability, veteran status, or any other protected characteristic under applicable law.

With over 90 years' combined experience, NES Fircroft (NES) is proud to be the world's leading engineering staffing provider spanning the Oil & Gas, Power & Renewables, Chemicals, Construction & Infrastructure, Life Sciences, Mining and Manufacturing sectors worldwide. With more than 80 offices in 45 countries, we are able to provide our clients with the engineering and technical expertise they need, wherever and whenever it is needed. We offer contractors far more than a traditional recruitment service, supporting with everything from securing visas and work permits, to providing market-leading benefits packages and accommodation, ensuring they are safely and compliantly able to support our clients.