ETL Architect
Location: Gainesville, GA
Job Type: Direct Hire
Company: TRC Talent Solutions
Salary: $140,000 Per Year
Category: Healthcare
Job Description Apply Now
The role of ETL Architect is an advanced opportunity for experienced professionals seeking to contribute to a major healthcare system’s Data & Analytics team. This full-time position is designed for individuals who have a passion for building robust data architectures, semantic layers, and scalable solutions that directly impact the integration of advanced technologies such as artificial intelligence, large language models (LLMs), and chatbots. The ETL Architect will join a highly collaborative, innovative team and play a key role in enabling business intelligence and data-driven insights within a leading healthcare environment.
Working as an ETL Architect provides the unique chance to be at the forefront of healthcare data innovation. The position supports strategic initiatives, contributing to the design and development of essential data models that serve as the backbone for advanced analytics and emerging AI solutions. As the organization continues to invest in its digital transformation, the ETL Architect will be instrumental in shaping the data landscape and ensuring effective, secure, and high-performing systems are in place for future growth.
This position offers a dynamic, fast-paced environment where your expertise in ETL solutions, data architecture, and collaboration will be valued. As an ETL Architect, you can expect a strong focus on learning and integrating advanced cloud technologies, working closely with both technical teams and business stakeholders to deliver impactful results. Whether your background emphasizes Epic healthcare systems or leading-edge AI data modeling, your contributions will help drive the organization’s mission forward.
ETL Architect - Summary- Serve as a technical leader within the Data & Analytics team, focusing on designing, developing, and optimizing ETL processes and data models.
- Collaborate with cross-functional teams to build and maintain scalable data architectures supporting AI, analytics, and reporting initiatives.
- Apply your expertise in cloud-based ecosystems, particularly with Snowflake, dbt, and AWS, to deliver innovative solutions in a healthcare setting.
- Design and implement advanced ETL architectures and workflows that align with business and technical requirements.
- Develop semantic layers and data models to support new AI-powered tools, chatbots, and business intelligence dashboards.
- Work with modern data platforms such as Snowflake, dbt, AWS, SSIS, Databricks, or Fabric, with a strong emphasis on Snowflake and dbt.
- Participate in architectural design sessions, code reviews, and technical presentations to ensure best practices and knowledge sharing within the team.
- Collaborate with business stakeholders to understand data needs, translate requirements into technical solutions, and deliver actionable insights.
- For Epic-focused profiles: Navigate Epic systems, including Clarity and Caboodle, providing hands-on expertise in healthcare data workflows and integration.
- For AI/Data-focused profiles: Lead the development of data models and semantic layers optimized for AI, LLMs, agentic models, and chatbot solutions.
- Mentor junior team members and contribute to a culture of continuous improvement, professional development, and technical excellence.
- Support ongoing enhancements, issue resolution, and project delivery within an agile, team-oriented environment.
- Competitive compensation package aligned with senior and architect-level responsibilities in the data and analytics field.
- Comprehensive health, dental, and vision insurance options.
- Retirement savings and 401(k) plans with employer contributions.
- Opportunities for professional growth, training, and advancement within a stable healthcare organization.
- Flexible work arrangements, including remote work options for eligible candidates.
- Supportive, mission-driven work culture focused on innovation and excellence in healthcare data solutions.
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related technical field.
- 8-10+ years of experience in ETL architecture, data engineering, or development roles, preferably in a healthcare or enterprise environment.
- Proven expertise with Snowflake, dbt, and AWS is highly preferred; candidates with SSIS, Databricks, or Fabric experience and a demonstrated ability to learn new technologies are welcome.
- Epic-focused candidates must have direct, hands-on experience with Epic systems (Clarity, Caboodle); Epic certifications are a significant advantage.
- AI/Data-focused candidates should have a strong track record in building semantic layers and data models for AI, dashboards, and LLMs.
- Exceptional communication skills for interfacing with technical and non-technical stakeholders.
- Strong commitment to full-time employment, long-term retention, and a collaborative team environment.
- Experienced data architect or senior ETL developer with a passion for healthcare data innovation and digital transformation.
- Demonstrates deep technical proficiency in cloud-based data platforms, especially Snowflake and dbt.
- Has either direct Epic system experience (Clarity, Caboodle) or advanced skills in AI/ML data modeling and semantic layer development.
- Thrives in a fast-paced, collaborative environment and enjoys mentoring others.
- Possesses impeccable problem-solving and communication abilities, with a focus on delivering business value through data solutions.
- This role is part of a high-performing, stable healthcare organization known for its commitment to innovation and employee development.
- Onboarding includes an initial 30-60 day integration period focused on learning the technology stack and beginning active development on key projects.
- Opportunities to work with cutting-edge AI solutions, LLMs, and modern cloud infrastructure.
- Apply now by clicking the job application button to take the next step in your career as an ETL Architect and help revolutionize healthcare data solutions.