Data Analyst
Role details
Job location
Tech stack
Job description
Herzog Technologies, Inc. is currently seeking a talented and detail-oriented Data Analyst in St. Joseph, MO to join our team. In this role, you will transform raw data into actionable insights using modern analytics and AI-assisted tools to drive strategic business decisions. You will work closely with cross-functional teams to understand their data needs, develop reports and dashboards, and communicate findings effectively to stakeholders at all levels., * Design, develop, and maintain PowerBI dashboards and reports that provide meaningful insights to business stakeholders.
- Write and optimize SQL queries to extract, transform, and analyze data from various sources
- Create and maintain Business Objects reports and universes.
- Collaborate with business teams to understand their reporting needs and translate requirements into technical solutions.
- Identify trends, patterns, and opportunities in data to support business growth and process improvement.
- Ensure data quality, consistency, and integrity across all reporting platforms.
- Document processes, data dictionaries, and report metadata for knowledge sharing.
- Stay current with emerging data tools and AI-driven analytics techniques, proactively identifying opportunities to apply them within Herzog.
- Regular and consistent engagement, participation and promotion of Herzog's Culture and its essential behaviors are a requirement for this position.
- Regular and predictable attendance and punctuality are a requirement for this position.
- Other duties as assigned., * Subject to pre-employment background check and motor vehicle report review.
- Subject to pre-employment physical, medical evaluation, and drug screen.
- Successfully complete and maintain any required safety certification and testing on an annual basis.
Physical Requirements: The physical demands described below must be met by an employee to successfully perform the essential job functions of this role. This is a non-exhaustive overview of the physical requirements of this job.
- Work primarily in an office environment.
- Frequently sits for extended periods of time.
- Frequently use a computer keyboard and office related equipment.
- Requires occasional standing, walking, lifting, stooping or bending.
- Must successfully pass color/vision examinations as required by the position.
- Must be able to hear and distinguish auditory signals as required by the position.
Safety:
- Herzog is nationally recognized for its excellent corporate safety record which results from all employees at all levels, in all positions adhering to established policies and procedures. Reporting any and all safety violations to your immediate supervisor is a prerequisite for continued employment. Safety diligence by all results in a safe work environment for all.
Requirements
- High school diploma or equivalent.
- Bachelor's degree in a quantitative field (Business Analytics, Statistics, Computer Science, Economics, or related field) preferred.
- 3+ years of experience in a data analysis role.
- Strong proficiency in PowerBI, including DAX and Power Query.
- Advanced SQL skills with experience querying large, complex databases.
- Experience with SAP BusinessObjects, including report design and universe development preferred.
- Excellent problem-solving skills and attention to detail.
- Strong communication skills with the ability to present complex data in a clear, compelling manner.
- Experience with data visualization best practices preferred.
- Familiarity with data warehousing concepts and ETL processes preferred.
- Experience using AI tools or platforms (e.g., Microsoft Copilot, Claude, or similar) to enhance data workflows and accelerate analysis preferred.
- Industry experience in Construction, Transit, or Railway Maintenance preferred.
Benefits & conditions
- Herzog offers a robust benefits package including medical and dental coverage. The plans are specific to projects and locations.