About the Role: OSTTRA India The Role: Data Analyst The Team: The OSTTRA Technology team is composed of Capital Markets Technology professionals, who build, support and protect the applications that operate our network. The technology landscape includes high-performance, high-volume applications as well as compute intensive applications, leveraging contemporary microservices, cloud-based architectures. The Impact: Together, we build, support, protect and manage high-performance, resilient platforms that process more than 100 million messages a day. Our services are vital to automated trade processing around the globe, managing peak volumes and working with our customers and regulators to ensure the efficient settlement of trades and effective operation of global capital markets. What’s in it for you: We're 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. The Location: Gurgaon, India About Company Statement: OSTTRA is a market leader in derivatives post-trade processing, bringing innovation, expertise, processes and networks together to solve the post-trade challenges of global financial markets. OSTTRA operates cross-asset post-trade processing networks, providing a proven suite of Credit Risk, Trade Workflow and Optimisation services. Together these solutions streamline post-trade workflows, enabling firms to connect to counterparties and utilities, manage credit risk, reduce operational risk and optimise processing to drive post-trade efficiencies. OSTTRA was formed in 2021 through the combination of four businesses that have been at the heart of post trade evolution and innovation for the last 20+ years: MarkitServ, Traiana, TriOptima and Reset. These businesses have an exemplary track record of developing and supporting critical market infrastructure and bring together an established community of market participants comprising all trading relationships and paradigms, connected using powerful integration and transformation capabilities. About OSTTRA Candidates should note that OSTTRA is an independent firm, jointly owned by S&P Global and CME Group. As part of the joint venture, S&P Global provides recruitment services to OSTTRA - however, successful candidates will be interviewed and directly employed by OSTTRA, joining our global team of more than 1,200 post trade experts. OSTTRA was formed in 2021 through the combination of four businesses that have been at the heart of post trade evolution and innovation for the last 20+ years: MarkitServ, Traiana, TriOptima and Reset. OSTTRA is a joint venture, owned 50/50 by S&P Global and CME Group. With an outstanding track record of developing and supporting critical market infrastructure, our combined network connects thousands of market participants to streamline end to end workflows - from trade capture at the point of execution, through portfolio optimization, to clearing and settlement. Joining the OSTTRA team is a unique opportunity to help build a bold new business with an outstanding heritage in financial technology, playing a central role in supporting global financial markets. Learn more at www.osttra.com. What’s In It For You? 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. For more information on benefits by country visit: https://spgbenefits.com/benefit-summaries ----------------------------------------------------------- Equal Opportunity Employer S&P Global is an equal opportunity employer and all qualified candidates will receive consideration for employment without regard to race/ethnicity, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, marital status, military veteran status, unemployment status, or any other status protected by law. Only electronic job submissions will be considered for employment. If you need an accommodation during the application process due to a disability, please send an email to: EEO.Compliance@spglobal.com and your request will be forwarded to the appropriate person.  US Candidates Only: The EEO is the Law Poster http://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf describes discrimination protections under federal law. ----------------------------------------------------------- 20 - Professional (EEO-2 Job Categories-United States of America), BSMGMT203 - Entry Professional (EEO Job Group) Job ID: 307954 Posted On: 2024-10-04 Location: Gurgaon, Haryana, India