Data Architect
Phibro Animal Health
June 28, 2026
Remote
United States
IT
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.
Key Responsibilities
- Own and enhance a modern 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 Spark vs. T-SQL warehouse design patterns.
- Oversee performance tuning to reduce compute consumption (CUs) across lakehouse notebooks, pipelines, and warehouse SQL objects.
- Lead migration of legacy SQL Server/SSIS processes to Fabric Lakehouse, Warehouse, and Data Factory.
- Re-engineer 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/refine Silver and Gold layer ingestion (schema evolution, SCD Type 2, materialized view refresh logic).
- Design/maintain ingestion pipelines for financials, sales, inventory, and master data domains.
- Optimize Spark notebooks, Fabric pipelines, and delta lake tables; ensure CDC handling and bronze-to-gold transformations with dependency orchestration.
- Establish operational runbooks and orchestration sequencing.
- Architect enterprise data models across Finance, Supply Chain, Sales, Animal Health operations, and Planning.
- Support MDM modernization (Customer Master redesign; Business Unit Master optimization).
- Promote data quality, auditability, lineage, and governance using Purview.
- Partner with business teams and support month-end close processes via reliable pipelines and validated warehouse layers.
- Guide leadership on capacity planning, cost optimization, and architecture selection; collaborate with vendors.
Required Skills/Experience
- Bachelor’s or Master’s degree in CS/IS/Engineering or related field.
- 10+ years in data architecture, including extensive SQL Server and ETL/SSIS.
- Hands-on Microsoft Fabric: 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 cloud-first modernization experience.
- Experience with financial systems, reporting, and month-end processes.
- Strong performance optimization (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.
- Data governance (Purview) and MDM framework familiarity.
- Power BI, Cognos, or similar analytics tools.
- Experience integrating with ERP systems such as JDE.
Key Technologies
- Microsoft Fabric; Azure Data Factory/SQL/MI/Data Lake; SQL Server/SSIS; SCDs & dimensional modeling; Power BI/Cognos; Purview; Qlik Replicate/ADF/T-SQL/Spark.
Application Instructions
If you are interested in working for Phibro and feel that you do not meet all qualifications, you are encouraged to apply.
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.
Key Responsibilities
- Own and enhance a modern 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 Spark vs. T-SQL warehouse design patterns.
- Oversee performance tuning to reduce compute consumption (CUs) across lakehouse notebooks, pipelines, and warehouse SQL objects.
- Lead migration of legacy SQL Server/SSIS processes to Fabric Lakehouse, Warehouse, and Data Factory.
- Re-engineer 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/refine Silver and Gold layer ingestion (schema evolution, SCD Type 2, materialized view refresh logic).
- Design/maintain ingestion pipelines for financials, sales, inventory, and master data domains.
- Optimize Spark notebooks, Fabric pipelines, and delta lake tables; ensure CDC handling and bronze-to-gold transformations with dependency orchestration.
- Establish operational runbooks and orchestration sequencing.
- Architect enterprise data models across Finance, Supply Chain, Sales, Animal Health operations, and Planning.
- Support MDM modernization (Customer Master redesign; Business Unit Master optimization).
- Promote data quality, auditability, lineage, and governance using Purview.
- Partner with business teams and support month-end close processes via reliable pipelines and validated warehouse layers.
- Guide leadership on capacity planning, cost optimization, and architecture selection; collaborate with vendors.
Required Skills/Experience
- Bachelor’s or Master’s degree in CS/IS/Engineering or related field.
- 10+ years in data architecture, including extensive SQL Server and ETL/SSIS.
- Hands-on Microsoft Fabric: 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 cloud-first modernization experience.
- Experience with financial systems, reporting, and month-end processes.
- Strong performance optimization (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.
- Data governance (Purview) and MDM framework familiarity.
- Power BI, Cognos, or similar analytics tools.
- Experience integrating with ERP systems such as JDE.
Key Technologies
- Microsoft Fabric; Azure Data Factory/SQL/MI/Data Lake; SQL Server/SSIS; SCDs & dimensional modeling; Power BI/Cognos; Purview; Qlik Replicate/ADF/T-SQL/Spark.
Application Instructions
If you are interested in working for Phibro and feel that you do not meet all qualifications, you are encouraged to apply.