Data Analyst II

About the role

The Senior Data Analyst will provide dedicated analytical support to the Drilling & Completions (D&C) organization in the Rockies region. 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.

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.

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.
• 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.
• 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.
• Strong analytical, problem-solving, and critical thinking abilities in a data-intensive environment.
• Excellent communication, presentation, and data storytelling skills.
• Strong attention to detail with focus on data accuracy and completeness.
• Self-starter who can manage multiple priorities and deadlines.

Education

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