AES - Guidewire DataHub Lead Developer - Senior Associate

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Guidewire

Management Level

Senior Associate

Job Description & Summary

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 Guidewire Application Evolution 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 Guidewire investment by managing the support and continuous transformation of their solutions in the areas of insurance solutions such as Policy Center, Billing Center and Claim Center as well as Guidewire analytics and data solutions.

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.

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: <JOB ID>

Location(s): IN-Hybrid

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.

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.

Job Requirements and Preferences:

Basic Qualifications:

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 Datahub integration with Guidewire Suite of applications on premises and SaaS, with proven success executing and leading all aspects of complex engagements within the Datahub 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:

(1) To be responsible for providing technical guidance or solutions 

(2) To develop and guide the team members in enhancing their technical capabilities and increasing productivity 

(3) To ensure process compliance in the assigned module, and participate in technical discussions or review. 

(4) To prepare and submit status reports for minimizing exposure and risks on the project or closure of escalations.

Technologies

• Guidewire Datahub, Integration with Guidewire suite of applications 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, Snowflake 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.

#LI-Remote

Education (if blank, degree and/or field of study not specified)

Degrees/Field of Study required:

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

Optional Skills

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Not Specified

Available for Work Visa Sponsorship?

No

Government Clearance Required?

No

Job Posting End Date