2020 Companies Logo

2020 Companies

Business Intelligence Analyst

Posted Yesterday
In-Office
Southlake, TX
70K-70K Annually
Mid level
In-Office
Southlake, TX
70K-70K Annually
Mid level
Perform competitive intelligence and market research using web scraping, SQL, Excel (Power Query), and Power BI. Build dashboards and visualizations, support field teams, synthesize multi-source data, forecast revenue, and provide data-driven recommendations to stakeholders. Collaborate cross-functionally and support research and business development initiatives.
The summary above was generated by AI

Job Type:

Regular

Work Location:

Client Support Center - Southlake, TX 76092

Overview:

2020 Companies has a full-time remote Business Intelligence Analyst opportunity! 

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.  

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 

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

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

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.

Similar Jobs

7 Days Ago
Remote or Hybrid
United States
100K-110K Annually
Senior level
100K-110K Annually
Senior level
Insurance • Logistics • Software • Transportation • Business Intelligence
Transform data into actionable insights by building dashboards, reports, and visualizations. Partner with cross-functional teams and data engineering to ensure data quality, lineage, and AI-ready metadata. Audit datasets, define monitoring rules, document data dictionaries, pilot AI-assisted BI tools, and apply hypothesis-driven analysis to surface insights that inform business decisions.
Top Skills: Ai Coding AssistantsAtlanEtl ToolsLlm-Based ToolsLookerModern Data StackNoSQLOpenmetadataPower BIPythonRedashSnowflakeSQL
8 Days Ago
In-Office or Remote
55-55 Hourly
Senior level
55-55 Hourly
Senior level
Information Technology
Serve as liaison between business stakeholders and technology to elicit requirements, evaluate solutions, and drive delivery of BI and data initiatives. Model and map processes, write SQL, support integration mapping, manage ADO/Agile product ownership, create technical documentation, and use BI tools (Power BI, Qlik, MicroStrategy). Ensure data governance, metadata management, and payments domain alignment while managing multiple projects and stakeholders.
Top Skills: AgileAzure Devops (Ado)Data ArchitectureData GovernanceKanbanMachine LearningMetadata ManagementMicrostrategyOneplanPower BIQlikSQL
20 Days Ago
In-Office
Junior
Junior
Automotive • Manufacturing
Partner with Finance and cross-functional teams to design, build, and maintain BI solutions. Develop and optimize SQL queries, Snowflake-based solutions, SSAS/Fabric semantic models, ETL pipelines, and financial reports. Ensure data governance, integrity, and performance; provide end-user support and training; and participate in system maintenance, upgrades, and integrations.
Top Skills: Azure Data Factory (Adf)DaxETLExcel Power PivotInformaticaMicrosoft FabricMicrosoft SsasSnowflakeSQLSsis

What you need to know about the Charlotte Tech Scene

Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.

Key Facts About Charlotte Tech

  • Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
  • Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
  • Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
  • Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
  • Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account