Data Architect
Phibro Animal Health
2 months ago
Remote
United States
IT
Position Summary
This role plays a key role in the architecture, delivery, and governance of reporting and data delivery. Hands-on technical expertise in data warehousing and IBM Cognos BI is required.
Key Responsibilities
- Own and enhance modern data architecture built on Microsoft Fabric.
- Define technical standards for medallion architecture, CDC strategy, Fabric pipelines, optimization techniques, and Lakehouse/Warehouse usage.
- Evaluate 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 and maintain ingestion pipelines for financials, sales, inventory, and master data.
- Optimize Spark notebooks, Fabric pipelines, and delta lake tables; ensure CDC handling and bronze-to-gold transformations with dependency orchestration.
- Establish operational runbooks and streamline orchestration sequencing.
- Architect scalable enterprise data models for 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; establish schema/keys/constraints and gold-layer performance standards.
- Partner with Finance, Supply Chain, Commercial, and Production teams; support month-end close processes.
- Advise leadership on capacity planning, cost optimization, and architecture selection; collaborate with vendors (Microsoft, Virtusa, Qlik, etc.).
Required Skills and Experience
- Bachelor’s or Master’s in Computer Science, Information Systems, Engineering, or related field.
- 10+ years in data architecture, including extensive SQL Server and ETL/SSIS experience.
- 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 experience modernizing legacy environments to 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 Purview and MDM frameworks.
- Experience with Power BI, Cognos, or similar analytics tools.
- Prior exposure to integrating with ERP systems such as JDE.
Benefits
- To learn more about Phibro’s competitive benefits package, click here: Phibro Benefits.
Application Instructions
- If you are interested in working for Phibro and feel you do not meet all qualifications, you are encouraged to apply.
This role plays a key role in the architecture, delivery, and governance of reporting and data delivery. Hands-on technical expertise in data warehousing and IBM Cognos BI is required.
Key Responsibilities
- Own and enhance modern data architecture built on Microsoft Fabric.
- Define technical standards for medallion architecture, CDC strategy, Fabric pipelines, optimization techniques, and Lakehouse/Warehouse usage.
- Evaluate 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 and maintain ingestion pipelines for financials, sales, inventory, and master data.
- Optimize Spark notebooks, Fabric pipelines, and delta lake tables; ensure CDC handling and bronze-to-gold transformations with dependency orchestration.
- Establish operational runbooks and streamline orchestration sequencing.
- Architect scalable enterprise data models for 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; establish schema/keys/constraints and gold-layer performance standards.
- Partner with Finance, Supply Chain, Commercial, and Production teams; support month-end close processes.
- Advise leadership on capacity planning, cost optimization, and architecture selection; collaborate with vendors (Microsoft, Virtusa, Qlik, etc.).
Required Skills and Experience
- Bachelor’s or Master’s in Computer Science, Information Systems, Engineering, or related field.
- 10+ years in data architecture, including extensive SQL Server and ETL/SSIS experience.
- 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 experience modernizing legacy environments to 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 Purview and MDM frameworks.
- Experience with Power BI, Cognos, or similar analytics tools.
- Prior exposure to integrating with ERP systems such as JDE.
Benefits
- To learn more about Phibro’s competitive benefits package, click here: Phibro Benefits.
Application Instructions
- If you are interested in working for Phibro and feel you do not meet all qualifications, you are encouraged to apply.