Business Intelligence Analyst

Business Intelligence AnalystLocation: Oklahoma City, OK, US, 73120 Req ID: 481609 Benefits: Fuel Your Growth with Love's - company funded tuition assistance Paid Time Off 401(k) – 100% Match up to 5% Medical/Dental/Vision Insurance the first of the month after 30 days Competitive Pay Career DevelopmentWelcome to Love's: The Business Intelligence Analyst supports Customer Marketing, Loyalty, and Mobile App teams by translating business needs into scalable, self-service analytics solutions. This role partners closely with stakeholders and Strategic Analytics Partners to understand key questions, define metrics, and deliver intuitive reporting tools that enable users to independently monitor performance and derive insights. This role sits within Enterprise Analytics and plays an important part in uncovering customer insights, crafting meaningful visuals, monitoring performance, and enabling data-driven decision-making across customer acquisition, retention, and value. The focus of this position is on building high-quality dashboards, data models, and reporting frameworks that provide visibility into customer behavior, program effectiveness, and key performance indicators.Job FunctionsPartner to Define Business NeedsCollaborate with Customer Marketing, Loyalty, and Mobile App stakeholders, along with Strategic Analytics Partners, to understand business objectives, key questions, and reporting needsTranslate ambiguous business requirements into scalable data solutions, standardized metrics, and reusable reporting frameworksAlign on definitions, KPIs, and success measures to ensure consistency across teams and reporting outputsEnable Self-Service AnalyticsDesign and deliver intuitive, user-friendly dashboards and reporting tools in Tableau and Power BI that empower business users to independently explore data and monitor performanceBuild scalable data models and curated data sources that support consistent, repeatable self-service analysisEnsure reporting solutions are accessible, well-documented, and aligned to business workflows to maximize adoption and usabilityDevelop and Maintain Data SolutionsAuthor and maintain advanced SQL queries to create reliable, high-quality datasets across multiple relational database platformsPartner with data engineering teams to define data requirements, source new data, and ensure data is structured for efficient consumptionProactively monitor data quality, identify anomalies, and resolve issues to maintain trust in reporting outputsDrive Insight and Performance VisibilityEnable stakeholders to track customer behavior, campaign performance, and initiative effectiveness through well-designed reporting solutionsSupport deeper analysis when needed by providing structured datasets and guidance on how to interpret and use available dataCreate clear, impactful visualizations that highlight trends, opportunities, and performance driversImprove and Scale Analytics CapabilitiesContinuously enhance reporting solutions to improve usability, performance, and scalabilityIdentify opportunities to standardize and automate reporting processes to reduce manual effort and increase speed to insightIncorporate emerging technologies, including AI-assisted tools, to improve efficiency and elevate analytical capabilitiesPromote best practices in data usage, visualization, and self-service analytics across stakeholder groupsExperience and QualificationsA bachelor's degree is required in a relevant quantitative or business discipline, including but not limited to business analytics, mathematics, statistics, economics, finance, management information systems, computer science, or engineering. A master's degree is preferred. 2-5 years of experience in a business intelligence, reporting, or data analytics role, preferably within retail, sales, marketing, or operations At least 1 year of hands-on experience developing dashboards and reports in Tableau and/or Power BI At least 1 year of hands-on experience writing SQL queries to extract and manipulate data from relational databases Demonstrated proficiency in data management, analytics tools, and the creation of ad-hoc reportsSkills and Physical DemandsExpert-level proficiency in SQL query writing, including complex joins, aggregations, window functions, CTEs, and query optimization across multiple relational database platforms, including SQL Server and Snowflake Proficiency in Tableau and Power BI, including dashboard design, calculated fields, and performance optimization Experience with data wrangling, cleansing, and quality validation Foundational understanding of relational database concepts, structures, and data manipulation, including familiarity with enterprise data environments Knowledge of basic statistical methods and retail math concepts (e.g., margin, conversion, comp sales, basket size) and their application to business analysis Experience identifying and executing reporting automation opportunities to reduce manual effort and improve analytical efficiency Demonstrated ability to rapidly adopt and apply emerging technologies, including AI-assisted tools and workflows, to enhance analytical productivity and decision-support capabilities Proficiency in Microsoft Excel, including pivot tables, lookups, and formulas Excellent written, verbal, and interpersonal communication skills, including experience presenting to executive and non-technical audiences Meticulous attention to detail, particularly in identifying and resolving data discrepancies Highly motivated self-starter with a natural intellectual curiosity and openness to change Requires prolonged sitting, some bending and stooping Manual dexterity sufficient to operate a computer keyboard and calculator Requires normal range of hearing and vision Must be authorized to work in the U.S. without sponsorshipOur Culture: Fueling customers' journeys since 1964, innovation leads the way for this family-owned and operated business headquartered in Oklahoma City. With nearly 40,000 team members, travel stops are the core business along with products and services that provide value for professional drivers, fleets, traveling public, RVers, alternative energy and wholesale fuel customers. Giving back to communities and an inclusive workplace are hallmarks of the award-winning culture. Love's is an Equal Opportunity Employer. Veterans encouraged to apply.