Senior Production Support Data Analyst

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.
We accept CVs in English only.

#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

• 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

• 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
• Health Coverage - Health and wellness are important, that is why we have you and up to four family members in a premiere health plan. We have a couple of options, so you can choose what is best for you and your family
• Visual Benefit - Seeing your work for us would be a sight for sore eyes. We want your vision to always be at 100% which is why we offer up to $200.000 COP for any visual health expenses
• Life Insurance Plan - We have partnered with MetLife to offer a full-coverage Ife insurance plan. So, your family is covered, even if you are gone
• Medical Leave Coverage - We are one of the few companies that cover 100% of your medical leave, for up to 90 days. Your health is the most important thing to us
• Professional Growth Opportunities - We have designed a highly competitive and complete development process, where you will have all the tools to get where you have always wanted to be, personally and professionally
• Stock Option Purchase Plan - As an EPAMer you can be more than just an employee, you will also have the opportunity to purchase stock at a reduced price and become a part owner of our organization
• 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
• Community Benefit - You will be part of a worldwide community of over 50,000 employees, where you can learn, challenge yourself, stand out, and share your knowledge and experience with multicultural teams!