SR. Data Engineeer

Associated Materials is seeking a Senior Data Engineer to design, build, and maintain data pipelines, integrations, and platform infrastructure for its analytics and reporting ecosystem. The role leads end-to-end platform delivery, supports legacy system modernization, and advances data governance, quality, and cost-conscious platform operations.

Responsibilities:

• Design, build, and maintain data pipelines in Palantir Foundry
• Own end-to-end pipeline delivery — from source system extraction through transformation, loading, and consumption layer publication
• Architect integrations between AM’s source systems (Mainframe, AS400, Oracle, Salesforce etc), legacy BI platforms (Informatica, SQL Server), and Foundry
• Lead technical delivery on data platform projects from scoping through production deployment, including documentation and handoff
• Manage ETL pipelines & data load failures – Alerts/Notifications
• Manage support tickets – Root cause analysis, Code changes, ETL changes etc
• Manage stakeholder communications on support issues
• Documentations- RCA, SOPs, Weekly report etc
• Implement and enforce data quality controls, lineage tracking, and metadata standards across the data platform
• Support the development and operationalization of AMI's data and governance framework
• Participate in master data management (MDM) initiatives, with accountability for data accuracy and consistency across source systems
• Build and maintain row-level security (RLS) frameworks and access control models within Foundry and other platforms
• Monitor and optimize compute and storage consumption across cloud data platforms — identifying inefficiencies, right-sizing workloads, and proactively managing costs
• Develop and enforce platform usage standards that balance performance with cost discipline
• Partner with the Sr. Manager, Data Platforms to provide regular visibility into platform spend and capacity trends
• Provide hands-on support and maintenance for legacy data platforms including Informatica and SQL Server based legacy BI Systems as part of an active modernization roadmap
• Contribute to the assessment and migration of legacy workloads to modern platforms, maintaining continuity during transitions
• Document legacy system logic, data flows, and transformation rules to support future-state architecture decisions
• Work effectively alongside external System Integrator (SI) partners
• Maintain AMI's ability to govern and own deliverables produced by SI partners — ensuring quality, adherence to standards, and knowledge transfer back to the internal team
• Serve as a technical counterpart during vendor engagements, platform implementations, and third-party data integrations

Requirements:

• you must be a US Citizen or valid Green Card Holder to apply
• 5-6 years of professional experience as a Sr. Data Engineer or in a similar role
• Strong SQL and at least one scripting or programming language (Java, Python, Spark, PySpark, or equivalent)
• Experience with ETL/ELT pipeline design, orchestration tools, and modern data stack components
• Data platform experience such as Palantir Foundry, Snowflake, DataBricks, Azure Data factory, Informatica Cloud Services
• Solid understanding of data warehousing concepts
• Working knowledge of data governance concepts: classification, lineage, MDM, data quality frameworks, and access control
• Excellent problem-solving skills and ability to work in fast-paced environments
• Demonstrated experience working closely with business stakeholders to understand requirements, resolve production issues, and communicate project progress and support activities effectively
• Ability to translate complex technical concepts for non-technical stakeholders including plant operations, finance, and supply chain leadership
• Strong ownership mindset — comfortable holding end-to-end accountability for platform health, not just assigned sprint tasks
• Experience working alongside consultants with the ability to direct, review, and govern externally produced work
• Comfortable operating in environments with both legacy complexity and modern platform ambition — patient with technical debt while actively driving toward better
• Familiarity with cloud infrastructure (AWS or Azure preferred) and how compute and storage cost models work in practice
• Experience in manufacturing, supply chain, or industrial operations
• familiarity with ERP-centric data environments (Oracle EBS, SAP, or similar)
• Hands-on development experience with Palantir Foundry (Ontology, Code Repo, Pipeline Builder, Contour, Quiver, Object Storage, Workshop, AIP etc.)
• Exposure to divestiture, carveout, or M&A environments where data separation or platform replication was required
• FinOps awareness — track record of actively managing and reducing cloud data platform spend
• Palantir certifications or completed Palantir training bootcamps