The Role
Build and maintain Power BI dashboards, develop SQL data models, clean and transform datasets, automate reports, support integrations between enterprise systems, document processes, and provide Tier-1 IT support including troubleshooting and ticket triage.
Summary Generated by Built In
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.
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.
• 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.).
• 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
• On-the-job training
• Opportunities for advancement
• Employee Assistance Program
• Referral Program
• Employee Discount Program
• Financial Wellness Program
• Financial Wellness Program
About
Since 1888, American Excelsior Company has manufactured and distributed products for packaging, cushioning, engineered foam specialties, erosion control, and a wide variety of engineered wood fibers. AEC’s nationwide manufacturing and distribution capabilities ensure efficient delivery from 7 manufacturing plants across the country.
Skills Required
- Bachelor's degree in Management Information Systems, Business Analytics, Information Systems, Data Science, or similar
- Strong familiarity with Power BI
- Strong familiarity with Excel
- Basic SQL skills
- 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
- Exposure to Infor Syteline, UKG, ShopTrak or similar enterprise systems
- Experience with Python
- Experience with DAX or Power Query (M)
- Understanding of data modeling concepts (star schema, normalization, joins)
- Experience with ticketing systems (Jira, FreshService, HelpDesk, etc.)
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
American Excelsior Company manufactures and distributes products for packaging, cushioning, engineered foam specialties, erosion control, and a wide variety of engineered wood fibers.
