Wood Mackenzie is the integral leader in analytics, insights and proprietary data across the entire energy and natural resources landscape.
For over 50 years our work has guided the decisions of the world's most influential energy producers, utilities companies, financial institutions and governments.
Now, with the world's energy system more complex and interconnected than ever before, sector-specific views are no longer enough.
That's why we've redefined what's possible with Intelligence Connected.
By fusing our unparalleled proprietary data with the sharpest analytical minds, all supercharged by Synoptic AI, we deliver a clear, interconnected view of the entire value chain.
Our trusted team of 2,700 experts across 30 countries breaks siloes and connects industries, markets and regions across the globe.
This empowers our customers to identify risk sooner, spot opportunities faster and recalibrate strategy with confidence - whether planning days, weeks, months or decades ahead.
Wood Mackenzie
Intelligence Connected
**Wood Mackenzie Brand Video**
**Wood Mackenzie Values**
- Inclusive - we succeed together
- Trusting - we choose to trust each other
- Customer committed - we put customers at the heart of our decisions
- Future Focused - we accelerate change
- Curious - we turn knowledge into action
**Overview**
**Key Responsibilities**:
**Data Engineering & Pipeline Development**:
- Design, develop, and maintain data pipelines using PySpark, Python, and cloud-native tools.
- Build and optimize ETL processes for ingesting, transforming, and validating large oil and gas datasets.
- Integrate data from cloud environments into unified models.
**Data Quality & Governance**:
- Perform data discovery, cleansing, validation, and anomaly detection.
- Conduct thorough quality assurance across multiple datasets (production, completions, costs, well attributes, etc.).
- Create and maintain data flow diagrams,



source-to-target mappings, and documentation.
**Process Improvement & Support**:
- Reverse-engineer existing scripts, workflows, and legacy logic to understand data lineage and implement improved solutions.
- Collaborate closely with the research and analytics teams to understand data needs and provide timely insights.
- Drive automation and process optimization, including leveraging AI tools and frameworks to improve analyst workflows.
**Documentation & Communication**:
- Produce comprehensive technical and functional documentation, including SOPs, design specs, and system overviews.
- Work with cross-functional teams using tools such as Jira, Confluence, TFS, Excel, PowerPoint, and Visio.
**Qualifications**:
**Essential**:
- Experience in data analysis, data engineering, or data development.
- Strong programming skills in PySpark and Python.
- Experience with AWS or other cloud platforms for data development and integration.
- Ability to work with large, complex datasets and develop scalable data solutions.
- Strong analytical, troubleshooting, and problem-solving skills.
- Excellent verbal and written communication skills, including documentation.
**Preferred**:
- Experience working with Lower 48 oil & gas or broader energy industry datasets (production, completions, well records, cost data, etc.).
- Experience working across hybrid environments (cloud + on-prem).
- Familiarity with data orchestration tools, version control, and CI/CD workflows.
- Ability to analyze or enhance legacy code by reverse-engineering logic and improving performance.
- Demonstrated ability or willingness to incorporate AI-driven tools into daily workflows.
**Soft Skills**:
- Detail-oriented, with a strong sense of ownership and accountability.
- Comfortable working in a fast-paced research-driven environment.
- Flexible, collaborative, and able to communicate complex technical topics clearly.
**Equal Opportunities

📌 Data Analyst - Oil And Gas (Xico)
🏢 Wm De Mexico, De C.V.
📍 Xico