PwC Insurance Cloud Data Warehouse Engineer- Senior Manager in Rochester, 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 Senior 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:
Encourage everyone to have a voice and invite opinion from all, including quieter members of the team.
Deal effectively with ambiguous and unstructured problems and situations.
Initiate open and candid coaching conversations at all levels.
Move easily between big picture thinking and managing relevant detail.
Anticipate stakeholder needs, and develop and discuss potential solutions, even before the stakeholder realises they are required.
Contribute technical knowledge in area of specialism.
Contribute to an environment where people and technology thrive together to accomplish more than they could apart.
Navigate the complexities of cross-border and/or diverse teams and engagements.
Initiate and lead open conversations with teams, clients and stakeholders to build trust.
Uphold the firm's code of ethics and business conduct.
Basic Qualifications :
Minimum Degree Required :
Minimum Years of Experience :
Preferred Qualifications :
Certification(s) Preferred :
- Certification in one of the following cloud platforms - 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);
Understanding of Data Warehousing concepts (normalization, OLAP, OLTP, Vault data model, graphs, star & snowflake schemas);
Demonstrating relevant project management experience in organizing and leading teams including 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;
Understanding of file and object-based storage solutions using Azure ADLS 2.0 or AWS S3;
Applying 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;
Implementing enterprise data solutions concepts 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 a 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 strong consulting experience in strategy through execution projects;
Leading the ideation and development of accelerators/prebuilt solutions that package leading practices and enable rapid deployment of high quality solutions for our clients;
Leading and shaping the development of and execution of GTM strategy and industry specific offerings / assets;
Leading the development and delivery of sales support materials for Data Integration opportunities, including delivery of client training and industry events;
Acting as a subject matter specialist on Data architectures/tools/solutions, leveraging your knowledge and experience to meet client’s needs;
Leading and driving the sizing effort related to Data work, plan and build strong teams utilizing onsite/offshore mix, utilizing deployment models for efficient delivery of solution;
Performing as a team leader by creating a positive environment, building team members based on coaching and mentoring, shaping next generation of Data Integration leaders;
Monitoring workloads of the team while meeting client expectations and respecting the work-life quality of team members; and,
Providing candid feedback in a timely manner and keeping leadership informed of progress and issue.
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/coloradoadvisoryseniormanager.