Talent.com
IDMC Architect

IDMC Architect

NorthShore University HealthSystemSkokie, IL, US
job_description.job_card.1_day_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
  • serp_jobs.job_card.part_time
job_description.job_card.job_description

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.

Position Highlights :

  • Position : Data Integration Specialist
  • Location : Skokie, IL / Warrenville, IL / Arlington Heights, IL
  • Full Time
  • Hours : Monday-Friday, 8 : 00am - 4 : 30pm
  • Hybrid Role
  • Some travel to other corporate locations (above) may be required.

What you will do :

  • 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.
  • 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 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
  • 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 (For full time or part time positions) :

    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

    Endeavor Health is a fully integrated healthcare delivery system committed to providing access to quality, vibrant, community-connected care, serving an area of more than 4.2 million residents across six northeast Illinois counties. Our more than 25,000 team members and more than 6,000 physicians aim to deliver transformative patient experiences and expert care close to home across more than 300 ambulatory locations and eight acute care hospitals - Edward (Naperville), Elmhurst, Evanston, Glenbrook (Glenview), Highland Park, Northwest Community (Arlington Heights) Skokie and Swedish (Chicago) - all recognized as Magnet hospitals for nursing excellence. For more information, visit

    www.endeavorhealth.org.

    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.

    J-18808-Ljbffr

    serp_jobs.job_alerts.create_a_job

    Architect • Skokie, IL, US

    Job_description.internal_linking.related_jobs
    • serp_jobs.job_card.promoted
    Enterprise Architect

    Enterprise Architect

    Compunnel, Inc.Chicago, IL, United States
    serp_jobs.job_card.full_time
    We are seeking an experienced Enterprise Architect with deep expertise in cloud and SaaS architectures to lead resiliency assessments and ensure alignment with organizational standards for reliabil...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    Enterprise Architect Consultant

    Enterprise Architect Consultant

    Coalfire SystemsChicago, Illinois, United States, 60611
    serp_jobs.job_card.full_time
    We celebrate diversity and are committed to respecting one another, embracing individual differences, and creating an inclusive environment for all employees. Enterprise Architect Consultant.Coalf...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Senior Solution Architect - Presales

    Senior Solution Architect - Presales

    Informatica LLCChicago, IL, United States
    serp_jobs.job_card.full_time
    Build Your Career at Informatica.We seek innovative thinkers who believe in the power of data to drive meaningful change. At Informatica, we welcome adventurous minds eager to solve the world's most...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Enterprise Architect – Underwriting Portfolio(s)

    Enterprise Architect – Underwriting Portfolio(s)

    CNAChicago, IL, United States
    serp_jobs.job_card.full_time
    You have a clear vision of where your career can go.And we have the leadership to help you get there.At CNA, we strive to create a culture in which people know they matter and are part of something...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    Solution Architect

    Solution Architect

    Barrow Wise ConsultingChicago, IL, USA
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Enjoy problem-solving, need a venue to display your creativity, and emerging technologies pique your interest; if so, Barrow Wise Consulting, LLC is for you. As a multi-disciplined leader, you under...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Enterprise Architecture Coordinator

    Enterprise Architecture Coordinator

    Spectraforce TechnologiesDeerfield, IL, United States
    serp_jobs.job_card.full_time
    Title : Enterprise Architecture Coordinator.Need a coordinator to help move things along and keep track of tasks.We are seeking a highly organized and proactive Enterprise Architecture Coordinator t...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    D365 F&O Senior Solution Architect

    D365 F&O Senior Solution Architect

    Hitachi Vantara CorporationChicago, IL, United States
    serp_jobs.job_card.full_time
    Hitachi Solutions is a global Microsoft solutions integrator focused on industry-focused solutions and business transformation through Microsoft technologies. We support clients to unify, automate, ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Enterprise Architect

    Enterprise Architect

    Ironclad Inc.Chicago, IL, United States
    serp_jobs.job_card.full_time
    Every dollar earned, relationship formed, and advantage gained comes down to the contract that makes it real.But getting a contract done is more complicated than it should be.And when contract data...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    Full Stack Engineer / Solution Architect

    Full Stack Engineer / Solution Architect

    IPS Technology ServicesDeerfield, IL, us
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Full Stack Engineer / Solution Architect.We need CVS Health background and CVS pharmacy system experienced Candidate • • • •. Solution Architect with 15+ years experience.Yrs of Exp – Design, develop, a...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Senior Presales Solution Architect

    Senior Presales Solution Architect

    Informatica LLCChicago, IL, United States
    serp_jobs.job_card.full_time
    Build Your Career at Informatica.We seek innovative thinkers who believe in the power of data to drive meaningful change. At Informatica, we welcome adventurous, work-from-anywhere minds eager to ta...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Enterprise Architect

    Enterprise Architect

    IroncladChicago, IL, United States
    serp_jobs.job_card.full_time
    Every dollar earned, relationship formed, and advantage gained comes down to the contract that makes it real.But getting a contract done is more complicated than it should be.And when contract data...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Cloud IT-Solution Architect

    Cloud IT-Solution Architect

    BlnksChicago, IL, United States
    serp_jobs.job_card.full_time
    Opdrachtgever : Hoogheemraadschap De Stichtse Rijnlanden.Duur : 1 oktober 2025 – 31 december 2025, met optie tot 2 x 6 maanden verlenging. Reageren vóór : woensdag 17 september 2025, 10 : 00 uur.Als Clou...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    IFS Manufacturing Solution Architect

    IFS Manufacturing Solution Architect

    Baker Tilly Advisory Group, LPUSA, Illinois, Chicago
    serp_jobs.job_card.full_time
    Baker Tilly is a leading advisory, tax and assurance firm, providing clients with a genuine coast-to-coast and global advantage in major regions of the U. New York, London, San Francisco, Los Angele...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Director Enterprise Integration Architect

    Director Enterprise Integration Architect

    KPMG CareersChicago, IL, United States
    serp_jobs.job_card.full_time
    Develop a business-aligned integration architecture strategy covering all aspects of integration (API, data, files, B2B, and more), ensuring designs adhere to security, compliance, and data governa...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    Solution / Technical Architect

    Solution / Technical Architect

    KonnectITChicago, Illinois, US
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Solution / Technical Architect.This role is responsible for designing robust, scalable, and secure enterprise solutions that align with business needs and technical strategy.The successful candidat...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Application Architect

    Application Architect

    TEKsystemsNorth Chicago, Illinois, US
    serp_jobs.job_card.full_time
    Architect with Life Sciences experience-understanding validated systems, complaint management systems, and quality management systems (QMS), TrackWise Digital is not a need but is preferred! Descri...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Senior AI / ML Specialist Solutions Architect (AI Infra & Cloud)

    Senior AI / ML Specialist Solutions Architect (AI Infra & Cloud)

    LavendoChicago, IL, US
    serp_jobs.job_card.full_time
    Our client is a publicly traded company at the forefront of the AI revolution, offering an.The company provides cutting-edge infrastructure, including large-scale GPU clusters, cloud platforms, too...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Architect

    Architect

    CorcentricDowners Grove, IL, United States
    serp_jobs.job_card.full_time
    Direct the integration platform service improving integration process efficiency and enabling seamless data exchange.Provide architectural guidance and implementation support for integration platfo...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Architect 6, Enterprise Architecture

    Architect 6, Enterprise Architecture

    ComcastChicago, IL, United States
    serp_jobs.job_card.full_time
    Responsible for promoting use of industry and Company technology standards.Monitors emerging technologies / technology practices for potential use within the company. Designs and develops updated infr...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    D365 F&SCM Technical Architect

    D365 F&SCM Technical Architect

    Pearson CarterChicago, IL, United States
    serp_jobs.job_card.full_time
    D365 F&SCM Technical Architect.I’m working closely with a leading Microsoft Solution Partner that’s expanding its Dynamics 365 Finance & Supply Chain Management practice following a series of major...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30