IT Data Analyst | SQL, Power BI & Business Intelligence

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

Benefits offered by this job

Competitive salary and bonus program

Paid holidays

Excellent medical, dental, and vision benefits

Job summary

Hillyard, Inc. is looking for an IT Data Analyst to join our Information Technology team in St. Joseph, MO. The candidate will design and maintain reporting solutions that support business decision-making and translate data into actionable insights.

Essential qualifications include a Bachelor's degree in a related field and over 5 years of experience in data analysis and reporting. Benefits include a competitive salary, paid time off, and excellent medical benefits.

Qualifications

• 5+ years of experience in data analysis and reporting.
• Strong analytical and problem-solving abilities.
• Experience translating business requirements into technical solutions.

Responsibilities

• Design and maintain reports and dashboards.
• Gather requirements and translate data insights.
• Analyze data to identify trends and improvements.

Skills

Data analysis

Problem-solving

Reporting

Data Visualization

Communication

Education

Bachelor's degree in Information Technology or related field

Tools

Microsoft SQL Server

Power BI Desktop

SQL Server Management Studio (SSMS)

Job description

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?

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

• 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

Benefits

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