We are in search of a Senior Production Support Data Analyst who will play a pivotal role in supporting the data accuracy and completeness within our enterprise data warehouse. The ideal candidate will collaborate closely with business stakeholders and IT teams to enhance and ensure the integrity and performance of the data warehouse, which measures critical performance across all aspects of our organization's operations.
#LI-DNI
Responsibilities
- Lead the analysis and resolution of complex data issues within the data warehouse
- Design and develop comprehensive source-to-target mapping documents to capture key application data elements
- Oversee the integration of mapping documents from source systems into the data warehouse
- Collaborate with the ETL team to ensure mapping documents adhere to advanced ETL code standards
- Ensure ETL code aligns with sophisticated source-to-target mapping requirements
- Perform high-level data validation to confirm accurate data movement within the data warehouse architecture
- Act as a consultant with reporting teams to resolve any discrepancies between the data warehouse and source system applications
Want more jobs like this?
Get jobs in San Javier, Chile delivered to your inbox every week.
- Proven 3+ years' experience in data analysis within an enterprise data warehouse environment
- 2+ years of experience with Policy & Claims Insurance
- Expertise in SQL and capable of handling complex queries and data structures
- Deep knowledge of Data Warehousing concepts, advanced ETL frameworks, and BI architectures
- Expertise in creating and tuning complex Semantic layer Reporting Views
- Experience in leading data discovery sessions with senior business subject-matter experts
- Advanced understanding of RDBMS platforms such as SQL Server and DB2, including generating complex DDL
- Extensive experience and familiarity with Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI, and SAP FS-CD applications
- Excellent interpersonal skills, capability for effective written and verbal communication
- Ability to mentor and collaborate effectively within a team setting
- Highly developed organizational and analytical skills
- 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