Role Description AdvanSix is seeking a Big Data Engineer to build and operate our enterprise Unified Data Layer (UDL) - spanning IT and OT - to deliver trustworthy, performant data products that power Finance, Operations, Supply Chain & Logistics, HSE, Commercial, and corporate analytics. You’ll engineer batch/CDC/streaming pipelines, model curated/semantic layers, and harden run-state with testing, CI/CD, security, and observability. You’ll partner closely with the data team and larger IT organization. Mission - Design and deliver scalable, secure data pipelines and data models that safely connect operational systems to analytics. - Ensure trusted and well‑governed data. - Enable repeatable delivery of BI, ML, AI, and automation solutions. Data Engineering & Modeling - Build ingestion pipelines (batch, CDC, streaming) from S/4HANA/DataSphere, PHD/historian, LIMS, TMS, HSE, and other sources into landing → curated → semantic layers. - Implement data contracts, schema/versioning, SCD handling, partitioning, and performance tuning (file formats, clustering, caching). - Develop dimensional/semantic models that back certified Power BI datasets and APIs for apps/agents. OT/IT Integration & Safety - Integrate OT data via OPC UA/MQTT, broker/DMZ patterns, read-only historian feeds, and event/batch frames—no control-net reads. - Collaborate with plant controls on change control, signal quality, and downtime windows. Quality, Security & Observability - Embed data quality rules, unit/integration tests, and validation checks (freshness, completeness, drift/PSI). - Instrument lineage and end-to-end monitoring; build alerting and on-call runbooks to minimize MTTR. - Enforce RBAC, secrets management, PII/HSE classifications, and retention aligned to Governance/MDM policies. CI/CD, Cost & Reliability - Automate build/test/deploy with Git-based CI/CD (environments, approvals, blue/green). - Track and optimize cost/performance (cluster sizing, autoscaling, cache strategy); contribute to FinOps reviews. Collaboration & Documentation - Partner with Reporting & BI on semantic model contracts, RLS, and performance SLAs; avoid direct system scraping. - Produce “readme” docs, data dictionaries, runbooks, and post-incident reviews; support knowledge transfer with vendors. Qualifications - Minimum 5 years' in data engineering building production pipelines at scale (batch/CDC/streaming). - Hands-on with Azure data stack: Databricks or Fabric/Synapse, ADF/Pipelines, ADLS/OneLake, Azure SQL/SQL MI, Key Vault. - Strong SQL and Python/PySpark; comfort with Spark Structured Streaming and performance tuning. - Experience implementing tests/observability (freshness, schema, expectations), and Git-based CI/CD. - Familiarity with SAP S/4HANA structures and SAP DataSphere semantic modeling. - OT concepts: historians (PHD/PI), OPC UA/MQTT, event/batch frames, ISA-95/99 basics. - Understanding of Power BI consumption (semantic models, RLS) and APIs for downstream AI/ML apps/agents. Preferred Qualifications - Time-series/data-quality tooling (e.g., Great Expectations or equivalent patterns), feature/metric stores. - MDM concepts (keys, survivorship), lineage/catalog tooling. - TMS/WMS, LIMS, Historian, HSE domain exposure; Lean/Six Sigma mindset; FinOps awareness. Benefits - We provide benefits that are industry competitive and focused on employee well-being. - Total Rewards program includes a competitive compensation, health, dental, vision & wellness programs, paid vacation, 401K with company matching, health savings programs, disability & life insurance, employee assistance program. - Tuition reimbursement for continued education, certifications, training, and development. - Work within a fast paced and innovative company, meeting passionate colleagues and partners with diverse backgrounds and experiences.

