Data & Payroll Analytics Specialist – GreatWater 360 Auto Care - Grand Rapids, MI
About The Position
Data & Payroll Analytics Specialist – GreatWater 360 Auto Care (Grand Rapids, MI) Location: Corporate Office – 161 Ottawa Ave NW Suite 401, Grand Rapids, MI 49503 About GreatWater 360 Auto Care GreatWater 360 Auto Care is a rapidly growing automotive service company with over 140 locations across the Upper Midwest & Texas. We’re committed to delivering exceptional customer service, safety, and operational excellence. Join our shop support team and help us build data-driven solutions that keep our business running smoothly. The Data & Payroll Analytics Specialist plays a critical role in ensuring payroll accuracy, data integrity, and operational efficiency. This position combines data analytics, payroll operations, and automation to streamline processes, improve reporting, and support payroll execution across new and existing locations.
Requirements
- Power BI (including DAX)
- SQL (Databricks SQL, MSSQL)
- Microsoft Excel (Power Query, advanced formulas)
- Microsoft Access
- Strong understanding of payroll data and HRIS systems
Nice To Haves
- Python (automation, ETL)
- Experience with Databricks/PySpark
- Paylocity HCM Platform
Responsibilities
- Design and maintain interactive Power BI dashboards for leadership and payroll teams.
- Develop DAX measures for accurate, flexible insights.
- Ensure data quality and consistency across reporting assets.
- Build and optimize data pipelines using Databricks SQL and PySpark.
- Ingest, clean, and transform data for the enterprise data warehouse.
- Support enhancements to data models and architecture.
- Partner with Payroll to automate:
- Attendance tracking
- Onboarding workflows for acquisitions
- Bonus plan calculations and HRIS integrations
- Assist with payroll processing, data validation, and timely execution.
- Manage exception reports to resolve discrepancies.
- Build payroll models for newly acquired shops.
- Compare legacy payroll systems vs. GreatWater’s platform for accuracy.
- Automate complex bonus plans in HRIS.
- Validate payouts and compliance with company standards.
- Maintain documentation and audit trails.
- Respond to data-related tickets and resolve reporting issues.
- Communicate clearly with technical and non-technical stakeholders.
- Ensure stability of reporting and payroll systems.
Benefits
- Competitive compensation and benefits
- Career growth opportunities
- Collaborative corporate culture
- Be part of a fast-growing automotive leader with strong community values
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
Education Level
No Education Listed
Number of Employees
51-100 employees
