Note: The job is a remote job and is open to candidates in USA. Ambius is a member of the Rentokil family of companies, providing pest control and other services worldwide. The Power BI & SQL Data Analyst provides data entry and administrative support for billing, rebate processing, service completion tracking, and reporting while maintaining data accuracy across multiple platforms.
Responsibilities
- Billing Account Creation: Create new billing accounts within the system to ensure accurate customer records
- Billing Rebate Management: Compare property address data across multiple spreadsheets and system of record to identify and log matches for billing rebate purposes, and update reports on a monthly and quarterly basis
- Portal Management: Log in to National Account customer portals to monitor and track technician service activity
- Work Order Oversight: Identify service work orders that have not been completed by technicians and flag them for follow-up
- Reporting: Compile and distribute weekly spreadsheets for supervisors to ensure all work orders are completed and ready for billing
- Data Integrity: Maintain high standards of data accuracy across Microsoft Excel and Google Sheets
- Billing Execution: Responsible for processing daily and monthly billing tasks
Skills
- High School Diploma or equivalent required
- Associates degree or related field OR equivalent years of experience. Equivalent years of experience are defined as one year of related-professional experience for each year of college requested
- Proven experience in administrative support or a relevant data entry or reporting role
- Demonstrated experience managing and comparing large data sets
- Experience navigating customer portals or similar digital service platforms
- Experience managing corporate billing and invoicing
- Proficiency with Business Intelligence Tools such as Power BI, Tableau and/or QlikView
Benefits
- Benefits start day 1 for full-time colleagues with no waiting period.
- Multiple avenues to grow your career
- Training and development programs available
- Tuition Reimbursement benefits (for FT Colleagues)
- Full-time colleagues are eligible to begin enrollment immediately upon hire with benefits starting on day 1
- Health benefits including Medical, Dental, Vision, Disability, and Life Insurance plus much more
- 401(k) retirement plan with company-matching contributions
- Vacation days & sick days
- Company-paid holidays & floating holidays
- A company mindset that prioritizes health, safety, and flexibility
Company Overview