Data Architect

KEDPLASMA LLC; Fort Lee (NJ); On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Health & Wellness

Financial Security

Work-Life Balance

Career Growth

Extra Perks

Job summary

Kedrion Biopharma Inc. is seeking a Data Architect to design scalable data models and global data warehouse solutions. You will build ETL pipelines, establish data governance, and collaborate with cross-functional teams to enable confident data-driven decisions.

In this role you will lead modern analytics initiatives, optimize reporting, and support enterprise BI needs in a regulated life sciences environment. A strong SQL and Power BI background is required.

Qualifications

• Bachelor's degree in Computer Science or a related field.
• Minimum 5 years of experience in Data Architecture, Data Warehousing, Business Intelligence, or Data Mining.
• Strong expertise with Microsoft SQL Server technologies (SSMS, SSIS, SSAS, SSRS).
• Experience with Power BI and ETL tools, methodologies, and best practices.
• Advanced SQL development and database design skills.
• Experience designing and supporting enterprise-scale data warehouses and analytics solutions.
• Experience with Oracle OLTP and OLAP environments is preferred; life sciences or regulated environments are a plus.

Responsibilities

• Design, develop, and maintain scalable data models and architecture for a growing global data warehouse environment.
• Build and optimize ETL processes that transform complex data from multiple sources into trusted, actionable information.
• Establish data governance standards, policies, and best practices to ensure data quality and integrity.
• Lead the design of data solutions that support reporting, analytics, BI, and enterprise decision-making.
• Collaborate with business and technical teams to translate requirements into data architecture solutions.
• Partner with infrastructure teams to support platform enhancements and large-scale data initiatives.
• Drive continuous improvement by introducing modern analytics methodologies and BI strategies.
• Analyze and profile data to identify anomalies and improve data quality and reporting.

Skills

SQL Server

SSIS/SSAS/SSRS

Power BI

ETL

Data modeling

Data warehousing

SQL

Oracle OLTP/OLAP

Education

Bachelor's degree in Computer Science

Tools

SSMS

SSIS

SSAS

SSRS

Job description

KEDPLASMA is a subsidiary of Kedrion Biopharma Inc. KEDPLASMA specializes in the collection and procurement of high-quality plasma that is processed into plasma-based therapies. Kedrion Biopharma Inc. is an international company specializing in the collection and fractionation of blood plasma to produce and distribute plasma-derived therapeutic products. Our therapies help treat and prevent serious diseases, including Hemophilia, Primary Immune System Deficiencies, and Rh-Sensitization.

Job Summary

Turn data into a competitive advantage. Join us as a Data Architect and play a key role in shaping the data foundation that drives smarter decisions, operational excellence, and business growth. In this high-impact role, you'll design scalable data solutions, build modern data warehouse capabilities, and influence how data is managed, governed, and leveraged across the organization. If you're passionate about data architecture, analytics, and creating solutions that deliver real business value, we'd love to hear from you.

What you'll do

• Design, develop, and maintain scalable data models and architecture for a growing global data warehouse environment.
• Build and optimize ETL processes that transform complex data from multiple sources into trusted, actionable business information.
• Establish data governance standards, policies, and best practices to ensure data quality, accuracy, and integrity.
• Lead the design of flexible data solutions that support reporting, analytics, business intelligence, and enterprise decision-making.
• Collaborate with business and technical teams to understand requirements and translate them into effective data architecture solutions.
• Partner with infrastructure teams to support platform enhancements, system upgrades, and large-scale data initiatives.
• Drive continuous improvement by introducing modern analytics methodologies and business intelligence strategies.
• Analyze and profile data to identify anomalies, improve quality, and strengthen confidence in reporting.
• Develop and optimize SQL queries to support business operations, reporting needs, and regulatory audit requirements.
• Create technical and functional specifications for new data solutions and enhancements.
• Work closely with QA and cross-functional stakeholders to support validation, compliance, and governance activities.
• Help define the future direction of enterprise data architecture while enabling teams across the organization to make better, faster, data-driven decisions.

Qualifications and need-to-know

• Bachelor's degree in Computer Science or a related field.
• Minimum 5 years of experience in Data Architecture, Data Warehousing, Business Intelligence, or Data Mining.
• Strong expertise with Microsoft SQL Server technologies, including SSMS, SSIS, SSAS, and SSRS.
• Experience with Power BI and ETL tools, methodologies, and best practices.
• Advanced SQL development and database design skills.
• Experience designing and supporting enterprise-scale data warehouses and analytics solutions.
• Experience with Oracle OLTP and OLAP environments preferred.Experience working in a life sciences or other regulated environment preferred.

Employment eligibility verification will be required at the time of hire. This position does not offer visa sponsorship now or in the future.

Kedrion Biopharma Inc. is committed to providing equal employment opportunities to all employees and applicants. We prohibit discrimination and harassment based on race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This policy applies to all employment terms, including recruitment, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

Salary ranges are determined based on relevant experience, education, and certifications.
If you require assistance with your employment application or need reasonable accommodations to perform job duties, please contact our Talent Acquisition team [e-mail].

Employee Benefits:At Kedrion Biopharma Inc., we believe in taking care of our people. Our benefits package is designed to support your health, happiness, and future, including:

• Health & Wellness- Full medical, dental, and vision coverage
• Financial Security- Life insurance, AD&D, and retirement savings plans
• Work-Life Balance- Paid time off, sick leave, and paid holidays
• Career Growth- Training programs and development opportunities
• Extra Perks- Employee discounts, wellness initiatives, and more!

For specific inquiries please reach out to us

Kedrion Biopharma Inc. participates in E-Verify and provides the federal government with Form I-9 information to confirm employment authorization. For more information, please contact the Department of Homeland Security.