Senior Data Analyst

Allegis CorporationMinneapolis, MN, US

job_description.job_card.variable_days_ago

serp_jobs.job_preview.job_type

serp_jobs.job_card.full_time

job_description.job_card.job_description

Job Description

Company Overview

Allegis is a market-leading access hardware company headquartered in Minneapolis, MN, renowned for innovation and quality in security and entry solutions. They serve a diverse portfolio of commercial, institutional, and residential customers across North America. Backed by a culture of continuous improvement, this organization is committed to data-driven decision-making at every level.

Position Overview

The Senior Data Analyst will report directly to the CIO and play a pivotal role in shaping the company’s analytics strategy. You will translate complex data into actionable insights, drive AI adoption, and partner cross-functionally to optimize operations in finance, supply chain, and product development. This role demands both technical mastery and domain expertise to support strategic growth initiatives.

Key Responsibilities

Architect, develop, and maintain robust data pipelines and ETL workflows from ERP systems (SAP, Oracle NetSuite, MS Dynamics, Epicor Prophet 21).
Optimize relational databases (PostgreSQL, MySQL, SQL Server, Oracle) by writing advanced SQL and tuning performance.
Design interactive dashboards and reports in Power BI, Tableau, or Epicor Grow to monitor KPIs and operational metrics.
Lead demand forecasting, inventory optimization, and supply chain analytics projects using statistical modeling and machine learning.
Collaborate with accounting to resolve period-end variances, develop custom queries, reports and portals, and automate financial reporting.
Mentor junior analysts, conduct code reviews, and drive best practices in data governance and documentation.
Partner with IT and business stakeholders to define analytics requirements and enable AI-driven solutions for predictive maintenance, anomaly detection, and customer segmentation.

Required Technical Skills

SQL and Database Management

5+ years of advanced SQL experience with relational databases (PostgreSQL, MySQL, SQL Server, Oracle)

Query optimization, performance tuning, schema design, normalization

Data Visualization

Expert in Power BI, Tableau, or Epicor Grow for constructing interactive dashboards

Advanced Excel Skills (PivotTables, VBA, VLOOKUP) and database connectivity

Data Warehousing

Hands-on expertise with tools like Snowflake, Amazon Redshift, or Google BigQuery

Designing scalable, cloud-based data architectures

ETL Pipelines & Integration

Architecting and optimizing ETL processes from ERP and cloud data sources via APIs

Tool experience : Informatica, Talend, Matillion, Epicor Grow or custom Python solutions

ERP Systems

Working knowledge of SAP, Oracle NetSuite, MS Dynamics, or Epicor Prophet 21

Ability to configure modules and integrate third-party systems and solutions

Programming

Python or R for statistical analysis, forecasting (ARIMA, exponential smoothing), and machine learning

C# proficiency for ERP customizations and integrations (bonus skill)

Process Automation

Defining and automating business workflows within ERP or via Automation Studio (Workato)

Domain Knowledge

Accounting Principles

Fundamental understanding of GAAP, financial reporting, and period-end close processes

Partnering with accounting teams on variance analysis and custom reporting

Supply Chain Analytics

KPIs : fill rate, lead time, inventory turnover, stockout rates

Network optimization, cost-to-serve, sustainability metrics

Demand Forecasting

Building statistical and machine learning models for demand prediction

Scenario planning, CPFR collaboration, and predictive analytics

Inventory Management

Stock optimization using EOQ, safety stock, and multi-echelon techniques

Lean / Six Sigma methodologies to minimize waste

Logistics & Transportation

Freight analytics and carrier performance evaluation

AI & Advanced Analytics Skills

Familiarity with machine learning frameworks (scikit-learn, TensorFlow, PyTorch)

Experience deploying AI models for predictive maintenance, anomaly detection, and customer segmentation

Knowledge of generative AI, large language models, and prompt engineering for automated insights

Understanding of MLOps practices, model versioning, and monitoring in production

Ability to translate AI outputs into business recommendations and influence adoption

Soft Skills

Communication & Stakeholder Management

Translate data findings into executive-level presentations and dashboards

Storytelling with data to influence strategy across finance, supply chain, sales, and IT

Leadership & Mentorship

Guide junior analysts, lead code reviews, and champion data literacy programs

Drive change management when rolling out new analytics tools

Problem-Solving

Conduct root-cause analyses and apply critical thinking to complex business challenges

Utilize Agile methodologies to deliver incremental improvements

Documentation

Passionate about documenting solutions, workflows, and code for maintainability and knowledge sharing

Qualifications

Bachelor’s or Master’s degree in Data Science, Statistics, Computer Science, Business Analytics, or related field

7+ years of hands-on experience in data analytics or business intelligence roles

Demonstrated track record deploying data-driven solutions in a manufacturing or distribution environment

Located in or willing to relocate to Minneapolis, MN; some travel may be required

What We Offer

Competitive salary with performance-based bonuses.

Comprehensive health, dental, and vision benefits

401(k) plan with employer match

Professional development stipend and continuous learning opportunities

Collaborative, inclusive culture driven by innovation and growth

serp_jobs.job_alerts.create_a_job

Senior Data Analyst • Minneapolis, MN, US