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

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-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. 

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

(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 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. 

#LI-Remote