[Remote] Power BI & SQL Data Analyst

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