Global Data Architect — Data Warehouse & BI Leader

Kedrion Biopharma GmbH; Northern (KY); On-site; USD 105,000 - 165,000; Full time

Benefits offered by this job

Health Coverage

Dental & Vision

Life Insurance

Retirement Savings

Paid Time Off

Training & Development

Job summary

Kedrion Biopharma Inc. is seeking a Data Architect to design scalable data models and a global data warehouse. You will build ETL pipelines, enforce data governance, and drive analytics strategies across the organization.

The role collaborates with business and IT teams to translate requirements into data architecture solutions, supports reporting and compliance initiatives, and shapes enterprise data practice in a regulated life sciences context.

Qualifications

• Bachelor's degree in Computer Science or related field.
• 5+ years in Data Architecture, Warehousing, BI, or Data Mining.
• Expertise with SQL Server tech: SSMS/SSIS/SSAS/SSRS.
• Experience with Power BI and ETL practices.
• Advanced SQL development and database design.
• Experience with enterprise-scale data warehouses and analytics.
• Preference for life sciences/regulatory environments.

Responsibilities

• Design, develop, and maintain scalable data models and a global data warehouse.
• Build and optimize ETL processes transforming data from multiple sources.
• Establish data governance standards and data quality controls.
• Lead data architecture for reporting, analytics, and BI needs.
• Collaborate with business and tech teams to capture requirements.
• Partner with infrastructure teams for platform upgrades and large data initiatives.
• Drive modern analytics practices and BI strategies.
• Profile data, improve quality, and strengthen reporting confidence.
• Develop SQL queries to support operations and audits.
• Create specs for new data solutions and enhancements.
• Support validation, compliance, and governance with QA.

Skills

Data Architecture

Data Warehousing

Business Intelligence

ETL Tooling

SQL Server

Power BI

SQL Development

Oracle OLTP/OLAP

Regulated Environment

Education

Bachelor's degree in Computer Science

Tools

SSMS

SSIS

SSAS

SSRS

ETL Tools

Job description

Kedrion Biopharma Inc. is seeking a Data Architect to design scalable data models and a global data warehouse. You will build ETL pipelines, enforce data governance, and drive analytics strategies across the organization.

The role collaborates with business and IT teams to translate requirements into data architecture solutions, supports reporting and compliance initiatives, and shapes enterprise data practice in a regulated life sciences context.