Business Intelligence Analyst

2020 Companies
Southlake, TX, United States
13 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Compensation
$70,000.0
Working hours
Regular working hours

Tech stack

Microsoft Excel Data Analysis Big Data Databases Web Scraping Data Integrity Data Mining Data Visualization Database Queries Python (Programming Language) Lookup Table Office Suite
+13 more
Pivot Tables Powerpivot Microsoft PowerPoint Raw Data Power BI Salesforce.Com SAP (Applications) SQL Databases Tableau (Software) Qliksense Macros Powerquery Programming Languages

Job description

  • 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, 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.

Requirements

Fuel your analytical fire and advance your career! We’re seeking a motivated Business Intelligence Analyst eager to learn, grow, and tackle exciting new challenges. You’ll have the opportunity to collaborate with internal and external stakeholders, becoming a trusted advisor and a data expert. From conducting thorough research to crafting visually engaging presentations, you’ll play a vital role in shaping our understanding of the market. If you’re a data enthusiast passionate about uncovering the “why” behind the numbers, we want you on our team., * 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, * 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 & conditions

Pay: Starting at $70k Annually

Schedule: Monday - Friday Schedule

What’s in it for you?

  • Work remote
  • Competitive annual salary: $70,000, paid weekly
  • Next day pay on demand with DailyPay
  • 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

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on 2020companies.wd1.myworkdayjobs.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:42 min

Combining technical skills with strong business communication

Lukas KÜlbl ¡ LIVE

4:09 min

Challenges of interpreting raw data with language models

Clemens Vasters Clemens Vasters ¡ WWC 2025

1:46 min

Traditional data architecture before Microsoft Fabric

Dr. Alexander Wachtel Dr. Alexander Wachtel +1 ¡ WWC 2025

3:03 min

Exploring declarative and procedural macro subtypes in Rust environments

Mykhailo Maidan ¡ LIVE

4:18 min

Core pillars of talent acquisition business partnering

Mahmoud Aly Mahmoud Aly ¡ WWC Europe 2026

2:09 min

Uncovering hidden coordinate manipulation communities in binary data

Nolan Royalty ¡ Coffee With Developers

Videos

See all

Related articles

See all