Business Intelligence Analyst

GT's Living Foods; Rapid City (SD); Hybrid; USD 85,000 - 95,000; Full time

Benefits offered by this job

Health Insurance

401K with Matching

Employee Assistance Program

Product Discounts

LifeMart Discounts

Job summary

GT’s Living Foods in Vernon, CA is seeking a Business Intelligence Analyst to join our Enterprise Applications BI/Analytics team. You’ll design, develop, and maintain our Power BI platform, delivering scalable BI solutions to drive data-driven decisions across IT, Sales, Finance, Marketing, Manufacturing, and Operations.

You’ll create reports, dashboards, KPI views, and mobile analytics, partner with stakeholders to define KPIs, and ensure data quality, governance, and self-service access, while

Qualifications

• 2+ years of hands-on reporting and dashboard development in Power BI.
• 2+ years data preparation, gateways, and warehousing projects.
• Strong SQL with source-to-target validation across ERP systems.
• Knowledge of data modeling, ETL/ELT fundamentals.

Responsibilities

• Design, develop, and maintain Power BI reports, views, dashboards, and scorecards.
• Collaborate with IT, Finance, Sales, Marketing, and Ops to deliver data-driven insights.
• Enable self-service analytics through scalable data models and governance.

Skills

Power BI development

Data warehousing

SQL

Dimensional modeling

DAX

Power Query

Azure data services

Power BI Service administration

Requirements gathering

Dashboard prototyping

Stakeholder communication

Education

Bachelor’s Degree in Computer Science, Data Analytics, Information Systems, or related field

Tools

Power BI

Azure

SQL Server

Job description

Company & Culture

At GT’s Living Foods, we’re more than just a company – we’re a community passionate about creating a healthier, happier world. Over the last 30 years we’ve built a culture of inclusivity and authenticity, where our shared values create an environment that inspires you to do your best while achieving meaningful results. Our mission to transform health and happiness through potent, living foods has established us as the #1 Kombucha brand and a leader in the Health & Wellness space.

At GT’s Living Foods, we’re more than just a company – we’re a community passionate about creating a healthier, happier world. Over the last 30 years we’ve built a culture of inclusivity and authenticity, where our shared values create an environment that inspires you to do your best while achieving meaningful results. Our mission to transform health and happiness through potent, living foods has established us as the #1 Kombucha brand and a leader in the Health & Wellness space.

Job Description

Job Description: The Business Intelligence Analyst will be part of our Enterprise Applications BI/Analytics Team and will be responsible for designing, developing, and maintaining our Power BI platform. As the Power BI developer, this position will be responsible for providing scalable, best-in-class Business Intelligence/Reporting solutions and processes. With a focus on driving data-driven decision-making, this resource will create innovative reports, views, dashboards, scorecards, visualizations, and mobile analytics apps using Power BI and Power Platform. This role will be heavily involved with requirements gathering, Data Profiling, developing KPIs, metrics, dashboards, data integration and adoption of the platform. Cross-departmental engagement working closely with the IT, Sales, Finance, Marketing, Manufacturing, and Operations teams to develop data-informed reports, ultimately supporting successful business growth, operational efficiency, and sales acceleration. To succeed in this role, you must have demonstrated skill at Enterprise data warehouse and a broad understanding of data integration, storage, visualization tools, and data modeling. Overall, the focus will also be on enabling self-service data analysis for ease of reporting and analytics visualization while consistently focusing on data accessibility, efficiency, governance, performance, and integrity.

Requirements

• 2+ years of hands-on experience developing reports and dashboards in Power BI.
• 2+ years of experience with data preparation, data gateways, and data warehousing projects.
• Strong data-testing skills using SQL, including source-to-target validation across ERP source systems, staging layers, data warehouse targets, and reports.
• Fundamental SQL knowledge pertaining to data extraction, transformation, and performance optimization.
• Advanced knowledge of dimensional modeling, DAX, Power Query, and Power BI visualization best practices.
• Bachelor’s Degree in Computer Science, Data Analytics, Information Systems, or related field.
• Understanding of data warehouse concepts and ELT/ETL fundamentals.
• Familiarity with Azure data services such as Azure SQL Database, Azure Synapse Analytics, or equivalent cloud technologies.
• Hands-on experience with Power BI Service administration, workspace management, security, scheduled refreshes, and gateway configuration.
• Experience gathering and analyzing business requirements and translating them into reporting solutions.
• Experience prototyping, designing, developing, and supporting interactive dashboards and reports.
• Experience working with business stakeholders to define KPIs, reporting requirements, and data-validation criteria.
• Ability to design repeatable, maintainable, and scalable analytics solutions.
• Strong analytical, problem-solving, and communication skills.

Preferred Qualifications

• Foundational knowledge of Power Automate and Power Apps.
• Foundational knowledge of artificial intelligence, generative AI, and their applications in data analytics and business intelligence.
• Familiarity with AI-assisted analytics capabilities such as Microsoft Copilot, Power BI Copilot, or similar tools.
• Experience developing business intelligence and reporting solutions using Microsoft Dynamics 365 data is a plus.
• Microsoft Power BI certification, such as Microsoft Certified: Power BI Data Analyst Associate (PL-300).

GT’s Employee Experience (Benefits/Perks)

• Health Insurance: Medical, Dental, Vision, and Life Insurance
• 401K with Matching
• Employee Assistance Program
• Discounts on the amazing GT’s product line (available for pickup at headquarters only)
• Corporate Discounts with our partners through LifeMart (concert & sporting event tickets, cell phone service, gifts, restaurants, hotels, childcare, and more!)

Job Details

• Employment Type: Full Time, Exempt
• Schedule: Monday through Friday, business hours; onsite 4 days (Vernon, CA); remote 1 day; with additional weekend or on-call requirements
• Work Attire: Use good judgment, keeping in mind the nature of their work, their safety and the safety of others, and their need to interact with the public.
• Pay Range: $85,000 - $95,000, bonus eligible

GT's Living Foods, LLC is an Equal Opportunity Employer committed to hiring a diverse workforce and maintaining an inclusive culture.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, age, national origin, protected veteran status, disability or any other basis protected under federal, state or local laws.