PwC Insurance Cloud Data Warehouse Engineer- Senior Associate in Buffalo, New York
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.
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 :
Minimum Years of Experience :
Preferred Qualifications :
Certification(s) Preferred :
Certification in one of the following cloud platform - AWS/Azure/GCP
Certification in Guidewire data platform
Preferred Knowledge/Skills :
Demonstrates abilities and/or success in one or many of the following areas:
Understanding and experience with modern cloud data architectures and engineering for one or more of the following cloud providers - AWS, Azure, GCP;
Implementing cloud data architecture and data integration patterns for one or more of the cloud providers (AWS Glue, Azure Data Factory, Event Hub, Databricks, etc.), storage and processing (Redshift, Azure Synapse, BigQuery, Snowflake); Infrastructure as code (CloudFormation, Terraform);
Understanding and deep knowledge of Data Warehousing concepts (normalization, OLAP, OLTP, Vault data model, graphs, star & snowflake schemas);
Applying knowledge and relevant work experience in Big data engineering (Hadoop, Spark, Scala, Kafka) and ETL pipeline development tools (tools: IICS/AWS Glue/SAP BODS/ SSIS/SnapLogic); preferable in P&C/L&A Insurance data warehouse;
Developing 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;
Designing and developing advanced analytics solutions, AI/ML models, and operationalizing based on ML Ops process;
Understanding of enterprise data concepts such as Master Data Management Data Governance and Enterprise Data Warehouse;
Applying leading practices in supporting high availability, scalable, process and storage intensive solutions architectures to data integration/migration, analytics and insights, AI and ML requirements;
Understanding and familiarity of one or more is a big plus - CI/CD, cloud devops, containers (kubernetes/Docker, etc.);
Understanding of insurance data, underlying KPIs and how they are used; and,
Demonstrating prior P&C/L&A Insurance industry experience.
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;
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;
Understanding how the application of analytical techniques correlated to business value and being able to select the appropriate analytical techniques for the problem at hand;
Willing to learn and apply modern, cloud-based technology skills, ability to research emerging trends, analyst publications, and adoption of modern technologies in solution architectures;
Collaborating and contributing as a team member: understanding personal and team roles, contributing to a positive working environment by building proven relationships with team members, proactively seeking guidance, clarification and feedback;
Prioritizing and handling multiple tasks, researching and analyzing pertinent client, industry and technical matters, utilizing problem-solving skills, and communicating effectively in written and verbal formats to various audiences (including various levels of management and external clients) in a professional business environment; and,
Coaching and collaborating with associates who assist with this work, including providing coaching, feedback and guidance on work performance.
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/coloradoadvisoryseniorassociate.