Filtr uses AI to scan 1000+ jobs and finds postings that perfectly matches your resume

Endeavor Health needs to design and develop data warehouse/data mart applications utilizing Informatica to extract data from their Epic electronic medical record system and/or other sources to support their mission of providing quality healthcare.

Requirements

• 4+ years of enterprise data warehouse industry experience
• 4+ years of experience with ETL design, development, architecture and implementing data warehouse data marts,
• Informatica Power Center experience a plus
• 4+ years of experience in writing complex SQL
• Experience and understanding of data sources including 3rd party RDBMS, SQL server and Oracle
• Experience in QA/QC testing a plus
• Experience with Business Intelligence tool a plus

Responsibilities

• Design and develop the data warehouse/data mart applications utilizing Informatica tool to extract data from our Epic electronic medical record system and/or other sources.
• Responsible for the identification of data items through research, analysis, profiling, data mining, and data discovery of the source data from Epic and other clinical ancillary systems.
• Interact with business analysts and IT analysts to efficiently and clearly interpret business requirement specification into detail data mappings.
• Design and develop complex SQL queries.
• Document data standards, requirement specifications, and business processes.
• Responsible for establishing best practices for several developers working in the same environment on different projects.
• Sharing on-call production support with other members of the programming staff. At times, this may require resolving production problems during off hours such nights, weekends and holidays

Other

• Gathers business requirements by conducting meetings/interviews, and facilitating large-group/cross-functional sessions with customers, while containing the scope of the initiative.
• Strong analytical, problem solving, negotiation, issue resolution and facilitation skills are required
• Excellent written and verbal communication and decision-making skills
• Project management skills a plus
• Familiarity with healthcare industry, healthcare information systems is a plus