Endeavor Health
Overview
Data Integration Specialist
role at
Endeavor Health .
Position Highlights
Position: Data Integration Specialist
Location: Skokie, IL; Warrenville, IL; Arlington Heights, IL
Employment type: Full Time
Hours: Monday–Friday, 8:00 am–4:30 pm
Hybrid Role
Some travel to other corporate locations may be required
Compensation 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.
What You Will Do
Design and develop the data warehouse/data mart applications utilizing Informatica 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 specifications into detailed 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.
What You Will Need
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 PowerCenter 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 with 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 tools a plus
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
Familiarity with healthcare industry, healthcare information systems is a plus
Benefits
Incentive pay for select positions
Opportunity for annual increases based on performance
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
EOE: Race/Color/Sex/Sexual Orientation/ Gender Identity/Religion/National Origin/Disability/Vets, VEVRRA Federal Contractor.
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Information Technology
Industries
Hospitals and Health Care
#J-18808-Ljbffr
role at
Endeavor Health .
Position Highlights
Position: Data Integration Specialist
Location: Skokie, IL; Warrenville, IL; Arlington Heights, IL
Employment type: Full Time
Hours: Monday–Friday, 8:00 am–4:30 pm
Hybrid Role
Some travel to other corporate locations may be required
Compensation 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.
What You Will Do
Design and develop the data warehouse/data mart applications utilizing Informatica 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 specifications into detailed 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.
What You Will Need
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 PowerCenter 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 with 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 tools a plus
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
Familiarity with healthcare industry, healthcare information systems is a plus
Benefits
Incentive pay for select positions
Opportunity for annual increases based on performance
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
EOE: Race/Color/Sex/Sexual Orientation/ Gender Identity/Religion/National Origin/Disability/Vets, VEVRRA Federal Contractor.
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Information Technology
Industries
Hospitals and Health Care
#J-18808-Ljbffr