ETL Architect

Emids is a leading provider of digital transformation solutions to the healthcare industry, serving payers, providers, life sciences, and technology firms. Headquartered in Nashville, emids helps bridge critical gaps in providing accessible, affordable, and high-quality healthcare by providing digital transformation services, custom application development, data engineering, business intelligence solutions, and specialized consulting services to all parts of the healthcare ecosystem. With nearly 2,500 professionals globally, emids leverages strong domain expertise in healthcare-specific platforms, regulations, and standards to provide tailored, cutting-edge solutions and services to its clients.

Role: Data Architect

Location: Louisville, KY (Onsite)

Mode of Hire: Contract-Hire

As a Data Architect, you will be responsible for designing and managing the overall data architecture strategy and framework. You will work closely with ETL developers, business analysts, and other stakeholders to understand data requirements, ensuring that data solutions align with business goals and technical requirements. This role requires expertise on migrating current state DTS packages to Future state SSIS Packages as per standards. Required to manage internal and customer stack holders.

Key Responsibilities:

• Design and implement data architecture solutions that meet business requirements and technical constraints.
• Oversee the design, development, and maintenance of ETL processes using SQL Server Integration Services (SSIS).
• Lead the migration of legacy DTS packages to SSIS, ensuring optimal performance and minimal disruption.
• Develop and enforce best practices for data integration, data quality, and data governance.
• Collaborate with business analysts, ETL developers, and other stakeholders to understand data requirements and translate them into data architecture solutions.
• Ensure data quality and integrity throughout the data lifecycle.
• Develop and maintain comprehensive documentation for data architecture, data flows, and ETL processes.
• Provide technical leadership and mentoring to ETL developers and other team members.
• Conduct regular reviews and updates to the data architecture to ensure it meets changing business needs and technological advancements.
• Stay current with industry trends and best practices in data architecture, data integration, and data management.

Technical Skills:

• 12 to 15 years of experience in data architecture, data integration, and ETL development.
• Extensive experience with SQL Server, including database design, development, and performance tuning.
• Strong expertise in SSIS and proven experience migrating DTS packages to SSIS.
• In-depth understanding of data warehousing concepts, data modeling, and data governance.
• Excellent problem-solving skills and attention to detail.
• Strong communication and interpersonal skills, with the ability to work effectively with stakeholders at all levels.
• Experience leading and mentoring technical teams.
• Certification in data architecture or related fields.

Nice to Have:

• Healthcare Experience: Familiarity with healthcare technology standards , Formats

Here at Emids we're not scared of differences. It's how we break new ground. As we scale and elevate the experience of our clients in the Healthcare & LifeSciences Space and ultimately have an impact on every patient from every walk of life, the team we build must be reflective of the diversity that we serve. Together, we've built and will continue to grow, a diverse and inclusive culture where everyone has a seat at the table and the space to be their most authentic self. Emids believes in being an Equal Opportunity Employer and we support, celebrate, and cherish all the things that make our teammates who they are.

Here at Emids we're not scared of differences. It's how we break new ground. As we scale and elevate the experience of our clients in the Healthcare & LifeSciences Space and ultimately have an impact on every patient from every walk of life, the team we build must be reflective of the diversity that we serve. Together, we've built and will continue to grow, a diverse and inclusive culture where everyone has a seat at the table and the space to be their most authentic self. Emids believes in being an Equal Opportunity Employer and we support, celebrate, and cherish all the things that make our teammates who they are.