Data Analyst - Geology at S&P Global
S&P Global is hiring a Data Analyst - Geology for its Upstream and Midstream Energy Data & Research Team in Bangalore. In this role, you will work closely with global teams to conduct primary and secondary research on global energy assets across exploration, production, transportation, and power infrastructure.
Role Overview
Role Overview
S&P Global is hiring a Data Analyst - Geology for its Upstream and Midstream Energy Data & Research Team in Bangalore. In this role, you will work closely with global teams to conduct primary and secondary research on global energy assets across exploration, production, transportation, and power infrastructure.
Key Highlights
- Company: S&P Global
- Role: Data Analyst - Geology
- Location: Bangalore, Karnataka
- Shift: Rotational / Flexible Shifts (10 AM - 7 PM IST / 2 PM - 11 PM IST)
Eligibility Criteria & Qualifications
- Degree in Geology, Petroleum Engineering, Chemical Engineering, or Power Engineering.
- Strong capability to analyze wells data, power plant metrics, and transmission log records.
- Comfortable working in flexible/rotational shifts (10 AM - 7 PM IST / 2 PM - 11 PM IST).
Key Responsibilities
Data Preparation & Quality
- •Perform data extraction, validation, and analysis for wells, pipelines, power plants, and transmission assets.
- •Track and integrate new wells, assets, land records, and operational logs into standard databases.
Analysis, Reporting & Visualization
- •Research energy companies, operators, and infrastructure projects across global regions.
- •Resolve client data queries within timelines while ensuring high data accuracy.
Insights & Stakeholder Communication
- •Analyze regulatory filings, technical reports, and industry publications to capture relevant energy data.
Required Skills & Technologies
How to Apply
Submit your application directly through S&P Global's verified careers portal.
Review the published role requirements, degree qualifications, and eligible graduation batches above.
Ensure your resume highlights relevant projects and contains working GitHub repository links.
Click the official application button below to open S&P Global's direct careers page.
Complete and submit your application directly on the employer's portal.
You will be directed to S&P Global's official careers portal. Career Insights does not process applications or charge any candidate fees.
The specifications above are verified official details published by S&P Global. Candidates should verify all final terms, deadlines, and eligibility directly on S&P Global's official careers portal before submitting an application.
Recommended Preparation
Independent editorial guidance based on the published role information.
What to Prepare
Evaluate your data analysis and quantitative background against published criteria and hands-on preparation focus areas.
B.E / B.Tech / MCA / B.Sc
Hiring evaluations prioritize demonstrable problem-solving, domain competence, and practical project evidence over specific degree pedigree.
Proficiency in relational databases, SQL queries, and data extraction.
Master complex SQL operations: Window functions (ROW_NUMBER, RANK, DENSE_RANK), CTEs, multi-table JOINs, and query execution plan analysis.
Data cleaning, transformation, and reporting dashboards.
Be prepared to clean messy datasets using Python (Pandas/NumPy) or Excel, identify statistical outliers, and explain KPI metric definitions.
Basic understanding of data storage, serialization, and persistence.
Be prepared to explain relational normalization (1NF-3NF), indexing trade-offs, foreign key constraints, and transactional consistency.
Familiarity with Git branching, pull requests, and collaborative repository management.
Review Git branch workflows, pull request code reviews, and maintain clean commit history with descriptive messages.
Onsite (Bangalore, Karnataka) operational structure.
Highlight proactive written communication, technical documentation discipline, and the ability to troubleshoot errors systematically before escalating.
Technical Topics
Depending on the hiring team’s evaluation style, technical assessments for this role typically cover these core areas:
Topic 1: Advanced SQL & Data Extraction
- Window functions (ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD)
- Common Table Expressions (CTEs), multi-table JOINs, and subqueries
- Query optimization, index utilization, and execution plan review
Topic 2: Data Cleaning, Wrangling & Validation
- Handling missing values, duplicated records, and date/time conversions
- Using Python (Pandas/NumPy) or SQL for data hygiene and transformation
- Detecting statistical outliers and verifying data distribution integrity
Topic 3: Metric Definition, KPI Modeling & Dashboard Architecture
- Designing intuitive business dashboards (Power BI, Tableau, Looker)
- Formulating unambiguous metric definitions (retention, churn, cohort LTV)
- Choosing appropriate data visualizations for business decision-making
Topic 4: Business Problem Solving with Data & Hypothesis Testing
- Formulating testable hypotheses from operational questions
- Segmenting customer or operational cohorts to isolate drivers
- Translating statistical patterns into concrete operational recommendations
Topic 5: Cross-Functional Storytelling & Analytical Communication
- Explaining data nuances and limitations to non-technical team members
- Answering questions about statistical confidence and data provenance
- Collaborative iteration with product managers and engineers
* Note: These are independent Career Insights editorial recommendations to help candidates structure their study plan. They do not represent guaranteed interview stages or official hiring mandates from S&P Global.
Practical Project
Turn the listed data skills into a portfolio exercise using a realistic dataset, analysis workflow, and decision-focused output.
Customer Cohort Retention & Churn Analyzer
A SQL-driven analytics project that calculates monthly cohort retention, customer lifetime value, and churn indicators from raw transaction tables.
Advanced SQL (Window Functions, CTEs), Data Modeling, Business Intelligence Visualization, Statistical Analysis
Include database schema diagrams, reproducible sample data generation scripts, and screenshots of key cohort insights charts.
Query optimization techniques for large event tables and how you accounted for edge cases like returning inactive users.
Career Insights recommendation: This project is an independent editorial recommendation designed to help candidates build verifiable portfolio evidence. It is not required or sponsored by S&P Global.
Before You Apply
Verify your dataset portfolios, dashboard presentations, and application materials before applying.
Ensure your resume highlights SQL queries, data manipulation projects, and interactive dashboard links involving Geology & Energy Research, Data Extraction & Validation, MS Excel & Office Tools.
Confirm that your degree, graduation year (Not specified), and location match S&P Global's criteria.
Have 1–2 data analysis projects prepared. Be ready to explain your data cleaning methodology, SQL aggregation queries, and actionable conclusions.
Submit your application directly through S&P Global's official careers portal using the verified apply link below. Career Insights does not process applications or charge any candidate fees.
Career Growth Context
Editorial analysis of how this role builds quantitative expertise and strategic analytical influence.
Data Architecture & Tooling Orientation
Familiarity with enterprise data warehouses, schema design, SQL data pipelines, and internal business metrics.
Exploratory Analysis & Dashboard Engineering
Constructing performant business intelligence dashboards, validating dataset integrity, and automating recurring analytical reporting.
Statistical Modeling & Strategic Insights
Conducting cohort analyses, predictive modeling, and identifying trends that drive product, operational, or business efficiency.
Progression Toward Senior / Lead Analytics Partner
Defining data governance standards, leading cross-functional data initiatives, and guiding organizational decision-making with executive stakeholders.
This page provides verified job details sourced from S&P Global's recruitment announcement, alongside independent preparation roadmaps authored by the Career Insights editorial team. Career Insights is not affiliated with S&P Global and does not collect candidate data or charge application fees.
Recent & Related Jobs
Active opportunities matching similar roles, technical domains, and experience levels.
Graviton Research Capital Hiring 2026 for Software Engineer | Freshers
Freshers JobsFounded in 2014, Graviton Research Capital has grown into a global quantitative trading firm where high-performance software...
Publicis Groupe Hiring 2026 for Software Engineer | 1–5 Years
Freshers JobsPublicis Groupe is a global leader in marketing, communication, and digital transformation. As a Software Engineer in the...
Franklin Templeton Hiring 2026 for Associate Software Engineer | Freshers
Software JobsFranklin Templeton is a global leader in asset management dedicated to helping clients achieve their financial goals through...
Career Insights Guides
Curated editorial roadmaps and interview preparation guides relevant to this role.
Career RoadmapYour Blueprint to Success: How to Match Your Resume With a Job Description
Unlock your dream job by mastering resume-job description matching. This guide provides practical steps for freshers and...
Career RoadmapThe AI/ML Engineer's Journey: Your Essential 2026 Skill & Career Roadmap
The landscape of Artificial Intelligence and Machine Learning is evolving at an unprecedented pace, transforming industries...
Career RoadmapAI Tools to Boost Your Productivity
Discover 10 essential AI tools like ChatGPT, Grammarly, and GitHub Copilot to supercharge your productivity, enhance...