> Markdown version of [/jobs/ext/1761382-data-analyst](https://www.wearedevelopers.com/jobs/ext/1761382-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Analyst - **Company:** Airswift - **Location:** Denver, CO, United States - **Experience:** Expert - **Contract:** Temporary contract - **Skills:** Microsoft Excel, Application Programming Interfaces (APIs), Amazon Web Services, Microsoft Azure, Big Data, Cloud Computing, Computer Programming, Customer Data Management, Data Auditing, Data Governance, Data Integrity, Data Presentation, Relational Databases, Revision Control Systems, Python (Programming Language), Power BI, SQL Databases, Freeform SQL, Microsoft Power Automate, Sql Optimization, Git, Information Technology, Data Management, SQL Server Management Studio (SSMS), Spotfire, Powerapps - **Published:** July 1, 2026 - **Apply:** https://www.airswift.com/jobs/data-analyst-ii-1276397 ## About the Role The ideal candidate is a self-starter with strong SQL and BI expertise, exceptional problem-solving skills, and the ability to communicate complex data insights to both technical and executive stakeholders., * 3+ years of experience as a Data Analyst, Business Intelligence Analyst, or similar role. * 2+ years of experience writing complex SQL queries in production environments. * 2+ years of hands-on experience building and maintaining Power BI and/or Spotfire dashboards. * Experience supporting operations, engineering, or field teams in a data-intensive environment. Technical Skills * Advanced SQL skills including: + Common Table Expressions (CTEs) + Subqueries + Joins + Aggregations + Window functions + String manipulation * Proficiency with Power BI (preferred) or Spotfire. * Strong understanding of relational databases and data modeling concepts. * Advanced Microsoft Excel skills for analysis and reporting. * Experience with version control tools such as Git or Azure DevOps is a plus. Analytical & Problem-Solving Skills * Strong analytical, troubleshooting, and critical-thinking abilities. * Ability to transform large, complex datasets into meaningful business insights. * Exceptional attention to detail and commitment to data accuracy. * Comfortable working with ambiguity and evolving business requirements. Communication & Collaboration * Excellent communication, presentation, and data storytelling skills. * Ability to communicate effectively with stakeholders at all organizational levels, including executive leadership. * Strong collaboration skills across technical and business teams. * Self-motivated with the ability to manage multiple priorities and deadlines., * Bachelor's degree in: + Engineering + Computer Science + Data Science + Finance + Or a related field Work Location * Ability to work a hybrid schedule in Downtown Denver, Colorado., * Drilling & Completions knowledge and/or upstream oil & gas industry experience. * Experience with well data management platforms such as OpenWells, Landmark, PPDM-based applications, or similar systems. * Understanding of oil & gas operational metrics, including: + Well-level data (API numbers, pads, formations, lateral lengths) + Drilling metrics (spud dates, drill days, directional surveys) + Completion metrics (stages, proppant volumes, pumping schedules, frac timelines) * Programming experience in Python and/or R. * Experience with Microsoft Power Platform (Power Automate, Power Apps). * Experience working with cloud platforms such as Azure or AWS., * SQL Server Management Studio (SSMS) * SQL Query Tools * Power BI * Spotfire * Microsoft Excel * Git * Azure DevOps ## Description We are seeking a Senior Data Analyst to support a Drilling & Completions (D&C) organization by transforming complex operational data into actionable insights that drive efficiency, performance, and capital optimization. In this role, you will partner with engineering, operations, and leadership teams to deliver analytics, dashboards, and automated reporting solutions that support critical business decisions., Data Analysis & Insights * Extract, analyze, and interpret complex datasets to support strategic decision-making. * Develop and maintain SQL queries against enterprise and operational data systems. * Analyze drilling and completions performance, schedules, costs, and operational KPIs. * Translate technical findings into actionable business recommendations. * Identify trends, risks, and opportunities to improve operational performance. Dashboard Development & Visualization * Build, maintain, and enhance Power BI and/or Spotfire dashboards. * Create intuitive visualizations for technical and non-technical stakeholders. * Troubleshoot reporting issues and optimize dashboard performance. * Ensure reporting solutions align with enterprise business intelligence standards. * Support ongoing reporting and data visualization initiatives. Process Automation & Optimization * Design and implement automation solutions to streamline business processes. * Identify repetitive manual workflows and improve efficiency through automation. * Develop reusable SQL scripts, stored procedures, and data pipelines. * Continuously evaluate opportunities to optimize reporting and analytics processes. Collaboration & Stakeholder Support * Partner closely with D&C engineers, operations teams, and business stakeholders. * Collaborate with data engineers, data scientists, and IT teams. * Provide timely support for ad hoc analysis and reporting requests. * Document data definitions, business logic, and reporting methodologies. * Serve as a trusted advisor for data-driven decision-making. Data Quality & Governance * Develop data validation processes and perform ongoing quality control reviews. * Monitor data integrity and proactively identify anomalies or inconsistencies. * Support master data management initiatives across operational assets and well data. * Promote best practices in data governance and reporting accuracy., * Operations Teams * Field Personnel * Business Units * Regulatory Teams * Health, Safety & Environment (HSE) Systems & Data * Enterprise operational and financial data systems * Well data management systems * Operational reporting platforms ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Data Science, ML & AI in the Oil and Gas Industry at NDT Global - Dr. Katja Träumner](https://www.wearedevelopers.com/videos/1308-data-science-ml-ai-in-the-oil-and-gas-industry-at-ndt-global-dr-katja-traumner) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany)