Data Analyst II

Job#: 3040621

Job Description:

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

Experience

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.

Work Location

Ability to work a hybrid schedule in downtown Denver, CO.

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

Primary Stakeholders: Drilling & Completions teams, 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, operational KPIs, cost data, milestone dates

Tools: SQL Server Management Studio, Other query tools, Excel, Power BI, Spotfire, Git/Azure DevOps

ABOUT THIS OPPORTUNITY

Directly support Drilling & Completions teams driving upstream operations in the Rockies region. Work with cutting-edge data systems supporting major oil & gas operations. Contribute to high-impact business decisions affecting well delivery and capital efficiency. Drive automation and innovation that improves operational efficiency. Gain exposure to enterprise-scale data environments and cross-functional collaboration.

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .

Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRateds Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.

Everforth Apex uses a virtual recruiter as part of the application process. Click for more details. By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Everforth Apex and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at

Everforth Apex Benefits Overview: Everforth Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Everforth Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Everforth Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Everforth Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Everforth Apex team member can provide.

Everforth Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Everforth Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law.

If you require an accommodation under the Americans with Disabilities Act to participate in an interview with a virtual recruiter or to use our website for a search or application, please contact our Benefits Department at or . Please note that this contact information is strictly to be used for medical ADA accommodations and that no other inquiries will be answered.

UnitedHealthcare creates and publishes the Transparency in Coverage Machine-Readable Files on behalf of Everforth Apex Systems.