Industry / Sector
Insurance
Specialism
Guidewire
Management Level
Senior Associate
Job Description & Summary
A career within Functional and Industry Technologies services will provide you with the opportunity to build secure and new digital experiences for customers employees and suppliers. We focus on improving apps or developing new apps for traditional and mobile devices as well as conducting usability testing to find ways to improve our clients user experience.
As part of our team youll help clients harness technology systems in financial services focusing on areas such as insurance sales performance management retirement and pension asset management and banking & capital markets.
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 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 :
- 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 firms code of ethics and business conduct.
The Opportunity
When 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 our innovative hubs youll engage in challenging projects and provide distinctive services to support client engagements through enhanced quality and also participate in dynamic and digitally enabled training that is designed to grow your technical and professional skills.
As part of the Guidewire Developer team you design and implement data solutions that align with business strategies. As a Senior Associate you analyze complex problems mentor others and uphold elevated standards. You focus on building client relationships and developing a deeper understanding of the business context while navigating increasingly complex situations to grow your personal brand and technical proficiency.
Responsibilities
Design develop and implement ETL processes to extract transform and load data from diverse sources into data warehouses or other target systems.Optimize ETL processes for performance reliability and scalability.Maintain and enhance existing ETL workflows while adhering to established data standards and best practices.Ensure data integrity and quality across all data transfers by implementing validation and error-checking mechanisms.Document ETL processes including design development testing and operational procedures.Collaborate with business analysts and stakeholders to understand data requirements and ensure alignment with business needs.Interface and communicate with the onsite team.Participate in scrum calls and provide status reports.Conduct data validation and reconciliation to ensure data accuracy and completeness post-migrationTake part in CoE activities trainings recruitments as required and interested.What You Must Have
Bachelors Degree4 years of experienceETL SQL SSISOral and written proficiency in English requiredWhat Sets You Apart
Primary Skill - ETL Tools : SSIS / SQL MSSQL DB2 Data Stage InformaticaSecondary Skill - Reporting Tool - Tableau IBM Cognos Power BICloud Concepts - Azure ADF Snowflake MatillionStrong knowledge of ETL tools such as SQL Server Integration Services (SSIS) Informatica or ADF SQL and Data WarehousingHands-on design workflow development and performance tuning experience in data warehouse SQL Server / Oracle.Experience with cloud-based data solutions is a plus (e.g. Azure Data Factory AWS Glue).Good to have Hands on experience in at least one of the Guidewire products (Claim Center / Policy Center / Billing Center / PMT / CMT)Working experience with Guidewire Policy Claims and Billing Conversion using SSIS is strongly preferred.Must be experienced in designing and building complete ETL process.Should have good exposure in writing Stored Procedures Functions View Triggers Indexes using SQLExperience in DB management migrating data transforming data and data integrity.Good written and oral communication.Experience in Agile SCRUM or SAFe methodology.Travel Requirements
Not Specified
Job Posting End Date
Required Experience :
Senior IC
Key Skills
CCTV,Computer Science,Corporate Marketing,E Learning,Arabic English Translation
Employment Type : Full-Time
Experience : years
Vacancy : 1