[Hiring] Power BI & SQL Data Analyst @Ambius

Role Description

This role provides critical data entry and administrative support to ensure accurate billing, rebate processing, and service completion tracking. The ideal candidate will have high attention to detail and a strong proficiency in managing complex data sets across multiple platforms.

Duties & 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.

Qualifications

• 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 - no waiting period!
• Professional and Personal Growth: Multiple avenues to grow your career, training and development programs available, tuition reimbursement benefits (for FT colleagues).
• Health and Wellness: 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.
• Savings and Retirement: 401(k) retirement plan with company-matching contributions.
• Work-Life Balance: Vacation days & sick days, company-paid holidays & floating holidays, a company mindset that prioritizes health, safety, and flexibility.

Pay Range

Yearly: $41,800.00 - $74,800.00