In this critical position, you will shape data architecture strategies and solutions for our enterprise data warehouse. You will work closely with business and IT teams to ensure that our data systems are robust and efficient. If you are ready to make an impact in the data space, we encourage you to apply.

#LI-DNI

Responsibilities

Collaborate with business stakeholders and IT teams to define and document data architecture and modeling needs
Architect and design comprehensive solutions for the enterprise data warehouse, sourcing data from multiple insurance and reinsurance systems
Design and implement Source to Target mappings optimized for high-volume data integration
Create logical and physical data models and implement them on Microsoft SQL Server platforms
Work closely with the development team to ensure accurate translation of mappings into code
Develop strategies for data collection and ingestion and write SQL-based solutions to validate data accuracy and integrity
Analyze and design enterprise data models for optimal reporting and support reporting teams in utilizing the data warehouse effectively
Participate in release planning and validate changes post-deployment
Develop Microsoft SQL Server views for reporting and dashboard development
Troubleshoot and optimize SQL and Informatica mappings and stored procedures

Requirements

5 years of data architecture and design experience with development teams
3 years of experience within the insurance and reinsurance domain
Advanced experience extracting data from insurance applications
Extensive knowledge of data warehousing, ETL and business intelligence architectures
Capability to create and tune semantic layer reporting views
Knowledge of relational database management systems platforms including Microsoft SQL Server
B.S. degree in Computer Information Science, Information Management, or Statistics
Strong interpersonal skills with proficiency in both written and verbal communication
Ability to work collaboratively as part of a team
Strong organizational and analytical skills

Nice to have

Knowledge of Guidewire Policy Center and Guidewire Claims Center
Familiarity with SAP Financial Services Collections and Disbursements and SAP Financial Accounting General Ledger applications

We offer

Improved medical coverage - EPAMers are eligible to participate in a supplementary health insurance program that shall have the usual coverage in the industry, with the Company funding 100% of the value of the monthly premium for participation
Lunch Allowance - You will receive a daily allowance of CLP $ 7,000 per working day. Enjoy a nice meal on us
Allowance for internet and electricity - You will receive an allowance of CLP $15,000 per month to cover internet and electricity expense
National Holiday Bonus - We celebrate joining the Chilean Market. That is why all our employees will receive a bonus of CLP $86,646 in September
Christmas Bonus - You will receive an End of Year bonus of CLP $170,539. It will be paid during the month of December, to ensure you have a Happy Holiday!
Learning Culture - We want you to be the best version of yourself, that is why we offer unlimited access to learning platforms, a wide range of internal courses, and all the knowledge you need to grow professionally
Additional Income - Besides your regular salary, you will also have the chance to earn extra income by referring talent, being a technical interviewer, and many more ways
Are you open to relocation? - If you want to relocate to another country and we have the right project, we will assist you every step of the way, to help you and your family, reach your new home