Business Intelligence Analyst

Summary

Job Details

Job Type: Regular Work Location: Client Support Center - Southlake, TX 76092

Pay: Starting at $70k Annually

Competitive annual salary: $70,000, paid weekly

Next day pay on demand with DailyPay

Schedule: Monday - Friday

Work remote

Responsibilities

• Manage and execute web scraping activities using internal tools to gather competitive intelligence and market data
• Provide expert support to field teams on best practices for identifying, reporting, and leveraging competitive intelligence
• Conduct in-depth competitive analysis, market research, and ad hoc analytics to provide actionable insights into key competitors in the retail environment
• Lead survey generation and data consolidation efforts, leveraging MSFT Office Suite (Power BI, Excel, Power Query) and SQL for efficient analysis
• Develop compelling data visualizations and dashboards to effectively communicate market trends, forecasts, and revenue analysis to stakeholders
• Partner with field training departments to develop programs highlighting key market trends and empowering teams with data-driven insights
• Conduct comprehensive online research on direct and indirect competitor presence, branding, and digital strategies
• Synthesize data from multiple sources (online research, field feedback, raw data, CRM) to create holistic reports that inform strategic decision-making
• Support corporate research initiatives by providing data-driven insights and recommendations to internal teams for business development
• Proactively monitor, track, and report on shifts in retailer strategies, emerging market trends, and competitor activities
• Analyze competitors' key initiatives, product launches, marketing campaigns, and other relevant activities to provide a comprehensive view of their strategies
• Identify potential leads for new business tools and solutions, establish contact, and schedule discovery meetings to explore partnership opportunities
• Utilize advanced Excel skills (including Power Query) to automate reporting processes and perform complex data analysis
• Apply SQL proficiency to extract, manipulate, and analyze data from databases for reporting and ad-hoc analysis
• Translate complex data findings into clear, concise, and actionable insights for stakeholders at all levels
• Contribute to forecasting efforts by leveraging historical data, market trends, and statistical modeling techniques
• Perform revenue analysis to identify trends, growth opportunities, and areas for improvement
• Stay current on industry best practices and emerging trends in data analysis, market research, and competitive intelligence
• Execute additional initiatives and projects assigned to support the team's and the organization's overall goal

Qualifications

• Experience: 3-5 years of proven experience in a business data analysis, strategy, research, or consulting role, demonstrating increasing responsibility and impact
• Analytical Skills: Strong analytical and problem-solving skills with the ability to collect, organize, analyze, and interpret large datasets Proficiency in analyzing sales trends, product landscape, consumer journey, market dynamics, and other relevant business metrics Experience with data mining, statistical modeling, and forecasting techniques is a plus Ability to identify key insights and translate complex data into actionable stakeholder recommendations
• Technical Skills: Advanced proficiency in Microsoft Excel (including pivot tables, VLOOKUP, macros, and ideally Power Query/Power Pivot) Intermediate to advanced skills in PowerPoint for creating compelling presentations and reports Experience with data visualization tools such as Power BI (or Tableau, Qlik Sense, etc.) is essential Familiarity with SQL for data extraction and manipulation is highly desired Experience with programming languages like Python (or R) for data analysis and automation is a strong advantage Knowledge of CRM systems (e.g., Salesforce) and ERP systems (e.g., SAP) is beneficial
• Business Acumen: Ability to understand client goals and demonstrate value through strategic, data-driven recommendations Considering both internal and external factors, the capacity to think holistically about a client's business and industry Strong understanding of business processes and the ability to identify areas for improvement
• Communication & Presentation Skills: Excellent written and verbal communication skills, with the ability to effectively present complex information to technical and non-technical audiences Strong research skills and the ability to translate research findings into high-quality presentations and reports
• Personal Attributes: Ability to learn and adapt quickly to new technologies, methodologies, and business environments Strong work ethic, self-starter attitude, and ability to manage multiple projects simultaneously Collaborative mindset with the ability to work effectively in cross-functional teams Detail-oriented with a commitment to accuracy and data integrity

Benefits

• Health/Dental/Vision benefits
• 401K Program with matching
• Paid Time Off
• Paid Holidays
• Mobile or Internet Reimbursement
• Scholarship opportunities for employees and direct family members
• Employee Assistance Program
• Leadership Development Program

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.

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.

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 continually 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 COMPANIES' 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.

