PwC Insurance Cloud Data Warehouse Engineer- Manager in St Louis, Missouri
Specialty/Competency: Data and Analytics Technologies
Industry/Sector: Not Applicable
Time Type: Full time
Travel Requirements: Up to 40%
A career within Data and Analytics 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. We make impactful decisions by mixing mind and machine to leverage data, understand and navigate risk, and help our clients gain a competitive edge.
You’ll focus on aligning client data strategies to their business strategy. You will assist clients in choosing a platform, defining their data needs and migrating them to a modern cloud data environment using cloud providers such as Azure, Google Cloud Platform, Amazon Web Services, Snowflake, Databricks or Teradata.
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 :
Minimum Years of Experience :
Preferred Qualifications :
Certification(s) Preferred :
- Certification in one of the following cloud platform - AWS/Azure/GCP
Preferred Knowledge/Skills :
Demonstrates abilities and/or success in one or more of the following areas:
Possessing understanding and experience with modern cloud data architectures and engineering for one or more of the following cloud providers - AWS, Azure, GCP;
Being highly organized; Proven track record of implementing cloud data architecture and data integration patterns (AWS Glue, Azure Data Factory, Event Hub, Databricks, etc.), storage and processing (Redshift, Azure Synapse, BigQuery, Snowflake); Infrastructure as code (CloudFormation, Terraform);
Possessing a deep knowledge of Data Warehousing concepts (normalization, OLAP, OLTP, Vault data model, graphs, star & snowflake schemas)
Possessing relevant work experience in Big data engineering (Hadoop, Spark, Scala, Kafka) and ETL pipeline development (tools: IICS/AWS Glue/SAP BODS/ SSIS/SnapLogic); preferable in P&C Insurance data warehouse;
Possessing proven knowledge in SQL, report generation using visualization tools such as Tableau/Power BI/Cognos, programming using Python/Spark;
Improving advanced analytics solutions, AI/ML models, and operationalizing based on ML Ops process;
Having end-to-end knowledge of implementing enterprise data solutions such as Master Data Management, Data Governance and Enterprise Data Warehouse;
Architecting and driving delivery of high availability, scalable, process and storage intensive solutions architectures to data integration/migration, analytics and insights, AI and ML;
Understanding and familiarity of one or more is a big plus - CI/CD, cloud devops, containers (kubernetes/Docker, etc.);
Possessing P&C Insurance industry experience, including proven understanding of insurance data, underlying KPIs and how they are used; and,
Understanding of Insurance product like Guidewire (PolicyCenter, BillingCenter, & ClaimsCenter).
Demonstrates thought leader-level abilities with, and/or a proven record of success directing efforts in the following areas:
Demonstrating prior Big 4 or proven consulting experience in strategy through execution projects;
Managing and streamlining data warehouse team and lead in creation of cloud data warehouse plans, roadmap, success metrics, and assessment of client’s enterprise (on-premise and on-cloud) data systems;
Working closely with business stakeholders to capture and document business objectives/requirements, ability to translate business and technology objectives to next generation cloud, digital and technology solution architectures;
Coordinating and providing guidance to technology teams and architects to define and develop technology solutions; and,
Demonstrating critical thinking and problem-solving methods and skills;
Demonstrates considerable experience identifying and addressing client needs such as:
Building, maintaining and utilizing networks of client relationships and community involvement;
Communicating value propositions;
Using appropriate facilitation techniques to gain agreement or move others to action;
Managing resource requirements, project workflow, budgets, billing and collections; and,
Preparing and/or coordinating complex written and verbal materials.
Demonstrates extensive experience as a team leader with following skills:
Supervising teams to create an atmosphere of trust;
Seeking diverse views to encourage improvement and innovation; and,
Coaching staff including timely meaningful written and verbal feedback.
For positions in Colorado, visit the following link for information related to Colorado's Equal Pay for Equal Work Act: https://pwc.to/coloradoadvisorymanager.