What s in it for you: Were seeking a skilled Data Analyst with a strong foundation in Oracle/PLSQL/Data Warehousing/Business Intelligence to join our Osttra Analytics team. You will be responsible for developing and maintaining the Osttra BI platform, primarily using Qliksense, and ensuring it remains a powerful tool for data-driven decision-making. You will work closely with stakeholders to understand their needs and translate them into effective BI solutions.
This is an excellent opportunity to be part of a team based out of Gurgaon and to work with colleagues across multiple regions globally.
Responsibilities:
BI Platform Development: Design, develop, and maintain the Osttra BI platform, primarily using Qliksense.
Data Modeling & ETL: Design and implement efficient data models. Develop and maintain ETL processes using Oracle/PLSQL to extract, transform, and load data from various sources into the BI platform.
Data Analysis & Visualization: Conduct ad-hoc data analysis using complex SQL queries to answer business questions. Create insightful visualizations and interactive dashboards to present data effectively using Qliksense.
Performance Optimization: Monitor and optimize the performance of the BI platform, ETL processes, and SQL queries.
Collaboration: Work closely with stakeholders to gather requirements, provide training, and ensure user adoption of the BI platform.
What We re Looking For:
3+ years of relevant experience in Oracle/PLSQL/Data Warehousing/Business Intelligence.
Proficiency in Oracle database programming (SQL, PL/SQL).
Strong experience in designing and implementing ETL processes.
Expertise in writing complex SQL queries and PL/SQL procedures for data extraction and transformation.
Proficiency in developing Qliksense applications, including data modeling, visualization, and dashboard creation.
Ability to analyze data to identify trends, patterns, and insights.
Excellent written and verbal communication skills.
Strong analytical and problem-solving skills.
Experience with Google Cloud Platform (GCP) for data warehousing and cloud-based BI solutions.
Familiarity with Looker or other BI tools (PowerBI, Tableau).
Experience with AWS services (CloudFormation, CloudWatch, EC2, QuickSight, Lambda).
Understanding of GIT pipelines and Test-Driven Development.
Benefits:
We take care of you, so you can take care of business. We care about our people. That s why we provide everything you and your career need to thrive at S&P Global.
Our benefits include:
Health & Wellness: Health care coverage designed for the mind and body.
Flexible Downtime: Generous time off helps keep you energized for your time on.
Continuous Learning: Access a wealth of resources to grow your career and learn valuable new skills.
Invest in Your Future: Secure your financial future through competitive pay, retirement planning, a continuing education program with a company-matched student loan contribution, and financial wellness programs.
Family Friendly Perks: It s not just about you. S&P Global has perks for your partners and little ones, too, with some best-in class benefits for families.
Beyond the Basics: From retail discounts to referral incentive awards small perks can make a big difference.
