Apogee Enterprises Inc. is a leading provider of architectural products and services, and they are seeking a highly organized, detail-oriented Data Analyst to join their growing organization. The Data Analyst will be responsible for mining, analyzing, and interpreting data to identify trends and patterns, ultimately leading to data-driven insights and business decisions.
Gathering, cleaning, and organizing data from various sources across the Apogee business segments, free external sources/paid subscriptions (APIs) into consolidated dashboards.
Assist in the development and maintain databases by acquiring data from primary and secondary sources, and build scripts that will make our data evaluation process more flexible or scalable across datasets
Define and implement data acquisition and integration logic, selecting an appropriate combination of methods and tools within the defined technology stack to ensure optimal scalability and performance of the solution
Proactively analyze data to answer key questions for stakeholders with an eye on what drives business performance, and investigate and communicate which areas need improvement in efficiency and productivity
Analyze data business processes and operations to identify opportunities for improvement.
Translating data into actionable insights and presenting findings through reports and visualizations identifying trends, variances, and anomalies as well as conducting hypothesis testing and predictive modeling to support business objectives.
Provide decision support through ad-hoc analysis and scenario modeling
Contribute to the development and maintenance of data governance processes configuring, enabling and optimizing data workflows to ensure efficient data processing and analysis
Partner with stakeholders to define key performance indicators (KPIs) and metrics.
Create and maintain rich interactive visualizations through data interpretation and analysis, with reporting components from multiple data sources
Evaluate internal systems for efficiency, problems, and inaccuracies, and develop and maintain protocols for handling, processing, and cleaning data
Identify and address data quality issues and discrepancies. Ensuring data quality by handling missing values, correcting errors, and removing inconsistencies and enforcing data quality standards.
Work directly with stakeholders to gather requirements, provide status updates, and build relationships.
Work closely with stakeholders to understand and maintain focus on their analytics needs, including critical metrics and KPIs, and deliver actionable insights to relevant decision-makers.
Participate as a member of the Apogee Data Analytics Council, ensuring best practice sharing of skills to meet the organization's needs.
Qualification
Required
Bachelor's degree (B.A. or B.S.) in Supply Chain/Operations or Data Analytics with at least 2 years of experience (in a multi-plant environment preferred); or equivalent combination of education and experience.
Proven experience in data analysis, mining, evaluation, visualization and project management.
Proficiency in programming languages (e.g., Python, R), data analysis tools (e.g., SQL, Tableau, Power BI), and statistical software.
Proficient in MS Office suite, particularly Excel
Excellent written and verbal communication skills to effectively communicate technical findings to both technical and non-technical audiences.
Ability to identify, analyze, and solve complex data-related problems.
Attention to detail is crucial for ensuring data accuracy.
Proficiency in statistical software and techniques.
Strong ability to identify, analyze, and solve problems using data.
Good organizational skills and the ability to coordinate between disparate tasks.
Good problem-solving skills with knowledge of six-sigma or lean office tools.
Preferred
ERP systems use and functionality (SAP, Epicor, JDE, D365)
Engineering systems use and functionality (Jira, Creo, Windchill, Solumina)
Project Management Tools (Asana)
MES systems use and functionality
Benefits
Competitive Benefits Package for employees and their dependents (Medical, Dental, Vision, Life, Disability)
Incentive Plans
401(k) with employer contribution and match
Employee Stock Purchase Plan with employer match
Paid Time Off (Vacation and Sick Time)
Paid Holidays
Tuition Reimbursement Program
Employee Assistance Program (EAP)
Wellness Program
Training and Career Progression
By definition, Apogee means "highest point." It's no coincidence that it's also the name of our company.