IN_Associate – Consultant: SQL, Power BI, Python–Risk Analytics–Advisory_Gurgaon

Line of Service

Industry/Sector

Specialism

Management Level

Job Description & Summary

Why PWC

At PwC, you will be part of a vibrant community of solvers that leads with trust and creates distinctive outcomes for our clients and communities. This purpose-led and values-driven work, powered by technology in an environment that drives innovation, will enable you to make a tangible impact in the real world. We reward your contributions, support your wellbeing, and offer inclusive benefits, flexibility programmes and mentorship that will help you thrive in work and life. Together, we grow, learn, care, collaborate, and create a future of infinite experiences for each other. Learn more about us.

At PwC, we believe in providing equal employment opportunities, without any discrimination on the grounds of gender, ethnic background, age, disability, marital status, sexual orientation, pregnancy, gender identity or expression, religion or other beliefs, perceived differences and status protected by law. We strive to create an environment where each one of our people can bring their true selves and contribute to their personal growth and the firm’s growth. To enable this, we have zero tolerance for any discrimination and harassment based on the above considerations.

Job Description & Summary 

The Role

Join us as Consultant, and work on development of modern data platforms and analytics projects. This role would

require a recognised expert in data analysis using SQL, Power BI and Python. Hands-on experience of

implementation and development. Good understanding of Risk Domain is a plus.

What the Business does

Risk Analytics team focus on Risk Tech Transformation projects involving migration of on-premise

applications to cloud, data platform modernisation, application modernisation, advanced analytics and

data management concerned with risk & regulatory reporting processes.

This team provide Development, Design, oversight and support across each of the Risk & Reg Reporting

Solutions delivery towers to ensure Reporting Solutions systems and components are operationally

sound and meeting Architecture and Design standards. Ensure delivery o

*Responsibilities:  

• As Consultant /Senior Consultant –SQL & Power BI Developer, your key responsibilities will include:

  you’ll apply widely agreed data analysis and software engineering principles and methodologies to design,

  develop, test and maintain data platforms, applications and services to achieve the stated business and technology

  goals within required budgets and timelines. We’ll also look to you to oversee the quality of work, making sure

  that it meets the technical standards for all services output. You’ll need a background in data engineering / analysis

  / data science. You should also have development experience in a programming language, experience of using

  industry recognised frameworks and development tooling, and a background of implementing programming best

  practice, especially around scalability, availability and performance.

  · Hands-on experience of working on implementation and development using T-SQL, Power BI & Python

  · Experience of test-driven development alongside the use of automated test frameworks, mocking and

  stubbing and unit testing tools

  · An understanding of how to translate product and business requirements into technical solutions

  · The ability to understand and support, modify and maintain systems and code developed by other

  engineering teams

  Knowledge and Experience

  · Development experience in SQL and Power BI service to publish and schedule reports

  · Knowledge of relational, in-memory, distributed and non-SQL databases

  · Knowledge on Python is preferred

  · Experience of using industry recognised frameworks and development tooling

  · Experience of working in an environment where products have to be delivered to specific timescales

  · An understanding of how to translate product and business requirements into technical solutions

  · Experience of working with code repositories, bug tracking tools and wikis

  · Display behaviours in line with our Critical People Capabilities

  Conduct and Line of Defence

  ● Comply with Our Code, Purpose, Values, and relevant Policies

  ● Respect relevant regulatory obligations and Conduct Rules This is a first line job, as described in the

  Three Lines of Defence Principles, responsible for intelligent risk taking and managing its direct and

  consequential risks

  The Skills you’ll need

  In order to be successful in this role, you must have the following skills & experience: Qualification from an Engineering College, / M Tech / PGDCA having 3-8 year experience preferably in Banking domain. Strong knowledge of SQL, Python and Power BI along with hands-on experience. Good understanding of Risk Domain is a plus. Pro-active and capable of taking ownership of tasks. The person must have had client facing experience. Align to the organisation’s architectural direction and principles, and make sure that the applications and services being built adhere to them Liaise with lead engineers, architects, business analysts and other key stakeholders to understand the objectives and requirements Support well thought out estimates after a thorough consideration of design, build and testing of complexity and maintainability and serviceability Design and develop high-volume, high-performance and high-availability data platforms and applications using proven frameworks and technologies

*Mandatory skill sets  

• Hands on experience in Java 8/ Python

• Hands on experience in designing and developing applications using Spring / Guice 

• Hands on experience in Sprint Boot, Web service (Rest Service), Microservice based Architecture 

• Good understanding of design patterns and should be able to design solutions and algorithms. 

• Experience in migrating monolithic application to microservice will be a plus 

• Experience with NoSQL DBs. Couchbase, MongoDB will be a plus 

• Experience in any Message Queue, Kafka knowledge will be a plus 

• Exposure to OpenShift, Docker + Kubernetes will be a plus 

• Good understanding of NFRs 

• Good understanding of CICD 

*Preferred skill sets  

• Experience in Airline domain is a plus 

*Years of experience required  

4 to  9  years of experience in analysis, design, development of software systems in Java 

*Education Qualification   

• Any

Education (if blank, degree and/or field of study not specified)

Certifications (if blank, certifications not specified)

Required Skills

Optional Skills

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Available for Work Visa Sponsorship?

Government Clearance Required?

Job Posting End Date