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.Enhancing your leadership style, you motivate, develop and inspire others to deliver quality. You are responsible for coaching, leveraging team member’s unique strengths, and managing performance to deliver on client expectations. With your growing knowledge of how business works, you play an important role in identifying opportunities that contribute to the success of our Firm. You are expected to lead with integrity and authenticity, articulating our purpose and values in a meaningful way. You embrace technology and innovation to enhance your delivery and encourage others to do the same.
Skills
Examples of the skills, knowledge, and experiences you need to lead and deliver value at this level include but are not limited to:
- Analyse and identify the linkages and interactions between the component parts of an entire system.
- Take ownership of projects, ensuring their successful planning, budgeting, execution, and completion.
- Partner with team leadership to ensure collective ownership of quality, timelines, and deliverables.
- Develop skills outside your comfort zone, and encourage others to do the same.
- Effectively mentor others.
- Use the review of work as an opportunity to deepen the expertise of team members.
- Address conflicts or issues, engaging in difficult conversations with clients, team members and other stakeholders, escalating where appropriate.
- 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.
The OpportunityWhen you join PwC Acceleration Centers (ACs), you step into a pivotal role focused on actively supporting various Acceleration Center services, from Advisory to Assurance, Tax and Business Services. In our innovative hubs, you’ll engage in challenging projects and provide distinctive services to support client engagements through enhanced quality and innovation. You’ll also participate in dynamic and digitally enabled training that is designed to grow your technical and professional skills.
Responsibilities
- Design, develop, and optimize ETL processes using SSIS, Informatica to support Guidewire data migration and integration initiatives.
- Perform data analysis, profiling, and validation to ensure data quality and consistency across PolicyCenter, BillingCenter, ClaimCenter, and related systems.
- Lead and support data conversion activities using Guidewire Policy Migration Tool (PMT) and Claim Migration Tool (CMT).
- Collaborate with functional, technical, and client stakeholders to define data mapping, transformation, and migration strategies.
- Troubleshoot and resolve data migration issues during SIT, UAT, and production cutover.
- Provide hyper-care support post-implementation to ensure smooth transition and client satisfaction.
- Adhere to data governance, compliance, and security standards while delivering migration solutions.
- Mentor junior team members and contribute to best practices in data development.
What You Must Have
- Bachelor’s degree in computer science, Information Technology, or related field (or equivalent work experience).
- 8+ years of experience in Data Dev with SSIS and Informatica, Snowflakes, Matillion's
- Solid understanding of Guidewire Core data models (Policy, Billing, Claims, and Contact Manager).
- Proven ability to handle large-scale data migration and transformation projects.
- Strong hands-on experience with SSIS (SQL Server Integration Services) and SQL development.
- Experience in Guidewire data conversion projects with PMT (Policy Migration Tool) and CMT (Claim Migration Tool).
What Sets You Apart
- Exposure to other ETL/ELT tools (Informatica, ADF, Talend, etc.).
- Knowledge of Medallion architecture (Bronze/Silver/Gold layers) and Enterprise Data Warehousing (EDW) concepts.
- Experience with Agile/Scrum project delivery.
- Insurance industry domain knowledge.
