Data Architect jobs in United States
cer-icon
Apply on Employer Site
company-logo

Phibro Animal Health · 17 hours ago

Data Architect

Phibro Animal Health Corporation is a global organization focused on animal health and nutrition. The Data Architect will be responsible for the architecture, delivery, and governance of reporting and data delivery, playing a key role in modernizing and optimizing data processes within the company.

AgricultureFarmers MarketFood Processing
check
H1B Sponsor Likelynote

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

Qualification

Data ArchitectureMicrosoft FabricSQL ServerETL/SSISPerformance OptimizationData GovernanceData ModelingPower BICollaborationProblem Solving

Required

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

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

Company

Phibro Animal Health

twittertwittertwitter
company-logo
Phibro Animal Health Corporation is dedicated to helping meet the growing demand for animal protein.

H1B Sponsorship

Phibro Animal Health has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)

Funding

Current Stage
Public Company
Total Funding
$550M
2021-04-22Post Ipo Debt· $550M
2014-04-11IPO
2008-03-01Acquired

Leadership Team

leader-logo
Jack Bendheim
Chief Executive Officer
linkedin
leader-logo
Glenn David
CFO
linkedin
Company data provided by crunchbase