Role Description The Data Architect defines and governs the target-state architecture for AdvanSix’s Unified Data Layer, ensuring that data across SAP, OT, lab, logistics, HSE, finance, and commercial domains is structured, integrated, and modeled for scale, trust, and reuse. This role owns the architectural blueprints, canonical data models, semantic design standards, integration patterns, and data product design principles that guide engineering delivery across the enterprise. The Data Architect partners closely with the AI, Automation, and Data team to ensure that what gets built is coherent, secure, and business-ready. Core Responsibilities: - Enterprise Data Architecture: - Define and maintain the target-state architecture for the Unified Data Layer, including landing, curated, and semantic layers, domain boundaries, and consumption patterns for BI, APIs, AI, and automation. - Develop architecture principles for modularity, interoperability, reusability, and governance across business and operational data domains. - Serve as the design authority for major data platform and integration decisions. - Canonical Data Modeling: - Design enterprise and domain-level canonical models for key entities such as material, product, asset, equipment, work order, batch, vendor, customer, cost center, logistics shipment, quality event, and energy usage. - Define standards for dimensional modeling, semantic modeling, event models, and reference data structures that support Power BI, AI, and operational decision-making. - Ensure alignment of curated and semantic data products with master data strategy and KPI canon. - Integration and Data Product Design: - Define architectural patterns for ingesting and harmonizing data from SAP S4 HANA, SAP DataSphere, historians, LIMS, TMS, HSE systems, and other enterprise platforms into the Unified Data Layer. - Establish standards for data contracts, schema evolution, surrogate keys, versioning, partitioning, and semantic publication. - Ensure that certified datasets and APIs are designed for downstream use by Reporting and BI, machine learning, Power Platform, and Copilot agents. - Architecture Governance and Design Review: - Lead design reviews for new data products, major source integrations, and semantic layer changes. - Approve architectural patterns and ensure alignment with security, lineage, quality, retention, and access standards. - Partner with Data Strategy and AI Governance to operationalize architecture guardrails into delivery standards. - Collaboration with Engineering and OT: - Work with the OT Data Integration Lead to ensure plant data models, asset hierarchies, event frames, and OT schemas fit the enterprise architecture without taking over OT connectivity operations. - Work with Big Data Engineers to translate architecture standards into implementable pipeline, storage, and semantic design patterns. - Partner with the Manager, Unified Data Platform and AI Engineering on platform roadmap, architecture decisions, and technical debt prioritization. - Documentation and Enablement: - Produce architecture diagrams, conceptual and logical data models, reference patterns, and design standards. - Create reusable templates and guidance for engineers, analysts, and vendors. - Help stakeholders understand how data should be structured and consumed across the enterprise. Qualifications - Minimum 8 years' of experience in enterprise data architecture, data modeling, and large-scale data platform design. - Proven experience designing lakehouse or enterprise data platform architectures across multiple domains. - Strong expertise in conceptual, logical, and physical data modeling, dimensional modeling, semantic layer design, and canonical data structures. - Strong understanding of Azure-based data architectures, including Databricks or Fabric and Synapse, ADLS or OneLake, Data Factory or pipelines, and integration with Power BI. - Working knowledge of SAP S4 HANA data structures and SAP DataSphere semantic concepts. - Familiarity with OT and industrial data patterns, including historians, event frames, asset hierarchies, time-series data, and ISA-based structures. - Strong knowledge of data contracts, schema versioning, lineage, master data alignment, and architecture governance. - Excellent communication skills with the ability to translate architecture into clear implementation guidance. Preferred Qualifications - Experience in manufacturing, chemicals, process industries, or industrial operations. - Familiarity with TMS, LIMS, HSE, maintenance, and finance data domains. - Experience with lineage and catalog tooling, master data design, and KPI canon alignment. - Exposure to API-enabled data product design for AI agents and automation. - Lean or Six Sigma mindset and comfort working in cross-functional transformation programs. Benefits - We provide benefits that are industry competitive and focused on employee well-being. - Total Rewards program includes a competitive compensation, health, dental, vision & wellness programs, paid vacation, 401K with company matching, health savings programs, disability & life insurance, employee assistance program. - Tuition reimbursement for continued education, certifications, training, and development. - Work within a fast paced and innovative company, meeting passionate colleagues and partners with diverse backgrounds and experiences.

• Partner with Technical Product Managers to understand product vision, roadmap priorities, and business objectives • Analyze and refine incoming development requests to clarify problem statements, scope, and success criteria • Analyze system interactions, integrations, APIs, and data flows to define expected behavior and outcomes • Create and maintain documentation such as process flows, data mappings, interface behavior descriptions, and business rules • Support backlog refinement by ensuring work items are well-defined, prioritized appropriately, and ready for delivery • Define acceptance criteria, test scenarios, and expected outcomes for validation activities • Support the TPM in stakeholder discussions by providing detailed analysis, examples, and clarifications, along with note taking and action item tracking

• Design and build scalable, secure, and cost-effective data solutions in Snowflake • Develop and optimize data pipelines using tools such as dbt, Python, CloverDX, and cloud-native services • Participate in discovery sessions with clients to gather requirements and translate them into solution designs and project plans • Collaborate with engagement managers and account teams to help scope work and provide technical input for Statements of Work (SOWs) • Serve as a Snowflake subject matter expert, guiding best practices in performance tuning, cost optimization, access control, and workload management • Lead modernization and migration initiatives to move clients from legacy systems into Snowflake • Integrate Snowflake with BI tools, governance platforms, and AI/ML frameworks • Contribute to internal accelerators, frameworks, and proofs of concept • Mentor junior engineers and support knowledge sharing across the team