IT Data Analyst | SQL, Power BI & Business Intelligence
About The Position
Hillyard, Inc. is currently seeking an IT Data Analyst to join our Information Technology team in St. Joseph, MO. This role is crucial for supporting business intelligence, reporting, and analytics initiatives across the organization. The IT Data Analyst will collaborate with business and technical teams to develop reporting solutions, identify trends, improve data quality, and deliver insights that drive operational excellence and strategic growth. This is an ideal position for a data professional experienced with SQL, Power BI, data modeling, and analytics, who enjoys partnering with stakeholders throughout the company.
Requirements
- 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 Architecture
- Data Modeling
- ETL Design and Architecture
- Data Flows
- Data Quality and Governance
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.
Benefits
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
