AES Guidewire Datahub Developer Senior Associate (Sr. Analyst) - Consult

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): INRemote

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 purposeled and valuesdriven 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 youll 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 .

• 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 crossborder and/or diverse teams and engagements.

• Initiate and lead open conversations with teams clients and stakeholders to build trust.

• Uphold the firms 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 clients to navigate and capture the value of their application portfolio while costeffectively 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 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 ontime and onbudget 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 PolicyCenter BillingCenter ClaimCenter and Conversion ETL tools

• SQL competence (query performance tuning index management etc.) and a grasp of database structure are .

• 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 inperson and flex (a hybrid of inperson and virtual). Visit the following link to learn more: does not intend to hire experienced or entry level job seekers who will need now or in the future PwC sponsorship through the H1B lottery except as set forth within the following policy: 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 Colorados Equal Pay for Equal Work Act: (if blank degree and/or field of study not specified)