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
Senior II Data Analyst developing competitive pricing strategies for FedEx Express. Analyzing P&L and mentoring new joiners while collaborating across functions on complex projects.
Team Lead Engineering role focusing on AI and machine learning for data analysis at Roche. Leading a high - performing team to innovate clinical data analysis workflows.
Data Analyst working with HelioCampus to analyze higher education data trends and metrics. Supporting university partners by delivering insights, reports, and training on the data platform.
Data Analyst supporting design, development, and delivery of analytical solutions for clients in AI & Data portfolio. Collaborating with teams to implement data analytics and data science capabilities.
FP&A Data & Analytics Manager position at Hastings Direct involving management reporting and technology lead. Seeking a strong leader to support financial growth and strategic execution.
Continuous Monitoring Data Visualization Analyst supporting DoD data analytics and enhancing visualization tools for cybersecurity posture and compliance monitoring.
Treasury Quantitative Analyst developing quantitative models and analytical tools for risk management and treasury analytics. Collaborating with cross - functional teams to influence solution strategies and prepare detailed analyses.
Data Science and Analytics Manager overseeing a team to manage data solutions and analytics. Working within financial services to enhance decision making and business impact.
Master Data Analyst ensuring accurate SAP implementation and data management for TC Energy. Collaborating across teams to translate safety and engineering requirements into actionable work orders.