Data Architect

About Phibro Animal Health CorporationPhibro Animal Health Corporation is a publicly traded, global organization with a rich 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, microbials for plants, home and industrial applications, and specialty chemicals for various industrial markets. In addition to, Phibro’s revenues are in excess of $1 billion and are supported by over 2,400 employees worldwide.At Phibro, people are our greatest asset. We strive to develop a diverse workforce that fosters an environment where people feel supported in openly sharing their creativity and skills that allows them to be the most successful that 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.The Data Architect is an integral part of our Digital Information Delivery team based out of our US - Teaneck, NJ - Remote site. Compensation range for this position is - Position SummaryThis 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 Responsibilities1. Modern Data Architecture LeadershipOwn 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.2. Fabric Migration & Platform ModernizationLead 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.3. Data Engineering & IntegrationDesign 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.4. Data Warehouse, MDM, & GovernanceArchitect 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.5. Business Partnership & DeliveryPartner 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.This role requires travel up to 25%.Required Skills and ExperienceBachelor's or Master's degree in Computer Science, Information Systems, Engineering, or related field.15+ years of experience in data architecture, data engineering, and enterprise data platform delivery.Deep expertise with:
Microsoft SQL Server, SSIS,Azure SQL Database, Azure SQL Managed Instance, Azure Data Factory (ADF)ETL/ELT frameworks and enterprise data integrationData warehousing and dimensional modelingData modeling and warehouse designChange Data Capture (CDC)Data governance and metadata managementProven experience modernizing legacy reporting and data platforms into cloud-based architectures.Experience supporting financial reporting, operational reporting, and month-end business processes.Strong understanding of enterprise integration patterns, cloud data architectures, and analytics platformsPreferred QualificationsExperience withMicrosoft Fabric, including Lakehouse, Warehouse, Data Factory, Pipelines, Spark, and OneLake.Microsoft Azure Data Engineering or Fabric certification.Experience with Qlik Replicate, Databricks, Synapse Analytics, or comparable modern data platforms.Familiarity with Master Data Management (MDM) frameworks and data governance tools such as Microsoft Purview.Experience with Power BI, IBM Cognos, or similar enterprise analytics platforms.Experience integrating ERP systems such as JD Edwards (JDE), Oracle EBS, or similar enterprise applications.Experience supporting global manufacturing, supply chain, or life sciences organizations.Key TechnologiesMicrosoft Fabric: Lakehouse, Warehouse, Pipelines, CDC, Mirroring, SparkAzure: Data Factory, SQL Database, Managed Instance, Data Lake StorageSQL Server / SSISData Modeling: SCDs, star schema, dimensional modelingVisualization: Power BI, CognosGovernance: PurviewETL/ELT: Qlik Replicate, ADF, T-SQL, SparkTo learn more about Phibro Animal Health's competitive benefits package, please click here: Phibro Benefits.Phibro is an Equal Opportunity EmployerAll 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:CorporateDepartment:Digital Information DeliveryLocation:US - Teaneck, NJ - RemoteWork Schedule:Monday - Friday (Standard Work hours)