PwC Analytics Insights - Data Architect Manager in Chicago, Illinois
Specialty/Competency: Data and Analytics Technologies
Industry/Sector: FS X-Sector
Time Type: Full time
Government Clearance Required: No
Available for Work Sponsorship: Yes
Travel Requirements: Up to 80%
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. You’ll 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, you’ll 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 Manager, 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:
Develop new skills outside of comfort zone.
Act to resolve issues which prevent the team working effectively.
Coach others, recognise their strengths, and encourage them to take ownership of their personal development.
Analyse complex ideas or proposals and build a range of meaningful recommendations.
Use multiple sources of information including broader stakeholder views to develop solutions and recommendations.
Address sub-standard work or work that does not meet firm’s/client’s expectations.
Use data and insights to inform conclusions and support decision-making.
Develop a point of view on key global trends, and how they impact clients.
Manage a variety of viewpoints to build consensus and create positive outcomes for all parties.
Simplify complex messages, highlighting and summarising key points.
Uphold the firm’s code of ethics and business conduct.
Job Requirements and Preferences :
Basic Qualifications :
Minimum Degree Required :
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 :
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 :
Degree Preferred :
Master of Science
Certification(s) Preferred :
AWS Solution Architect Professional Certification
Preferred Knowledge/Skills :
Demonstrates extensive 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.
All qualified applicants will receive consideration for employment at PwC without regard to race; creed; color; religion; national origin; sex; age; disability; sexual orientation; gender identity or expression; genetic predisposition or carrier status; veteran, marital, or citizenship status; or any other status protected by law. PwC is proud to be an affirmative action and equal opportunity employer.