Job Description

A career in our Analytics Technology practice, within Data and Analytics Technology services, will provide you with the opportunity to help organisations uncover enterprise insights and drive business results using smarter data analytics. We focus on a collection of organisational technology capabilities, including business intelligence, data management, and data assurance that help our clients drive innovation, growth, and change within their organisations in order to keep up with the changing nature of customers and technology. Youll make impactful decisions by mixing mind and machine to leverage data, understand and navigate risk, and help our clients gain a competitive edge. Our team helps clients navigate various analytics applications to get the most value out of their technology investment and foster confidence in their business intelligence. As part of our team, youll help our clients implement enterprise content and data management applications that improve operational effectiveness and provide impactful data analytics and insights.

To really stand out and make us fit for the future in a constantly changing world, each and every one of us at PwC needs to be a purpose-led and values-driven leader at every level. To help us achieve this we have the PwC Professional; our global leadership development framework. It gives us a single set of expectations across our lines, geographies and career paths, and provides transparency on the skills we need as individuals to be successful and progress in our careers, now and in the future.

As a Senior Associate, you'll work as part of a team of problem solvers, helping to solve complex business issues from strategy to execution. PwC Professional skills and responsibilities for this management level include but are not limited to:

* Use feedback and reflection to develop self awareness, personal strengths and address development areas.
* Delegate to others to provide stretch opportunities, coaching them to deliver results.
* Demonstrate critical thinking and the ability to bring order to unstructured problems.
* Use a broad range of tools and techniques to extract insights from current industry or sector trends.
* Review your work and that of others for quality, accuracy and relevance.
* Know how and when to use tools available for a given situation and can explain the reasons for this choice.
* Seek and embrace opportunities which give exposure to different situations, environments and perspectives.
* Use straightforward communication, in a structured way, when influencing and connecting with others.
* Able to read situations and modify behavior to build quality relationships.
* Uphold the firm's code of ethics and business conduct.

Job Requirements and Preferences:

Basic Qualifications:

Minimum Degree Required:
Bachelor Degree

Required Fields of Study:
Computer and Information Science, Computer and Information Science & Accounting, Economics, Economics and Finance, Economics and Finance & Technology, Engineering, Operations Management/Research, Statistics

Additional Educational Requirements:

Other quantitative fields of study may be considered

Minimum Years of Experience:
3 year(s)

Required Knowledge and Skills:

Demonstrates thorough knowledge of, and proven success with a role, executing various aspects of the business or information technology-related client engagements and/or projects within a professional services environment, including knowledge of an industry or functional domain and specialization in the following areas:

* Possessing working knowledge and experience in Life Insurance Domain;
* Defining real time pipelines to ingest data from various sources (AS400, Oracle, SQLServer, delimited files, AVRO, JSON etc. ) to AWS data lake (S3);
* Defining detailed streaming ingestion pattern using KAFKA including KAFKA topic, producer and consumer configuration;
* Defining EMR Spark job design/flow to read KAFKA cluster and update data lake(AWS S3) and data warehouse (Neptune/Redshift) in a Near real time fashion;
* Defining and advising on design of redshift and Neptune table/graph design;
* Deploying redshift clusters and write scripts to define/update redshift tables (Sort key, distribution key etc. );
* Deploying Neptune cluster and write scripts in Gremlin to traverse, create, update, delete Apache Tinkerpop Neptune graph database;
* Utilizing performance tuneing redshift and Neptune tables;
* Utilizing performance tuneing Kafka cluster (partitions, brokers, rebalancing etc.; and,
* Advising on setting up IAM policies and roles on data lake and data warehouse.

Preferred Qualifications:

Certification(s) Preferred:

AWS Solution Architect Professional Certification

Preferred Knowledge/Skills:

Demonstrates thorough abilities and/or a proven record of success in consulting-related projects within a professional services environment that utilize creative thinking skills and individual initiative, including the following:

* Working knowledge and experience with: AWS, Data Analysis, Data Modeling, ETL, Data Transformation;
* Working knowledge of Apache EMR Spark, Scala, Apache AirFlow, Apache Tinkerpop, Gremlin Console;
* Working knowledge of AWS MSK (Kafka), Confluent Schema Registry, Lambda, Redshift, Neptune,DynamoDB, KMS, Cloud watch, Secrets Manager, AWS DMS, Amazon S3;
* Possessing experience in designing real time data lakes and data warehouses using KAFKA, EMR and other AWS services; and,
* Possessing experience in data warehousing and ETL/ELT concepts .