Principal IT Architect

Concerotech; Maryland Heights (MO); On-site; USD 140,000 - 210,000; Full time

Job summary

Concerotech is seeking a hands-on Principal IT Architect to lead design and development of our healthcare data platform. You will transform requirements into robust transformation logic, optimize complex SQL, and shape the data models powering trusted, curated data at scale.

In this role you will partner with the architecture team to evolve a medallion-based data warehouse on AWS Redshift, ensuring high-quality data delivery and scalable solutions for business users across the organization.

Qualifications

• Experience in data architecture for large-scale healthcare platforms.
• Proficient in designing data models and transformation logic.
• Strong SQL development and performance tuning.
• Familiarity with healthcare data standards and privacy.

Responsibilities

• Design and deliver solutions across the healthcare data platform.
• Develop data models powering curated, business-ready data.
• Turn business requirements into transformation logic and optimized SQL.
• Collaborate with the architecture team to set design direction for the warehouse.

Skills

Data architecture

AWS Redshift

SQL optimization

Healthcare data domain

Job description

Principal IT Architect summary

We areseeking a hands-on senior data architect to design, develop and deliver solutions across its healthcare data platform, partnering with the architecture team to evolve a medallion-based data warehouse on AWS Redshift that delivers trusted, high-quality data at scale. This is a hands-on development role: the architect will turn business requirements and healthcare domain knowledge into transformation logic, write and optimize complex SQL, and develop the data models that power curated, business-ready data, as well as setting design direction.