Hybrid Data Analyst – Oil and Gas

Posted 1 hour ago

Apply now

About the role

  • Data Analyst role at Wood Mackenzie supporting lower 48 oil and gas research and analytics team. Requires strong PySpark, Python skills and cloud technologies knowledge.

Responsibilities

  • 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
  • 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
  • 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
  • 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

Requirements

  • 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
  • Experience working with Lower 48 oil & gas or broader energy industry datasets (production, completions, well records, cost data, etc.) (preferred)
  • Experience working across hybrid environments (cloud + on-prem) (preferred)
  • Familiarity with data orchestration tools, version control, and CI/CD workflows (preferred)
  • Ability to analyze or enhance legacy code by reverse-engineering logic and improving performance (preferred)
  • Demonstrated ability or willingness to incorporate AI-driven tools into daily workflows (preferred)

Benefits

  • Equal opportunities employer
  • Committed to recruiting the best people regardless of their race, colour, religion, age, sex, national origin, disability or protected veteran status
  • Support during the hiring process for individuals with physical or mental disabilities

Job title

Data Analyst – Oil and Gas

Job type

Experience level

Mid levelSenior

Salary

Not specified

Degree requirement

No Education Requirement

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job