What are the responsibilities and job description for the Data Integration Specialist position at Endeavor Health?
Position Highlights
When you work for Endeavor Health, you will be part of an organization that encourages its employees to achieve career goals and maximize their professional potential.
Please explore our website (www.endeavorhealth.org) to better understand how Endeavor Health delivers on its mission to “help everyone in our communities be their best”.
Endeavor Health is committed to working with and providing reasonable accommodation to individuals with disabilities. Please refer to the main career page for more information.
Diversity, equity and inclusion is at the core of who we are; being there for our patients and each other with compassion, respect and empathy. We believe that our strength resides in our differences and in connecting our best to provide community-connected healthcare for all.
EOE: Race/Color/Sex/Sexual Orientation/ Gender Identity/Religion/National Origin/Disability/Vets, VEVRRA Federal Contractor.
- Position: Data Integration Specialist
- Hourly Pay Range: $41.64 - $64.54. The hourly pay rate offered is determined by a candidate’s expertise and years of experience, among other factors.
- Location: 4901 Searle Parkway, Skokie IL
- Full Time
- Hours: Monday-Friday, 8am - 4:30pm
- Hybrid Schedule: primarily remote work after initial onsite period.
- 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.
- Gathers business requirements by conducting meetings/interviews, and facilitating large-group/cross-functional sessions with customers, while containing the scope of the initiative.
- 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
- Education: 4-year college degree in computer science/information systems preferred or equivalent experience.
- Experience:
- 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
- Strong analytical, problem solving, negotiation, issue resolution and facilitation skills are required
- Excellent written and verbal communication and decision-making skills
- Experience and understanding of data sources including 3rd party RDBMS, SQL server and Oracle
- Experience in QA/QC testing a plus
- Project management skills a plus
- Experience with Business Intelligence tool a plus
- Familiarity with healthcare industry, healthcare information systems is a plus
- Premium pay for eligible employees
- Career Pathways to Promote Professional Growth and Development
- Various Medical, Dental, Pet and Vision options
- Tuition Reimbursement
- Free Parking
- Wellness Program Savings Plan
- Health Savings Account Options
- Retirement Options with Company Match
- Paid Time Off and Holiday Pay
- Community Involvement Opportunities
When you work for Endeavor Health, you will be part of an organization that encourages its employees to achieve career goals and maximize their professional potential.
Please explore our website (www.endeavorhealth.org) to better understand how Endeavor Health delivers on its mission to “help everyone in our communities be their best”.
Endeavor Health is committed to working with and providing reasonable accommodation to individuals with disabilities. Please refer to the main career page for more information.
Diversity, equity and inclusion is at the core of who we are; being there for our patients and each other with compassion, respect and empathy. We believe that our strength resides in our differences and in connecting our best to provide community-connected healthcare for all.
EOE: Race/Color/Sex/Sexual Orientation/ Gender Identity/Religion/National Origin/Disability/Vets, VEVRRA Federal Contractor.
Salary : $42 - $65
