Data Management Consultant ETL - EMEA
- Department: Professional Services
- Location: Madrid, Spain
- Country: Spain
Location: Remote EMEA, commuting to customer sites in Europe. Fluency in English plus French , Spanish , German or Italian is a must
Guidewire exists to deliver the industry platform that P&C insurers rely upon to adapt and succeed in a time of accelerating change—and to ensure that every customer succeeds in the journey. We provide the software, services, and partner ecosystem to enable our customers to run, differentiate, and grow their business.
Guidewire InsurancePlatform is the P&C industry platform that unifies software, services, and partner ecosystem to power our customers’ business. InsurancePlatform provides the standard upon which insurers can engage their customers, optimize their operations, drive smart decisions, and innovate quickly. We are privileged to serve more than 350 P&C insurers in 32 countries. We invest heavily in R&D to build a technology platform that combines three elements—core processing, data and analytics, and digital engagement—to enhance insurers’ ability to engage and empower their customers and employees.
Customer Success through collaboration on-site. To accomplish that we employ a flexible travel schedule of traveling to the customer on Mondays to return on Thursday which has been called the 3-4-5 in the industry: 3 nights away, 4 days onsite, with the fifth day working from home. We have a Global Mobility team to ensure you have the right support.
Guidewire place strong emphasis on employee development and this role provides opportunities for exposure to the full data management domain within Guidewire. The individual is expected to work closely with other Guidewire staff, customers and partners to successfully implement Guidewire Data Management projects.
Our persistent Operational Data Store (ODS) unifies, standardizes and stores data from disparate systems and external sources and allows our customers to accelerate legacy replacement and BI development. Our Enterprise Data Warehouse (EDW) purpose-built for P&C insurance provides information for BI, analysis, and enhanced decision making by providing a holistic view through conformed data from the entire enterprise.
Essential duties of this position include:
Work in a hands-on capacity to customize and deliver Guidewire data management solutions using ETL tools in the areas of Business Intelligence, Data Migration and Data Integration;
Perform Data Profiling, Data Analysis and Data Mapping;
Participate in Data Modeling activities, to extend the persistent ODS and the EDW;
Develop ETL logic to integrate and/or migrate data from legacy systems and Guidewire applications via the persistent ODS;
Design and Develop ETL logic to extend and publish data marts in the EDW from the persistent ODS;
Test and execute initial and delta loads of both the persistent ODS and the EDW;
Fine-tune all ETL Processes to maximize performance.
To be successful in this role you will need to have a majority of the following technical skills:
Experience in or knowledge of relational database theory;
Knowledge of data-warehousing, Data Marts (including star and snowflake schemas) and BI
Design best practices and techniques;
Experience in or knowledge of Data Mapping and Data Modeling;
SQL scripting skills (TSQL and/or PL/SQL), including query optimization;
Experience using ETL tools (e.g. SAP (Business Objects Data Services) - preferred, Informatica, SSIS).
You’ll also need the following attributes:
Fluency in French , Spanish, Italian or German
Effective communication skills including ability to deliver effective presentations and demos; ability to work with a broad spectrum of people;
Effective writing skills; ability to produce clear, concise and high-quality customer facing technical and business documents;
A desire to work collaboratively in a small, cross-functional team;
A strong sense of accountability and self-motivation;
An ability to think critically and an aptitude for problem solving; good trouble shooting skills;
Bachelor’s degree preferably in Computer Science or a related field.
Willingness and ability to travel 80% within the region. Guidewire employs a flexible travel model that requires consultants to be on site four days per week and away from home three nights per week. Consultants work the fifth day from their home office. These roles represent Guidewire Software on customer site.
Additional nice to have skills/experience include:
Experience in or knowledge of Agile project delivery practices;
Experience in or knowledge of XML and Object Oriented Programming;
Experience in or knowledge of BI/ Reporting tools (e.g. SQL Server Reporting Services (SSRS),
Crystal Reports, Cognos etc.);
Experience in property and casualty insurance.
The successful candidate is expected to become proficient in the capabilities of our products and related ETL and BI technologies.
Guidewire Software Inc. provides equal employment opportunities to all applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. All offers are contingent upon passing a criminal history and other background checks where it's applicable to the position.