Supply Chain Analytics Engineer II
Business Analytics
Business Intelligence
Business Intelligence Tools
Cloud
Cloud Platform
Cloud Platforms
Data Analytics
Data Architecture
Data Engineer
Data Integration
Data Pipeline
Data Platform
Data Warehouse
Engineer
ETL
Operations Analytics
Power BI
Reporting and Analytics
SQL
Supply Chain Analytics
Job Description
The Analytics Engineer II role focuses on building trusted, governed data assets that connect Supply Chain operations to analytics and operational decision-making. You will partner across business and engineering teams to design scalable semantic models and curated datasets, and support AI-enabled analytical capabilities for reporting and emerging data use cases.
Key Responsibilities
- Collaborate with business stakeholders, Product, and Data Engineering teams to understand Supply Chain operations, business processes, system workflows, and data requirements.
- Translate business needs into scalable analytics solutions aligned with business objectives and operational decision-making.
- Design, build, maintain, and enhance curated datasets, semantic models, and reusable analytical products for trusted reporting, self-service analytics, and AI-enabled solutions.
- Use SQL, data transformation techniques, business logic, and data modeling practices to integrate, validate, and transform complex data into governed, business-ready information assets.
- Develop and maintain semantic layers, certified datasets, governed metrics, and business definitions to support consistent reporting, improve data accessibility, and reduce duplication.
- Prepare and optimize analytical data products, semantic models, governed business definitions, and data experiences for AI-enabled and conversational analytics and predictive insights.
- Contribute to AI-enabled analytics use cases through semantic preparation, prompt development, and output validation in partnership with relevant technical and governance teams.
- Apply established standards for data quality, performance, and governance across analytical data products.
- Execute test plans and validate source-to-target data flows to assess data quality and validate analytical solutions, using standardized testing methodologies.
- Document, communicate, and resolve identified issues based on agreed testing approaches.
- Maintain business and technical metadata, source-to-target mappings, data lineage, ownership information, technical specifications, and supporting documentation within approved data catalog and knowledge management tools.
- Apply enterprise requirements for data classification, privacy, security, access control, and retention to analytical datasets, semantic models, and self-service analytics solutions.
- Partner with security, privacy, and governance teams to support compliance with established standards.
- Monitor assigned data products in production by triaging data quality and reliability incidents, supporting recovery and escalation, communicating business impact, and implementing corrective actions to improve reliability.
- Assess upstream and downstream impacts of data, schema, metric, system, and process changes, coordinating testing and implementation activities.
- Work with Operations, Finance, Product, Data Engineering, Software Engineering, and Business Intelligence teams to support data asset design, delivery, and maintenance.
- Partner with internal and external teams to identify new data requirements, perform root-cause analysis, and support resolution of data-related issues.
- Support vendor, product, and operational data integrations (such as FTP, Kafka, and DataStage) to ensure reliable delivery, quality, and availability of analytical data products.
- Support development, testing, incident resolution, and monitoring for data integrations and processing workflows.
- Support the implementation of new data sources and data elements, including requirements gathering, solution design, testing, deployment, and change management.
- Provide technical guidance and knowledge transfer to downstream analytics teams on data models, semantic layers, governed metrics, data availability, and structural changes.
- Support planning, delivery, and continuous improvement activities, and maintain awareness of evolving analytics, AI-enabled analytics, business intelligence, and data management practices.
Required Qualifications
- Bachelor’s degree (BS) in Computer Science, Information Systems, Data Analytics, Engineering, Statistics, Supply Chain, or a related field.
- Experience in analytics engineering, business intelligence, data management, data engineering, or a related discipline.
- Proficiency that includes SQL, multi-source data transformation, dimensional or semantic modeling, data-quality testing, documentation, production support, and delivery of analytical data products.
- Ability to understand business processes and system workflows and connect them to how data is generated, transformed, and consumed.
- Experience working with cloud-based data and analytics platforms (Databricks, Snowflake, Azure, AWS, Google Cloud) to support data analysis and reporting.
- Experience supporting data ingestion, integration, and orchestration using technologies such as Kafka, FTP, and ETL/ELT frameworks or similar tools.
- Experience developing datasets and analytical solutions using business intelligence and self-service analytics platforms (Cognos, Power BI, Qlik).
- Familiarity with metadata management, data lineage, documentation, and data catalog practices that support data quality, discoverability, and governance.
- Experience using version control tools (for example, Git) and applying testing, deployment, change management, and work management practices (for example, Jira) within the analytics development lifecycle.
- Familiarity with AI-enabled analytics, conversational analytics, predictive analytics, and related technologies for data-driven decision-making.
Preferred Qualifications
- Supply-chain or Manhattan-system experience.
- Relevant training or certifications in SQL, analytics engineering, cloud data platforms, data governance, BI tooling, or AI-enabled analytics.
Technologies
- SQL
- Kafka
- FTP
- DataStage
- ETL/ELT
- Databricks
- Snowflake
- Azure
- AWS
- Google Cloud
- Cognos
- Power BI
- Qlik
- Git
- Jira
Location and Work Setup
Onsite in Coraopolis, PA.
Virtual Interview Requirements
- Candidates must not use AI tools (such as ChatGPT or others) during interviews or assessments.
- Cameras must be on during all virtual interviews.
- AI tools are not permitted to be used by the candidate during any part of the interview process.
Additional Conditions
- Offers are contingent upon a satisfactory background check, which may include ID verification.