Data Warehouse Architect I

UAB Medicine; Birmingham (AL); On-site; USD 104,000 - 169,000; Full time

Benefits offered by this job

Educational assistance

Paid time off

Wellness programs

Parental leave

PSLF eligibility

Job summary

UAB Medicine in Alabama seeks a senior BI developer to lead analytics projects and support data platforms across the health system. You will design data extracts, dashboards, and reports using Epic Cogito, SQL, and Power BI, partnering with clinical and operational teams to translate requirements into actionable insights.

You should hold an Epic Cogito Fundamentals certification, extensive SQL expertise, and a deep understanding of healthcare data workflows.

Qualifications

• Bachelor's degree in Computer Science or related field with eight years of related experience.
• Strong SQL development skills and SSMS experience.
• Epic Cogito Fundamentals certification required.
• Experience with Cogito Tools Administration, Clarity Data Model, Caboodle Data Model, Revenue and/or Access data domains preferred.
• Healthcare data knowledge across enterprise healthcare environment.
• Analytical and problem-solving skills; strong communication and collaboration.

Responsibilities

• Lead and contribute to all phases of the BI development lifecycle.
• Partner with clinical, operational, and technical stakeholders for data integration and interpretation.
• Support enterprise reporting using Epic Cogito tools and data models.
• Design analytics solutions with non-Epic platforms like Microsoft Fabric and Power BI.
• Contribute to BI standards and mentoring of less-experienced developers.

Skills

SQL development

Epic Cogito

Healthcare data

Analytical skills

Communication

Education

Bachelor's degree in Computer Science

Tools

SSMS

Microsoft Fabric

Power BI

Cogito

Job description

Position Overview

Pay range: $104,045 - $169,075 / year

Benefits and perks available for eligible positions include: robust educational assistance programs, generous paid time off, employee assistance and wellness programs, paid parental leave, qualifying employer for the Public Service Loan Forgiveness (PSLF) Program, plus more.

Job Highlights

A team of more than600 professionals,Health System Information Services (HSIS)works to keep UAB Medicine’s IT systems and infrastructure running smoothly to deliver qualityand innovativecare to our patients. Join our nationally ranked team at UAB Medicine,amongstthetop 150 Places to Workin 2025as ranked byBecker’s Healthcare.Also, we have achieved top ratings in the Most Wired survey for a total of 21 years. .

Job Description

To independently employ broad knowledge of principles, practices, and procedures in a particular field of specialization to plan, design, develop, and support systems and projects. To conduct research and analysis and present findings for review. To carry out complex assignments, requiring development of new or improved techniques and procedures.

Core Responsibilities

• Lead and contribute to all phases of the business intelligence development lifecycle, including understanding business objectives, gathering and translating business requirements into data requirements, designing and developing data extracts, reports, dashboards, and analytics solutions, deploying and scheduling BI assets in accordance with established best practices, and producing clear, accurate, and timely technical documentation.
• Partner closely with clinical, operational, and technical stakeholders to understand source systems, data meaning, and data usage; perform data analysis and validation; and provide guidance and support related to data integration, interpretation, and downstream consumption.
• Serve as a senior technical contributor within an Epic‑centric analytics environment, supporting enterprise reporting and analytics needs using Epic Cogito tools and data models.
• When required, design and develop analytics solutions using non‑Epic platforms and tools, including Microsoft Fabric and Power BI, applying the same BI lifecycle principles and quality standards used in Epic‑based development.
• Contribute to BI standards, best practices, and technical decision‑making; support knowledge sharing and mentoring of less‑experienced developers as appropriate for a senior‑level role.

Qualifications

Bachelor's degree in Computer Science or a related field and eight (8) years of related experience required. Or an equivalent combination of relevant education and/or experience.

Required Skills and Qualifications

• Technical Expertise:
  Strong SQL development skills, including the creation, maintenance, and optimization of complex queries and stored procedures. Demonstrated ability to write efficient, scalable SQL and identify opportunities for performance improvement. Experience with SQL Server Management Studio (SSMS) required; experience with Microsoft Fabric and Power BI preferred.
• Epic Cogito Proficiency:
  Advanced experience with Epic’s Cogito platform is required. Candidate must hold a Cogito Fundamentals certification. Additional certifications or demonstrated experience with Cogito Tools Administration, Clarity Data Model, Caboodle Data Model, Revenue and/or Access data domains are preferred. Familiarity with SlicerDicer, Cogito SQL, Epic security concepts, and Nova Notes is desirable.
• Healthcare Data Knowledge:
  Strong understanding of healthcare clinical and operational data, common healthcare workflows, and how data supports operational, analytical, and decision‑making needs across an enterprise healthcare environment.
• Analytical and Problem‑Solving Skills:
  Proven ability to analyze complex data challenges, identify root causes, design effective solutions, and balance competing technical and business considerations.
• Communication and Collaboration:
  Excellent written and verbal communication skills, with the ability to collaborate effectively with both technical and non‑technical stakeholders. Demonstrated interpersonal skills to work productively across teams, departments, and organizational boundaries in a complex enterprise setting.

Why Work at UAB Medicine

We are UAB Medicine, Alabama’s largest and most comprehensive health system, recognized nationally for delivering world‑class patient care, pioneering research, and cutting‑edge medical education. We proudly serve more than 1.2 million patients each year – from every county in Alabama, all 50 states, and many countries around the world. Our network spans numerous hospitals, emergency departments, many other sites of care, and a team of over 2,000 physicians. Our key facilities include UAB Hospital – ranked the No. 1 hospital in Alabama by U.S. News & World Report and home to the state’s first ACS‑verified Level I adult trauma center and only Magnet‑designated hospital – along with UAB Hospital‑Callahan Eye and five UAB St. Vincent’s hospitals serving central Alabama.

UAB Medicine offers careers across a wide range of practice environments, from our internationally renowned academic medical center and award‑winning community hospitals to our primary and specialty care clinics across the state. Whether you’re seeking the fast‑paced learning environment of a tertiary care setting or the close‑knit environment of a community facility, there’s a place for you on our team where you can become part of a mission‑driven organization committed to delivering life‑changing care. With nearly every medical specialty represented and unlimited opportunities for growth, you’ll find the right fit for your skills and career goals. We care for you by offering comprehensive, industry‑leading benefit packages to support the individual preferences and circumstances of our diverse staff.