Compass Group USA is looking to modernize legacy systems and drive technology-enabled efficiency across Accounting Services by transitioning outdated Microsoft Access-based tools into scalable, sustainable solutions using modern platforms.
Requirements
- Microsoft Access development experience.
- VBA coding experience.
- Python programming experience.
- Experience with Microsoft Power Platform (Power BI, Power Automate, Power Apps).
- 4+ years of Power BI development experience.
- Advanced skills in Power Query, Power BI, and Excel.
- Ability to create and interpret SQL code.
Responsibilities
- Assess and unwind legacy Microsoft Access-based tools, transitioning them into scalable, modern platforms while ensuring continuity and compliance with accounting controls.
- Develop and maintain automation solutions using VBA applications, Python scripts and the Microsoft Power Platform to support integration, reporting, and process optimization.
- Provide maintenance and support for existing legacy solutions, while leading modernization and continuous improvement efforts.
- Design and develop advanced Power BI dashboards and measures (DAX), including optimized data models and integrations which enable actionable insights and streamlined reporting.
- Act as solution owner for assigned BI and automation tools, ensuring sustainability, security, and user adoption.
- Lead change management efforts to drive adoption of new technologies and automation solutions across Accounting Services.
- Apply a strong understanding of Accounting/Payroll/Benefits environments to ensure solutions are aligned with business needs.
Other
- Collaborate with accounting stakeholders and business leaders to identify opportunities where BI, automation, and technology can deliver measurable value.
- Mentor, coach and provide guidance to junior developers and analysts, sharing expertise in BI, automation, and best practices.
- Present solutions and progress updates to the BIP team and broader audiences, fostering a culture of innovation and continuous learning.
- Lead end-to-end project planning and execution, including scope definition, goals and milestones, risks, and outcomes.
- Apply project management practices to deliver solutions on time and within scope.
