Business Intelligence Coordinator

This is a fully remote position, open to applicants in Texas.

📋 Description

• Collaborate with the Director of Customer Success/Analytics to develop, maintain, and enhance reporting, dashboards, and data tools that support client merchandising initiatives.

• Oversee and manage essential data assets, including active field representative rosters, store master lists, and program location data, ensuring their accuracy, completeness, and consistent structure across systems.

• Create and update field coverage and proximity analyses to inform staffing plans, travel classifications, and the feasibility of client programs.

• Assist in capacity planning and labor estimation, including modeling representative hours for both new and existing retail programs.

• Supervise routine data refreshes and reporting schedules for active client programs, encompassing execution, auditing, and compliance reporting.

• Design and maintain Airtable bases, interfaces, and automations to support workflows in field operations and program management.

• Extract, clean, and transform data from Salesforce and other source systems to facilitate analysis and reporting.

• Work collaboratively across departments with program managers, account teams, Information Services (IS), and field leadership to identify data requirements and address data quality challenges.

• Define and monitor KPIs that benchmark program performance and evaluate the effects of operational decisions.

• Organize large datasets, create clear visual representations, and translate insights into actionable recommendations for internal stakeholders and clients.

• Document data processes, definitions, and methodologies to establish repeatable and scalable reporting practices.

⛳️ Requirements

• Bachelor’s degree in a relevant field such as business, analytics, economics, information systems, or a similar discipline.

• A minimum of 1-2 years of experience in gathering, structuring, and analyzing data.

• Advanced Excel skills, including proficiency in formulas, pivot tables, and structured data models.

• Experience with relational databases or low-code platforms like Airtable, or a proven ability to learn rapidly.

• Strong analytical mindset with excellent problem-solving abilities.

• Familiarity with data querying, cleaning, and transformation techniques.

• Capability to interpret, visualize, and communicate clear and concise findings to key stakeholders.

• High attention to detail, especially regarding location, personnel, and program data.

• Excellent written and verbal communication skills.

• Self-motivated individual committed to continuous learning and improvement.

• Ability to manage multiple concurrent programs and adapt to a client-driven work environment.

🏝️ Benefits

• Opportunity for remote work.

• Competitive annual salary with weekly payment options.

• On-demand pay options available through DailyPay.

• Comprehensive health, dental, and vision benefits.

• 401k program with company matching contributions.

• Paid time off along with holidays.

• Mobile phone reimbursement.

• Scholarship opportunities for employees and their families.

• Employee Assistance Program.

• Leadership Development Program.