Sr Advanced Data Analyst
Job Description
Solstice Advanced Materials is hiring a hands-on Senior Manufacturing Data Analyst to build and scale enterprise manufacturing analytics starting with the Copperfield expansion in Spokane, Washington.
Responsibilities
- Establish an initial analytics foundation at Copperfield, then adapt and scale solutions across Solstice sites with different processes, automation maturity, and technology landscapes
- Partner with production, engineering, quality, maintenance, EHS, supply chain, and IT/OT teams
- Support unit-level production, assembly, inspection, and process-oriented operations using recipes, batches, campaigns, process phases, and continuous operating conditions
- Define process-appropriate KPIs for each workflow rather than enforcing a single measurement approach
- Build, optimize, monitor, and document reliable pipelines from ERP, MES, historians, SCADA/PLC, LIMS, maintenance, and other operational sources
- Implement data validation, reconciliation, lineage, access controls, and exception handling
- Work with deployed platforms including SAP, TrakSYS MES, Ignition, AVEVA PI, LIMS; harmonize equipment, material, product, order, batch/lot, time, and site identifiers
- Collaborate with architects on reusable Snowflake/Databricks (or equivalent) warehouse/lakehouse data models
- Write performant SQL and create reusable semantic models, DAX measures, dashboards, and scorecards for operators, engineers, plant leadership, and enterprise stakeholders
- Deliver governed KPI drilldowns and monitor data refresh and accuracy
- Analyze OEE and asset utilization, downtime, cycle time, throughput, WIP, bottlenecks, changeovers, yield, scrap, rework, schedule attainment, material consumption, and (where applicable) genealogy/traceability
- Evaluate time-series trends, process variability, statistical process control, batch-to-batch consistency, equipment alarms, maintenance events, and recurring losses
- Support root-cause investigations and continuous improvement initiatives
- Apply basic Python and statistics for forecasting, anomaly detection, process deviation alerts, predictive maintenance, and quality-risk screening where useful
- Build small proof-of-concepts with clear baselines and measurable outcomes; collaborate with specialized data science teams for advanced models
- Use approved enterprise AI assistants for exploratory analysis, SQL/Python productivity, documentation, and insight generation; independently validate outputs and follow cybersecurity, privacy, governance, and model-approval requirements
- Develop enterprise KPI dictionaries, dashboard templates, reusable analytical assets, and site onboarding documentation
- Train site users, communicate findings clearly, and track operational value and adoption across the network
- Analyze and interpret complex data sets to provide actionable insights
- Collaborate with cross-functional teams to address business challenges and develop analytical solutions
- Develop and implement data analytics strategies to drive continuous improvement
- Ensure data integrity and accuracy through thorough analysis and validation
Requirements
- Bachelor’s degree in engineering, computer science, statistics, mathematics, information systems, or related quantitative discipline, or equivalent practical experience
- Typically 5+ years in data analytics, BI, or data engineering
- Advanced SQL skills, including complex transformations, joins, performance tuning, and data validation
- Power BI capabilities, including data modeling, DAX, dashboard design, and stakeholder reporting (comparable enterprise BI experience may be considered)
- Manufacturing data context and architecture experience working with SAP, TrakSYS MES, Ignition, AVEVA PI, LIMS, including time-series analysis, variability, trends, anomalies, and root-cause investigations
- Working knowledge of data warehouses/lakehouses, relational and dimensional modeling, data quality, documentation, and controlled data access
- Ability to work independently across sites and functions, translate business problems into measurable analytical requirements, and present actionable findings to technical and nontechnical audiences
- Support rollout at Spokane and other sites to site team members for MES and LIMS tools developed by System Integrators
Technologies
- SQL, Power BI, DAX, Python
- SAP, TrakSYS MES, Ignition, AVEVA PI, LIMS, SCADA/PLC
- Snowflake, Databricks, ERP, MES, historians, Time-series analysis, Statistical process control, OEE, SPC, Lean/Six Sigma
- EHS, PI Vision, Seeq, CMMS
- Azure, AWS, GCP, dbt, Airflow, Informatica, Talend, pandas, NumPy, scikit-learn
- SQL/Python
Benefits
- Employer-subsidized Medical
- Employer-subsidized Dental
- Employer-subsidized Vision
- Employer-subsidized Life Insurance
- Short-Term and Long-Term Disability
- 401(k) match
- Flexible Spending Accounts
- Health Savings Accounts
- EAP
- Educational Assistance
- Parental Leave
- Paid Time Off (vacation, personal business, sick time, and parental leave)
- 12 Paid Holidays
Compensation
- Annual base salary range: $113,491 - $142,119