HamburgerMenu
hirist

Master Card - Data Scientist II - ETL Modeling

MasterCard
Gurgaon/Gurugram
3 - 6 Years

Posted on: 09/12/2025

Job Description

Role :

- Work closely with global & regional teams to architect, develop, and maintain advanced reporting and data visualization capabilities on large volumes of data to support analytics and reporting needs across products, markets, and services.

- Translate business requirements into tangible solution specifications and high quality, on time deliverables.

- Create repeatable processes to support development of ETL, modelling and reporting.

- Effectively use tools to manipulate large-scale databases, synthesizing data insights.

- Provide 1st level insights/conclusions/assessments and present findings via Tableau/PowerBI dashboards, Excel, and PowerPoint.

- Apply quality control, data validation, and cleansing processes to new and existing data sources.

All About You :

- Years experience in data engineering and management, data mining, data analytics, data reporting, data product development and quantitative analysis.

- Advanced SQL skills, ability to write optimized queries for large data sets.

- Expert in writing stored procedures, functions and views is preferable.

- Experience on Platforms/Environments: Cloudera Hadoop, Big data technology stack, SQL Server, Microsoft BI Stack, Cloud, Snowflake, and other relevant technologies.

- Exposure to Python, Scala, Hive, Impala, Spark, Cloud, and other related technologies.

- Experience in data pipeline creation via tools such as Alteryx, SSIS etc.

- Advanced knowledge of any of the job scheduling tools such as Apache Airflow, NIFI, and other related tools.

- Experience with any one of data visualization tools (Tableau, Domo, and/or PowerBI/similar tools).

- Experience with data validation, quality control and cleansing processes to new and existing data sources.

- Experience presenting data findings in a readable and insight driven format.

- Experience in building support decks.

- Must be able to interact with management, internal stakeholders and collect requirements.

- Must be able to perform in a team, use judgment and operate under ambiguity.

- Financial Institution or a Payments experience a plus.

Education :

- Bachelors or Masters degree in a Computer Science, Information Technology, Engineering, Mathematics, Statistics, M./M. preferred.

Additional Competencies :

- Excellent English, quantitative, technical, and communication (oral/written) skills.

- Analytical/Problem Solving.

- Strong attention to detail and quality.

- Creativity/Innovation.

- Self-motivated, operates with a sense of urgency.

- Project Management/Risk Mitigation.

- Able to prioritize and perform multiple tasks simultaneously.

Corporate Security Responsibility :

All activities involving access to Mastercard assets, information, and networks comes with an inherent risk to the organization and, therefore, it is expected that every person working for, or on behalf of, Mastercard is responsible for information security and must.

- Abide by Mastercards security policies and practices.

- Ensure the confidentiality and integrity of the information being accessed.

- Report any suspected information security violation or breach, and.

- Complete all periodic mandatory security trainings in accordance with Mastercards guidelines.

Corporate Security Responsibility :

All Activities Involving Access To Mastercard Assets, Information, And Networks Comes With An Inherent Risk To The Organization And, Therefore, It Is Expected That Every Person Working For, Or On Behalf Of, Mastercard Is Responsible For Information Security And Must:.

- Abide by Mastercards security policies and practices;.

- Ensure the confidentiality and integrity of the information being accessed;.

- Report any suspected information security violation or breach, and.

- Complete all periodic mandatory security trainings in accordance with Mastercards guidelines.


info-icon

Did you find something suspicious?