AES- Guidewire Senior Associate (Sr. Analyst) - Guidewire Datahub - Operate

At PwC, our people in business application consulting specialise in consulting services for a variety of business applications, helping clients optimise operational efficiency. These individuals analyse client needs, implement software solutions, and provide training and support for seamless integration and utilisation of business applications, enabling clients to achieve their strategic objectives. As a Guidewire developer at PwC, you will specialise in developing and customising applications using the Guidewire platform. Guidewire is a software suite that provides insurance companies with tools for policy administration, claims management, and billing. You will be responsible for designing, coding, and testing software solutions that meet the specific needs of insurance organisations.

Focused on relationships, you are building meaningful client connections, and learning how to manage and inspire others. Navigating increasingly complex situations, you are growing your personal brand, deepening technical expertise and awareness of your strengths. You are expected to anticipate the needs of your teams and clients, and to deliver quality. Embracing increased ambiguity, you are comfortable when the path forward isn’t clear, you ask questions, and you use these moments as opportunities to grow.

Skills

Examples of the skills, knowledge, and experiences you need to lead and deliver value at this level include but are not limited to:

• Respond effectively to the diverse perspectives, needs, and feelings of others.
• Use a broad range of tools, methodologies and techniques to generate new ideas and solve problems.
• Use critical thinking to break down complex concepts.
• Understand the broader objectives of your project or role and how your work fits into the overall strategy.
• Develop a deeper understanding of the business context and how it is changing.
• Use reflection to develop self awareness, enhance strengths and address development areas.
• Interpret data to inform insights and recommendations.
• Uphold and reinforce professional and technical standards (e.g. refer to specific PwC tax and audit guidance), the Firm's code of conduct, and independence requirements.
  
  

Application Evolution Services (AES) - Guidewire

Lead Developer (DataHub)- Senior Associate

Job Category: Managed Services - JFG

Level: Senior Associate

Specialty/Competency: Guidewire/Managed Services

Industry/Sector: Property & Casualty

Job Type: Regular

Time Type: Full time

Travel Requirements: None

Job ID

Location(s): IN-Remote

A career in our Managed Services team will provide you an opportunity to collaborate with a wide array of teams to help our clients implement and operate new capabilities, achieve operational efficiencies, and harness the power of technology. Our Application Evolution Services (formerly Application Managed Services) team will provide you with the opportunity to help organizations harness the power of their enterprise applications by optimizing the technology while driving transformation and innovation to increase business performance. We assist our clients in capitalizing on technology improvements, implementing new capabilities, and achieving operational efficiencies by managing and maintaining their application ecosystems. We help our clients maximize the value of their investment by managing the support and continuous transformation of their solutions in the areas of sales, finance, supply chain, engineering, manufacturing and human capital.

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.

Responsibilities

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:

• 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 realizes they are required.
• Contribute technical knowledge in your area of expertise.
• 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.
  
  

Within our global, Managed Services platform, we provide Application Evolution Services (formerly Application Managed Services), where we focus more so on the evolution of our clients’ applications and cloud portfolio. Our focus is to empower our client’s to navigate and capture the value of their application portfolio while cost-effectively operating and protecting their solutions.

Basic Qualifications

Job Requirements and Preferences:

Minimum Degree Required: Bachelor Degree and/or 5 years Equivalent Experience

Preferred Qualifications

Preferred Knowledge/Skills:

Demonstrates Expert Abilities And Extensive Application Managed Service Projects And Solutioning The Smartcomm Integration With Guidewire Suite Of Applications On Premises And SaaS, With Proven Success Executing And Leading All Aspects Of Complex Engagements Within The Smartcomm Application Achieving On-time And On-budget Delivery, As Well As The Following

6+ years of experience as technical lead for Datahub and ETL tools

Strong understanding of data warehouse concepts and dimensional data modeling

Expertise with SQL queries, analytical services, reporting services

Experience With One Or More SDLC Methodologies

Expertise related to metadata management, data modeling, data model rationalization, and database products

Experience With Data Scripting And Programming

Understands context of their project within the larger portfolio

Demonstrated a strong attention to detail

Possesses Strong Analytical Skills

Demonstrated a strong sense of ownership and commitment to program goals

Strong Verbal And Written Communication Skills

Identifies and implements operational database requirements and proposed enhancements in support of requested application development or business functionality

Develops And Translates Business Requirements Into Detailed Data Designs

Maps data between systems (in conjunction with Business Analysts)

Assists engineering and development teams as application data expert from physical data models to production implementations

Identifies entities, attributes, and referential relationships for data models using a robust enterprise information engineering approach

Creates tables, indexes, constants, and assist programmers with SQL, tuning and reviews

Participates in data analysis, archiving, database design, and development activities for migration of existing data as needed

Develops ETL interfaces from source databases and systems to the data warehouse

Works closely with application development teams to ensure quality interaction with the database

Job Functions

• To be responsible for providing technical guidance or solutions
• To develop and guide the team members in enhancing their technical capabilities and increasing productivity
• To ensure process compliance in the assigned module, and participate in technical discussions or review.
• To prepare and submit status reports for minimizing exposure and risks on the project or closure of escalations.
  
  

Technologies

• Guidewire PolicyCenter, BillingCenter, ClaimCenter and Conversion ETL tools
• SQL competence (query performance tuning, index management, etc.) and a grasp of database structure are required.
• Understanding of data modeling concepts.
• Knowledge of at least one ETL tool (Informatica, SSIS, Talend, etc.)
• Knowledge of different SQL/NoSQL data storage techniques
  
  

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.