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.

Key Responsibilities

Power BI & Reporting

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

Data Engineering & Pipelines

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

Payroll Support & Automation

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

Exception Tracking & Payroll Modeling

• Manage exception reports to resolve discrepancies.
• Build payroll models for newly acquired shops.
• Compare legacy payroll systems vs. GreatWater’s platform for accuracy.

Bonus Plan Automation & Compliance

• Automate complex bonus plans in HRIS.
• Validate payouts and compliance with company standards.
• Maintain documentation and audit trails.

Operational Analytics Support

• Respond to data-related tickets and resolve reporting issues.
• Communicate clearly with technical and non-technical stakeholders.
• Ensure stability of reporting and payroll systems.

Required Skills

• Power BI (including DAX)
• SQL (Databricks SQL, MSSQL)
• Microsoft Excel (Power Query, advanced formulas)
• Microsoft Access
• Strong understanding of payroll data and HRIS systems

Preferred Skills

• Python (automation, ETL)
• Experience with Databricks/PySpark
• Paylocity HCM Platform

Why Join GreatWater 360 Auto Care?

• Competitive compensation and benefits
• Career growth opportunities
• Collaborative corporate culture
• Be part of a fast-growing automotive leader with strong community values

Apply Today

Ready to make an impact? Apply now and help us drive data excellence and payroll accuracy across GreatWater 360 Auto Care.

Paylocity, Data analytics specialist, payroll analytics, Power BI jobs, SQL jobs, Databricks, PySpark, HRIS automation, payroll data accuracy, corporate analytics careers, Grand Rapids MI jobs.