Drilling & Completions Analyst

We put the unity in "opportunity." Opportunity Snapshot: • Compensation: $72.00/hour • Location: Denver, CO • Work Schedule: M-F / 40 hours+ • Duration: 12 months + • Benefits: Comprehensive benefits with 401(k), PTO and Holidays Qualifications: • Bachelor's Degree in Engineering, Computer Science, Data Science, Finance, or related field • 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 • 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). Responsibilities: • 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 • Extract, analyze, and interpret complex datasets to derive insights that drive strategic business decisions. Develop and maintain SQL queries against enterprise data systems 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 • 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 • 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 • 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 • 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 The Bergaila Way: The Bergaila Companies is a nationally recognized leader in providing staffing services to all sectors of the energy industry. We continually focus on partnering with talented professionals, engineering the perfect fit between our clients and employees. Choosing a career path with Bergaila grants you immediate access to nationally recognized organizations we partner with. Bergaila consistently attracts and retains its Employees with our dedicated internal service team, top tier benefits programs for contractors and their families, and commitment to place you in the desired career of your choice. Client Overview: Our Client is a global international energy exploration and production company and one of the largest oil producers in the United States. Founded in 1920, our client’s technical expertise and proven ability to deliver lasting results are the hallmark of their international success. While manufacturing the building blocks for life-enhancing products, our client utilizes leading edge technologies that grow their business and simultaneously help to advance a lower-carbon world.