Executive - Python+SQL

BSR & Co; Gurugram District; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A leading professional services firm in India seeks a data analytics professional with expertise in SQL and Python. The role involves analyzing large datasets, developing data pipelines with PySpark, and collaborating with various stakeholders to support their data needs. Candidates should have a strong understanding of data modeling and banking operations. This position offers opportunities for growth within the firm.

Qualifications

• Proven experience in data analytics and working with large datasets.
• Strong SQL skills for querying and managing databases.
• Experience with PySpark for large-scale data processing.

Responsibilities

• Analyze large datasets to derive actionable insights supporting decision-making processes.
• Develop and maintain data pipelines using PySpark and other tools.
• Collaborate with teams to support data infrastructure needs.

Skills

Data analytics

SQL

Python

Data modeling

CI/CD pipelines

Tools

PySpark

Hadoop

Job description

About KPMG in India

KPMG entities in India are professional services firm(s). These Indian member firms are affiliated with KPMG International Limited. KPMG was established in India in August 1993. Our professionals leverage the global network of firms, and are conversant with local laws, regulations, markets and competition. KPMG has offices across India in Ahmedabad, Bengaluru, Chandigarh, Chennai, Gurugram, Jaipur, Hyderabad, Jaipur, Kochi, Kolkata, Mumbai, Noida, Pune, Vadodara and Vijayawada.

KPMG entities in India offer services to national and international clients in India across sectors. We strive to provide rapid, performance-based, industry-focused and technology-enabled services, which reflect a shared knowledge of global and local industries and our experience of the Indian business environment.

Functional Skills

• Determining, creating, and implementing internal process improvements, such as redesigning infrastructure for increased scalability, improving data delivery, and automating manual procedures.
• Building analytical tools that make use of the data flow and offer a practical understanding of crucial company performance indicators like operational effectiveness and customer acquisition.
• Helping stakeholders, including the data, design, product, and executive teams, with technical data difficulties.
• Working on data-related technical challenges while collaborating with stakeholders, including the Executive, Product, Data, and Design teams, to support their data infrastructure needs.
• Remaining up-to-date with developments in technology and industry norms can help you to produce higher-quality results.

Technical Skills

• Analyze large datasets to derive actionable insights and support decision-making processes.
• Develop and maintain data pipelines using PySpark and other data processing tools.
• Write efficient SQL queries to extract, transform, and load data from various sources.
• Implement data models and schemas to organize and optimize data storage and retrieval.
• Perform data normalization and denormalization to ensure data integrity and accessibility.
• Collaborate with data engineers to centralize and manage data assets.
• Ensure data quality through validation and cleansing processes.
• Utilize CI/CD pipelines to streamline data deployment and maintain continuous integration.

Qualifications

• Proven experience in data analytics and working with large datasets.
• Proficiency in Python, including libraries such as Pandas and Numpy for data manipulation.
• Strong SQL skills for querying and managing databases.
• Experience with PySpark for large-scale data processing.
• Basic understanding of Hadoop and its ecosystem.
• Familiarity with data engineering concepts and best practices.
• Knowledge of data modeling, including schemas, normalization, and denormalization techniques.
• Understanding of data centralization, cardinality, and data quality principles.
• Good to have experience in CI/CD pipelines and tools.

Banking

• Deep understanding of banking operations, financial products, and regulatory frameworks

• Experience with data modeling, ETL processes, and statistical analysis
• Prior experience in retail or corporate banking analytics
• Analyze banking data including customer transactions, loan performance, and financial statements
• Support credit risk analysis and fraud detection initiatives
• Maintain and optimize banking databases and data pipelines

Equal employment opportunity information

KPMG India has a policy of providing equal opportunity for all applicants and employees regardless of their color, caste, religion, age, sex/gender, national origin, citizenship, sexual orientation, gender identity or expression, disability or other legally protected status. KPMG India values diversity and we request you to submit the details below to support us in our endeavor for diversity. Providing the below information is voluntary and refusal to submit such information will not be prejudicial to you.