Job Description

Job Details

Job Type: Regular Work Location: Client Support Center - Southlake, TX 76092

Pay: Starting at $70k Annually

Competitive annual salary: $70,000, paid weekly

Next day pay on demand with DailyPay

Schedule: Monday - Friday

Work remote

Responsibilities

• Manage and execute web scraping activities using internal tools to gather competitive intelligence and market data
• Provide expert support to field teams on best practices for identifying, reporting, and leveraging competitive intelligence
• Conduct in-depth competitive analysis, market research, and ad hoc analytics to provide actionable insights into key competitors in the retail environment
• Lead survey generation and data consolidation efforts, leveraging MSFT Office Suite (Power BI, Excel, Power Query) and SQL for efficient analysis
• Develop compelling data visualizations and dashboards to effectively communicate market trends, forecasts, and revenue analysis to stakeholders
• Partner with field training departments to develop programs highlighting key market trends and empowering teams with data-driven insights
• Conduct comprehensive online research on direct and indirect competitor presence, branding, and digital strategies
• Synthesize data from multiple sources (online research, field feedback, raw data, CRM) to create holistic reports that inform strategic decision-making
• Support corporate research initiatives by providing data-driven insights and recommendations to internal teams for business development
• Proactively monitor, track, and report on shifts in retailer strategies, emerging market trends, and competitor activities
• Analyze competitors' key initiatives, product launches, marketing campaigns, and other relevant activities to provide a comprehensive view of their strategies
• Identify potential leads for new business tools and solutions, establish contact, and schedule discovery meetings to explore partnership opportunities
• Utilize advanced Excel skills (including Power Query) to automate reporting processes and perform complex data analysis
• Apply SQL proficiency to extract, manipulate, and analyze data from databases for reporting and ad-hoc analysis
• Translate complex data findings into clear, concise, and actionable insights for stakeholders at all levels
• Contribute to forecasting efforts by leveraging historical data, market trends, and statistical modeling techniques
• Perform revenue analysis to identify trends, growth opportunities, and areas for improvement
• Stay current on industry best practices and emerging trends in data analysis, market research, and competitive intelligence
• Execute additional initiatives and projects assigned to support the team's and the organization's overall goal

Qualifications

• Experience: 3-5 years of proven experience in a business data analysis, strategy, research, or consulting role, demonstrating increasing responsibility and impact
• Analytical Skills: Strong analytical and problem-solving skills with the ability to collect, organize, analyze, and interpret large datasets Proficiency in analyzing sales trends, product landscape, consumer journey, market dynamics, and other relevant business metrics Experience with data mining, statistical modeling, and forecasting techniques is a plus Ability to identify key insights and translate complex data into actionable stakeholder recommendations
• Technical Skills: Advanced proficiency in Microsoft Excel (including pivot tables, VLOOKUP, macros, and ideally Power Query/Power Pivot) Intermediate to advanced skills in PowerPoint for creating compelling presentations and reports Experience with data visualization tools such as Power BI (or Tableau, Qlik Sense, etc.) is essential Familiarity with SQL for data extraction and manipulation is highly desired Experience with programming languages like Python (or R) for data analysis and automation is a strong advantage Knowledge of CRM systems (e.g., Salesforce) and ERP systems (e.g., SAP) is beneficial
• Business Acumen: Ability to understand client goals and demonstrate value through strategic, data-driven recommendations Considering both internal and external factors, the capacity to think holistically about a client's business and industry Strong understanding of business processes and the ability to identify areas for improvement
• Communication & Presentation Skills: Excellent written and verbal communication skills, with the ability to effectively present complex information to technical and non-technical audiences Strong research skills and the ability to translate research findings into high-quality presentations and reports
• Personal Attributes: Ability to learn and adapt quickly to new technologies, methodologies, and business environments Strong work ethic, self-starter attitude, and ability to manage multiple projects simultaneously Collaborative mindset with the ability to work effectively in cross-functional teams Detail-oriented with a commitment to accuracy and data integrity

Benefits

• Health/Dental/Vision benefits
• 401K Program with matching
• Paid Time Off
• Paid Holidays
• Mobile or Internet Reimbursement
• Scholarship opportunities for employees and direct family members
• Employee Assistance Program
• Leadership Development Program

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.

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.

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 continually 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 COMPANIES' 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.