Data Integration Architect (Chicago)

Join to apply for the Data Integration Architect role at Health Management Associates

19 hours ago Be among the first 25 applicants

Join to apply for the Data Integration Architect role at Health Management Associates

Get AI-powered advice on this job and more exclusive features.

Job Summary

The Data Integration Architect is responsible for designing, developing, and maintaining scalable, secure, and efficient data integration pipelines across multiple enterprise platforms. This role supports the firms data integration needs by developing and maintaining workflows that ensure accurate, timely, and well-documented data movement. The position plays a critical role in supporting enterprise-wide systems and ensuring data consistency across business applications.

Job Summary

The Data Integration Architect is responsible for designing, developing, and maintaining scalable, secure, and efficient data integration pipelines across multiple enterprise platforms. This role supports the firms data integration needs by developing and maintaining workflows that ensure accurate, timely, and well-documented data movement. The position plays a critical role in supporting enterprise-wide systems and ensuring data consistency across business applications.

Responsibilities

Work Performed and Job Requirements

• ETL Design & Development
• Design and implement scalable ETL pipelines across platforms including Deltek Vantagepoint, Salesforce, Salesforce Marketing Cloud, IronClad, HubSpot, and Microsoft SQL Server.
• Build and maintain automated data flows using tools such as Workato, CData, and SQL Server Integration Services (SSIS).
• Write complex SQL queries, stored procedures, and scripts for data extraction, transformation, and validation.
• Push and stage data using SQL Server to support integration efforts.
• Integration Management & Operations
• Monitor and troubleshoot data pipelines to ensure consistent and reliable performance.
• Provide production support for existing ETL processes, including issue resolution and root cause analysis.
• Perform performance tuning and optimization of ETL and data integration processes.
• Collaboration & Project Coordination
• Partner with business and technical stakeholders to define data requirements and deliver integrated, high-quality data solutions.
• Collaborate with cross-functional teams using project management tools such as Jira to manage timelines and deliverables.
• Communicate issues, risks, and status updates proactively to leadership.
• Governance, Documentation & Testing
• Develop and maintain technical documentation, including data flow diagrams, process maps, and integration specifications.
• Contribute to the enforcement of data governance and quality standards.
• Conduct software reviews and support testing activities to ensure data integrity and functionality.
• All other duties as assigned.

Qualifications

Education/Training

Minimum of a bachelors degree in computer science, data engineering, information systems, or related field required.

Experience

Minimum of 5 years of professional experience in data integration, ETL development, and system interoperability required.

Knowledge, Skills, And Abilities

• Strong experience in data integration, ETL development, and enterprise platforms such as Salesforce, Deltek Vantagepoint, and Salesforce Marketing Cloud.
• Proficiency in SQL and experience working with enterprise data warehouses, APIs, and integration tools such as Workato, CData, and SSIS.
• Familiarity with legal and marketing tech platforms such as IronClad and HubSpot.
• Solid understanding of integration design patterns, agile development practices, and the use of tools like Jira for task management.
• Proficiency in Microsoft Office tools, including Word and Excel.
• Strong analytical, problem-solving, and troubleshooting skills with keen attention to data accuracy and detail.
• Effective communicator with the ability to collaborate across technical and non-technical teams.
• Ability to organize, prioritize, and manage multiple projects in a fast-paced environment while maintaining quality and accuracy.
• Proactive, adaptable, and self-motivated with a desire for continuous learning and improvement.
• Discreet and professional in handling confidential and sensitive information.
• Ability to mentor junior team members and contribute to team development.

EEO

Equal Opportunity Employer/Protected Veterans/Individuals With Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractors legal duty to furnish information. 41 CFR 60-1.35(c)

Additional Info

The posted salary range for this role at HMA includes a range of factors that we consider when making compensation decisions. These factors include but are not limited to experience, education, training, skills, licensures, and certifications, along with other business and organizational needs. HMA may adjust the posted salary range estimate for applicable geographic differentials associated with the location where we may fill the position. At HMA, we generally do not hire an individual at or near the top of the range for their role. All compensation decisions are dependent on the variables of each case. A reasonable estimate of the existing salary range for this position is $110,000-$140,000 annually.

HMA offers a robust benefits package for full-time colleagues. Benefits include health, dental, vision, group life/AD&D, voluntary life/AD&D, short-term disability, long-term disability, paid parental leave, paid time off, paid holidays, 401(k) employer match and safe harbor contribution, and our long-term equity incentive plan.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Engineering and Information Technology

• Industries

  Hospitals and Health Care

Referrals increase your chances of interviewing at Health Management Associates by 2x

Get notified about new Integration Architect jobs in Chicago, IL .

Physical Therapist (PT) $20,000 Sign On Bonus

Leadership Development Rotational Program

Instructional Design & Academic Technology Specialist

Solutions Engineer - Return and Interstore

Campus Planner, Real Estate and Workplace Services Planning

Deerfield, IL $98,600.00-$157,500.00 16 hours ago

Associate Director, Capital Projects, Facilities and Space Infrastructure

Deerfield, IL $98,600.00-$157,500.00 16 hours ago

Associate Product Designer - US Based Remote

Practice Development Consultant - Chicago

Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr