GreatWater 360 Auto Care · 3 weeks ago
Data & Payroll Analytics Specialist – GreatWater 360 Auto Care - Grand Rapids, MI
Grand Rapids, MI
Full-time
Onsite
Mid LevelGreatWater 360 Auto Care is a rapidly growing automotive service company committed to delivering exceptional customer service and operational excellence. The Data & Payroll Analytics Specialist plays a critical role in ensuring payroll accuracy, data integrity, and operational efficiency by combining data analytics, payroll operations, and automation to streamline processes and improve reporting.
Automotive
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
Qualification
Required
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
Python (automation, ETL)
Experience with Databricks/PySpark
Paylocity HCM Platform
Benefits
Competitive compensation and benefits
Career growth opportunities
Collaborative corporate culture
Company
GreatWater 360 Auto Care
GreatWater 360 Auto Care is a network of local auto repair shops that share similar values and ways of doing business.
Founded in 2021
501-1000 employees
Funding
Current Stage
Late StageLeadership Team
Jim Dykstra
CEO at GreatWater Garages
Taylor Mitchell
Chief Technology Officer
Company data provided by crunchbase