PwC Insurance Cloud Data Warehouse Engineer- Manager in Buffalo, New York
Specialty/Competency: Data, Analytics & AI
Industry/Sector: Not Applicable
Time Type: Full time
Travel Requirements: Up to 20%
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.
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 :
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.
At PwC, our work model includes three ways of working: virtual, in-person, and flex (a hybrid of in-person and virtual). Visit the following link to learn more: https://pwc.to/ways-we-work.
PwC does not intend to hire experienced or entry level job seekers who will need, now or in the future, PwC sponsorship through the H-1B lottery, except as set forth within the following policy: https://pwc.to/H-1B-Lottery-Policy.
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.
For positions based in San Francisco, consideration of qualified candidates with arrest and conviction records will be in a manner consistent with the San Francisco Fair Chance Ordinance.
For positions in Colorado, visit the following link for information related to Colorado's Equal Pay for Equal Work Act: https://pwc.to/coloradoadvisorymanager.