IT Data Analyst | SQL, Power BI & Business Intelligence

Hillyard Inc.; Saint Joseph (MO); On-site; USD 70,000 - 100,000; Full time

Benefits offered by this job

Competitive salary

Bonus program

Paid holidays

Paid time off

401(k) and profit-sharing

Medical, dental, vision benefits

Professional growth opportunities

Job summary

Hillyard, Inc. in St. Joseph, MO is seeking an IT Data Analyst to join our Information Technology team.

The role focuses on turning data into actionable insights through SQL, Power BI, data modeling, and analytics, collaborating with business and technical teams to deliver reporting solutions. You'll design reports and dashboards, ensure data quality, and support governance and BI initiatives while partnering with stakeholders across the organization to drive operational excellence and strategic

Qualifications

• Bachelor's degree in Information Technology, Computer Science, Data Analytics, Business Analytics, or a related field.
• 5+ years of experience in data analysis, business intelligence, reporting, or a related field.
• Strong analytical, problem-solving, and critical-thinking abilities.
• Excellent communication and stakeholder relationship-building skills.
• Experience translating business requirements into technical reporting and analytics solutions.
• Strong organizational skills with the ability to manage multiple priorities.

Responsibilities

• Design, develop, and maintain reports, dashboards, and data visualizations that support business decision-making.
• Partner with business and technical teams to gather requirements and translate data into actionable insights.
• Analyze data from multiple systems to identify trends, opportunities, and operational improvements.
• Develop and maintain reporting solutions, data models, and business intelligence tools.
• Ensure data accuracy, integrity, and consistency across reporting platforms.
• Evaluate changes to source systems and assess their impact on reporting and analytics.
• Create and optimize data flows, reporting processes, and ETL solutions.
• Present findings and recommendations to both technical and non-technical stakeholders.
• Support ongoing data governance, reporting enhancements, and business intelligence initiatives.

Skills

Data analysis

BI reporting

Reporting

Stakeholder communication

Problem solving

SQL queries

Education

Bachelor's degree in IT/CS/Data Analytics

Tools

SQL Server

SSMS

Power BI

DAX

ETL design

Job description

IT Data Analyst | SQL, Power BI & Business Intelligence

Hillyard, Inc. is currently seeking an IT Data Analyst to join our Information Technology team in St. Joseph, MO.

Are you passionate about turning data into actionable insights? Do you enjoy solving business challenges, building meaningful dashboards, and helping leaders make data-driven decisions?

As an IT Data Analyst, you will play a key role in supporting business intelligence, reporting, and analytics initiatives across the organization. You will work closely with business and technical teams to develop reporting solutions, identify trends, improve data quality, and deliver insights that support operational excellence and strategic growth.

This is an excellent opportunity for a data professional who enjoys working with SQL, Power BI, data modeling, and analytics while partnering with stakeholders throughout the organization.

Essential Functions and Responsibilities

• Design, develop, and maintain reports, dashboards, and data visualizations that support business decision-making.
• Partner with business and technical teams to gather requirements and translate data into actionable insights.
• Analyze data from multiple systems to identify trends, opportunities, and operational improvements.
• Develop and maintain reporting solutions, data models, and business intelligence tools.
• Ensure data accuracy, integrity, and consistency across reporting platforms.
• Evaluate changes to source systems and assess their impact on reporting and analytics.
• Create and optimize data flows, reporting processes, and ETL solutions.
• Present findings and recommendations to both technical and non-technical stakeholders.
• Support ongoing data governance, reporting enhancements, and business intelligence initiatives.

Qualifications Include

• Bachelor's degree in Information Technology, Computer Science, Data Analytics, Business Analytics, or a related field.
• 5+ years of experience in data analysis, business intelligence, reporting, or a related field.
• Strong analytical, problem-solving, and critical-thinking abilities.
• Excellent communication and stakeholder relationship-building skills.
• Experience translating business requirements into technical reporting and analytics solutions.
• Strong organizational skills with the ability to manage multiple priorities.

Required Technical Skills

Data & Database Technologies

• Microsoft SQL Server
• SQL Server Management Studio (SSMS)
• Queries, Stored Procedures and Views
• Optimization and Performance Tuning

Business Intelligence & Reporting

• Power BI Desktop
• Power BI Service (Online)
• DAX (Data Analysis Expressions)
• Dashboard and Report Development
• Data Visualization Best Practices

Data Architecture

• Data Modeling
• ETL Design and Architecture
• Data Flows
• Data Quality and Governance

Why Hillyard?

• Since 1907, Hillyard has been a family-owned company dedicated to helping customers create clean, safe, and healthy environments through innovative products, services, and solutions.
• As we continue to grow, we are investing in technology and data-driven decision-making to better serve our customers and support business growth.
• This role provides the opportunity to work on enterprise-wide reporting and analytics initiatives while making a meaningful impact across the organization.

What’s in It for You?

• Monday-Friday day shift schedule
• Competitive salary and bonus program
• Paid holidays
• Paid time off programs
• Industry-leading 401(k) and profit-sharing program
• Excellent medical, dental, and vision benefits
• Opportunity to work on enterprise-wide reporting and analytics initiatives
• Collaborative and innovative work environment
• Professional growth and development opportunities

At Hillyard, we treasure our Team Members as the cornerstone of our success, and our commitment to their growth is unwavering.

Hillyard is an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, or any other status protected under federal, state, or local law.