Data Architect

Phibro Animal Health; Teaneck Township (NJ); Remote; USD 120,000 - 150,000; Full time

Benefits offered by this job

Competitive salary

Comprehensive benefits package

Flexible work schedule

Job summary

A leading animal health company seeks a Data Architect to lead the architecture and governance of reporting and data delivery. This role requires expertise in Microsoft Fabric, SQL Server, and data architecture. The ideal candidate will have over 10 years of experience and a background in data warehousing and ETL processes. Responsibilities include modernizing data architectures and managing robust data ingestion pipelines. Join a team that values innovation and collaboration while supporting diverse animal health solutions.

Qualifications

• 10+ years of experience in data architecture, SQL Server, and ETL/SSIS.
• Hands-on expertise with Microsoft Fabric components.
• Strong understanding of medallion architecture and big-data ingestion.

Responsibilities

• Lead data architecture based on Microsoft Fabric.
• Migrate legacy SQL Server/SSIS processes to Fabric.
• Design and maintain data ingestion pipelines for various domains.

Skills

Data architecture

SQL Server

ETL/SSIS

Microsoft Fabric

Performance optimization

Education

Bachelor’s or Master’s degree in Computer Science or related

Tools

Microsoft Power BI

Microsoft Azure

IBM Cognos

Job description

Overview

About Phibro Animal Health Corporation. Phibro is a publicly traded, global organization with a history in animal health and nutrition as a manufacturer and marketer of medicated feed additives, vaccines, nutritional specialty products, and mineral nutrition. We strive to be a trusted partner with livestock producers, farmers, veterinarians, and consumers who raise or care for farm and companion animals by providing solutions to help them maintain and enhance the health of their animals. Phibro is a diversified company in manufacturing and marketing products for ethanol performance, microbes for plants, home and industrial applications, and specialty chemicals for various industrial markets. Revenues exceed $1 billion supported by over 2,400 employees worldwide. At Phibro, people are our greatest asset, and we aim to foster a diverse workforce where people feel supported in openly sharing their creativity and skills to be as successful as they can be.

If you are interested in working for Phibro and feel that you do not meet all qualifications, we encourage you to apply as you might be the right candidate for this role or other positions.

Position

The Data Architect is an integral part of our Digital Information Delivery team based out of US - Teaneck, NJ - Remote site.

Position Summary

This role will play a key role in the architecture, delivery and governance of reporting and data delivery at Phibro. This hands-on technical role requires proven experience and knowledge of data warehousing and IBM Cognos business intelligence, with emphasis on data architecture, sourcing, reporting and analytics through project lifecycles. Specific responsibilities include but are not limited to:

Key Responsibilities

• Modern Data Architecture Leadership
• Own and enhance Phibro’s modernized data architecture built on Microsoft Fabric.
• Define technical standards for medallion architecture, CDC strategy, Fabric pipelines, optimization techniques, and Lakehouse/Warehouse usage.
• Evaluate and guide decisions on Spark vs. T-SQL warehouse design patterns.
• Oversee performance tuning to reduce compute consumption (CUs) across lakehouse notebooks, pipelines, and warehouse SQL objects.
• Fabric Migration & Platform Modernization
• Lead the migration of legacy SQL Server/SSIS processes to Fabric Lakehouse, Warehouse, and Data Factory.
• Re-engineer existing pipelines, stored procedures, and ETL frameworks into scalable Fabric-native solutions.
• Manage mirroring, CDC enablement, and ingestion performance for JDE and other enterprise systems.
• Validate and refine Silver and Gold layer ingestion, including schema evolution, SCD Type 2, and materialized view refresh logic.
• Data Engineering & Integration
• Design and maintain robust data ingestion pipelines for financials, sales, inventory, and master data domains.
• Partner with engineering teams to optimize Spark notebooks, Fabric pipelines, and delta lake tables.
• Ensure efficient CDC handling, bronze-to-gold transformations, and dependency orchestration.
• Establish operational runbooks and streamline orchestration sequencing.
• Data Warehouse, MDM, & Governance
• Architect scalable enterprise data models for Finance, Supply Chain, Sales, Animal Health operations, and Planning.
• Support MDM modernization initiatives such as Customer Master redesign and Business Unit Master optimization.
• Promote data quality, auditability, lineage, and governance using Purview.
• Establish standards for schema design, keys, constraints, and gold-layer performance.
• Business Partnership & Delivery
• Partner with Finance, Supply Chain, Commercial, and Production teams to understand reporting and analytics needs.
• Support month-end close processes through reliable data pipelines and validated warehouse layers.
• Provide guidance to leadership on capacity planning, cost optimization, and architecture selection.
• Collaborate with vendors (Microsoft, Virtusa, Qlik, etc.) on engineering, troubleshooting, and roadmap planning.

Required Skills and Experience

• Bachelor’s or Master’s degree in Computer Science, Information Systems, Engineering, or related field.
• 10+ years of experience in data architecture, including extensive SQL Server and ETL/SSIS experience.
• Hands-on expertise with Microsoft Fabric components:
• Lakehouse, Warehouse, Pipelines, Data Factory, Spark, Dataflows
• Delta Lake, Materialized Views, Mirroring, CDC frameworks
• Strong understanding of medallion architecture and big-data ingestion patterns.
• Proven experience modernizing legacy environments into cloud-first architectures.
• Experience with financial systems, reporting, and month-end processes.
• Strong performance optimization skills (Spark tuning, SQL optimization, CU cost control).

Preferred Qualifications

• Microsoft Azure Data Engineering or Fabric certification.
• Experience with Qlik Replicate, Azure SQL Managed Instance, Synapse, or Databricks.
• Familiarity with data governance tools (Purview) and MDM frameworks.
• Experience with Power BI, Cognos, or similar analytics tools.
• Prior exposure to integrating with ERP systems such as JDE.

Key Technologies

• Microsoft Fabric: Lakehouse, Warehouse, Pipelines, CDC, Mirroring, Spark
• Azure: Data Factory, SQL Database, Managed Instance, Data Lake Storage
• SQL Server / SSIS
• Data Modeling: SCDs, star schema, dimensional modeling
• Visualization: Power BI, Cognos
• Governance: Purview
• ETL/ELT: Qlik Replicate, ADF, T-SQL, Spark

To learn more about Phibro Animal Health's competitive benefits package, please click here: Phibro Benefits.

Equal Opportunity Employer

Phibro is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, national origin, gender, age, religion, disability, sexual orientation, gender identity, veteran status, marital status or any other characteristics protected by law.

Business Unit: Corporate

Division: Corporate

Department: Digital Information Delivery

Location: US - Teaneck, NJ - Remote

Work Schedule: Monday - Friday (Standard Work hours)