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?

• 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.

• 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.

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

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

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

• 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

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.