Mid-Level Data Integration Architect (Chicago)

Join to apply for the Mid-Level Data Integration Architect role at Jobright.ai

2 days ago Be among the first 25 applicants

Join to apply for the Mid-Level Data Integration Architect role at Jobright.ai

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

Jobright is an AI-powered career platform that helps job seekers discover the top opportunities in the US. We are NOT a staffing agency. Jobright does not hire directly for these positions. We connect you with verified openings from employers you can trust.

Job Summary:

Health Management Associates is an independent research and consulting firm specializing in publicly funded healthcare. The Data Integration Architect is responsible for designing, developing, and maintaining scalable data integration pipelines across multiple enterprise platforms to support the firms data needs.

Responsibilities:

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.

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.

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.

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:

Required:

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

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

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.

Solid understanding of integration design patterns, agile development practices, and the use of tools like Jira for task management.

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.

Preferred:

Familiarity with legal and marketing tech platforms such as IronClad and HubSpot.

Proficiency in Microsoft Office tools, including Word and Excel.

Company:

Health Management Associates is an independent research and consulting firm specializing in publicly funded healthcare. Founded in 1985, the company is headquartered in Lansing, Michigan, USA, with a team of 501-1000 employees. The company is currently Late Stage. Health Management Associates has a track record of offering H1B sponsorships.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Industries

  Software Development

Referrals increase your chances of interviewing at Jobright.ai by 2x

Inferred from the description for this job

Medical insurance

Vision insurance

401(k)

Get notified when a new job is posted.

Sign in to set job alerts for Integration Architect roles.

Chicago, IL $169,000.00-$206,000.00 1 week ago

Greater Chicago Area $169,000.00-$206,000.00 2 weeks ago

Chicago, IL $93,000.00-$151,000.00 2 weeks ago

Oak Brook, IL $130,000.00-$150,000.00 5 days ago

Chicago, IL $214,900.00-$322,300.00 1 day ago

Chicago, IL $90,000.00-$115,000.00 1 month ago

Azure Integration Architect (Middleware/Integration experience (any platform)

Chicago, IL $101,300.00-$230,790.00 1 month ago

Solutions Architect Digital Transformation

Chicago, IL $91,000.00-$141,000.00 3 days ago

Chicago, IL $140,000.00-$160,000.00 1 week ago

Chicago, IL $115,000.00-$140,000.00 4 days ago

Oracle Health Integration Architect Solution Consultant

Chicago, IL $115,000.00-$200,000.00 2 days ago

Chicago, IL $115,000.00-$200,000.00 1 day ago

Chicago, IL $122,000.00-$204,500.00 3 days ago

Solutions Architect, Healthcare Integrations (Chicago, IL)

Chicago, IL $112,410.00-$162,710.00 4 days ago

Deerfield, IL $120,000.00-$165,000.00 2 days ago

Chicago, IL $137,275.00-$178,670.00 2 weeks ago

Lisle, IL $130,000.00-$170,000.00 1 week ago

Chicago, IL $105,000.00-$135,000.00 1 week ago

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