Department: IT

Employment Type: Full Time

Location: Corporate Office

Reporting To: Adam Olson

Compensation: $30.00 - $33.00 / hour

Description

Position Summary

This role combines business intelligence development, database support, and Tier-1 IT assistance. The primary focus is building and maintaining Power BI dashboards, developing SQL-based data models, and ensuring clean, reliable data across enterprise systems. The position also supports system integrations, documentation, and basic IT troubleshooting for end users.

Key Responsibilities

Business Intelligence & Reporting (60%)

Build, maintain, and improve Power BI dashboards used by Finance, Sales, Operations, and Senior Leadership.
Develop data models and queries using SQL, Infor Syteline datasets, and other internal data sources.
Assist in the migration of reporting from legacy tools (e.g., Cyberquery) into Power BI.
Clean and transform datasets for accuracy, consistency, and performance.
Automate recurring reports and provide ad-hoc analysis when needed.

Database & Systems Support (20%)

Support integrations between Syteline, UKG, ShopTrak, and other enterprise systems.
Help maintain data integrity across platforms by diagnosing discrepancies and reconciling data
Contribute to documentation of system processes, data dictionaries, and reporting standards.

IT Support (20%)

Provide Tier-1 IT support: password resets, workstation setups, user access, basic troubleshooting.
Triage tickets and escalate more complex issues to IT Manager or outside providers.
Assist with hardware rollouts, software installations, and user onboarding.
Maintain ticketing system hygiene and help identify recurring issues.

Skills, Knowledge & Expertise

Bachelor’s degree in Management Information Systems, Business Analytics, Information Systems, Data Science, or similar.
Strong familiarity with Power BI, Excel, and basic SQL.
Comfort working with enterprise systems (ERP, HRIS, MES, CRM).
Solid analytical and problem-solving skills.
Strong communication skills—able to explain technical concepts to non-technical users.

Preferred Skills

Exposure to Infor Syteline, UKG, ShopTrak, or similar enterprise systems.
Experience with Python, DAX, or Power Query (M).
Understanding of data modeling concepts (Star schema, normalization, joins).
Experience with ticketing systems (Jira, FreshService, HelpDesk, etc.).

Job Benefits

Competitive PTO
401(k) Match
Health, Life, Dental, and Vision insurance
Flexible Spending Account
On-the-job training
Opportunities for advancement
Employee Assistance Program
Referral Program
Employee Discount Program
Financial Wellness Program

American Excelsior Company

New Jobs

Business Intelligence & IT Support Analyst