Job Type:
RegularWork Location:
Atlanta, GA 30320Overview:
2020 Companies is now hiring a full-time remote Business Intelligence Coordinator
The Business Intelligence Coordinator helps transform field, store, and workforce data into meaningful insights that improve program performance and support business growth. As part of the Client Merchandising Success team, you'll build and maintain reports, dashboards, and data tools that support merchandising programs from initial planning through ongoing execution and performance reporting. Working with Airtable, Salesforce, Excel, and other business systems, you'll analyze store and field data, monitor program coverage and capacity, and deliver accurate, timely insights that help internal teams and clients make informed business decisions.
Pay: $50,000 annually + quarterly incentives
Location: Remote
What's in it for you?
- Remote work opportunity
- Competitive annual salary with weekly pay
- On-demand pay options through DailyPay
- Comprehensive health, dental, and vision benefits
- 401k program with company matching
- Paid time off and holidays
- Mobile phone reimbursement
- Scholarship opportunities for employees and families
- Employee Assistance Program
- Leadership Development Program
Job Description:
- Work in partnership with the Director of Customer Success/Analytics to build, maintain, and improve reporting, dashboards, and data tools supporting client merchandising programs
- Manage and maintain core data assets, including active field rep rosters, store master lists, and program location data, ensuring accuracy, completeness, and consistent structure across systems
- Build and refresh field coverage and proximity analyses that inform staffing plans, travel classifications, and client program feasibility
- Support capacity planning and labor estimating, including rep-hours modeling for new and existing retail programs
- Manage recurring data refreshes and reporting cadences for active client programs, including execution, audit, and compliance reporting
- Develop and maintain Airtable bases, interfaces, and automations that support field operations and program management workflows
- Extract, clean, and transform data from Salesforce and other source systems to support analysis and reporting
- Collaborate cross-functionally with program managers, account teams, Information Services (IS), and field leadership to identify data needs and resolve data quality issues
- Establish and track KPIs that benchmark program performance and measure the impact of operational decisions
- Structure large data sets, create clear visualizations, and translate findings into actionable recommendations for internal stakeholders and clients
- Document data processes, definitions, and methodologies to build repeatable, scalable reporting practices
Performance Measurements
- Completion of projects and recurring deliverables within set timeline expectations
- Accuracy and consistency of data assets, analyses, and reporting
- Reliability of recurring reporting cadences for active client programs
- Responsiveness to internal and client data requests
Qualifications
Required:
- Bachelor's degree in a relevant program: business, analytics, economics, information systems, or similar
- Minimum of 1-2 years' experience gathering, structuring, and analyzing data
- Advanced proficiency in Excel, including formulas, pivot tables, and structured data models
- Experience with relational databases or low-code platforms such as Airtable, or demonstrated ability to learn quickly
- Analytically minded with excellent problem-solving skills
- Knowledge of data query, cleaning, and transformation practices
- Ability to interpret, visualize, and deliver clear and concise findings to key stakeholders
- Strong attention to detail, particularly with location, personnel, and program data
- Strong written and verbal communication skills
- Self-starter with a commitment to continuous learning and improvement
- Ability to manage multiple concurrent programs and adapt to a client-driven work environment
Preferred:
- Experience with Salesforce reporting and data extraction
- Proficiency in Power BI or a similar business intelligence tool
- Experience with workflow automation platforms such as Make or Power Automate
- Understanding of GIS, mapping, or geospatial analysis concepts such as distance and proximity modeling
- Coding skills in SQL and/or Python
- Familiarity with retail merchandising, field sales, or third-party labor operations
What You Can Expect From 2020 Companies
We welcome every voice, and we are committed to building a truly inclusive environment where your differences are not just welcomed, they are celebrated. We are always identifying opportunities to encourage our team to be their authentic selves, while working to provide a best-in-class experience for our employees. Whether that’s paid holidays, long-term career pathing options, personal development opportunities or professional stretch assignments, you can expect 2020 Companies to support you.
2020’s Commitment
We are committed to creating a diverse and inclusive organization and are proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, pregnancy, disability, age, veteran status, or other dimensions of identity.
Skills Required
- Bachelor's degree in business, analytics, economics, information systems, or similar
- Minimum of 1-2 years' experience gathering, structuring, and analyzing data
- Advanced proficiency in Excel, including formulas, pivot tables, and structured data models
- Experience with relational databases or low-code platforms such as Airtable, or demonstrated ability to learn quickly
- Analytically minded with excellent problem-solving skills
- Knowledge of data query, cleaning, and transformation practices
- Ability to interpret, visualize, and deliver clear and concise findings to key stakeholders
- Strong attention to detail, particularly with location, personnel, and program data
- Strong written and verbal communication skills
- Self-starter with a commitment to continuous learning and improvement
- Ability to manage multiple concurrent programs and adapt to a client-driven work environment
- Experience with Salesforce reporting and data extraction
- Proficiency in Power BI or a similar business intelligence tool
- Experience with workflow automation platforms such as Make or Power Automate
- Understanding of GIS, mapping, or geospatial analysis concepts such as distance and proximity modeling
- Coding skills in SQL and/or Python
- Familiarity with retail merchandising, field sales, or third-party labor operations
2020 Companies Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about 2020 Companies and has not been reviewed or approved by 2020 Companies.
-
Fair & Transparent Compensation — Pay is often characterized as market-competitive and paid on a timely, predictable cadence. Overall sentiment points to many roles feeling fairly compensated, particularly when base pay aligns with posted expectations.
-
Flexible Benefits — Benefit offerings are described as broad and include multiple plan types and options that can vary by role or employment status. Flexible scheduling and program-specific perks are also highlighted as part of the benefits experience.
-
Wellbeing & Lifestyle Benefits — Wellness and mental-health supports are included alongside additional lifestyle-oriented offerings such as pet insurance and employee discounts. Development-related perks like paid training and scholarship programs add to the perceived total rewards package.
2020 Companies Insights
What We Do
WHO WE ARE 2020 Companies is one of the premier outsourced sales and marketing agencies in the United States. Over the past 31 years, our success has resulted from our relentless passion for elevating consumers, team members, and clients. WHAT WE DO Whether launching new products, penetrating new consumer segments, or executing sales and marketing strategies, we can help you reach your business goals. 2020 Companies identifies the opportunities in every challenge and works side-by-side with brands to guarantee success. Each year we deliver over 25 million in-person impressions, and we generate nearly $10 billion in client revenue. Our initiatives deliver a better return on investment for clients and retailers alike. WHERE WE DO IT We train our staff to succeed in any environment and every situation. We equip them with the experience and flexibility to help build brands and exceed goals. From the top of the Fortune 500 to smaller companies ready to expand their market share, 2020 Companies partners with clients of all sizes. HOW DO WE DO IT To guarantee the best team, we recruit, train, and deploy people who meet the exact needs of our clients’ businesses. Teamwork is the foundation of our AMPLIFY training program. We train team members to build relationships with each other, retailers, and consumers. Our blended learning environment inspires team members to be flexible, engaging, and adept at solving problems. We have never missed a launch. 2020 Companies is built on scalable infrastructure, industry-leading speed to market, and benchmark-breaking results. To meet our clients’ goals and deadlines, we recruit, train, staff, and manage the right team for every project. We tailor our initiatives to meet their goals and scale the staff to fit the size and deployment timetable they need.
Gallery
