Business Intelligence Analyst

Jobtailor; Missouri; On-site; USD 80,000 - 110,000; Full time

Job summary

Jobtailor is seeking a proficient BI professional to design, build, and maintain dashboards, KPI reporting, and forecasting models that drive revenue decisions. You will develop revenue forecasting, apply regression techniques, and create intuitive visualizations for stakeholders across divisions.

You will collaborate with IT and business teams to integrate data sources, automate workflows with Power Automate, and provide training and documentation to ensure insights are used effectively.

Qualifications

• 3+ years in BI, analytics, forecasting, or reporting roles.
• Expert Excel with advanced formulas, PivotTables, Power Query.
• Experience building Power BI dashboards.
• Strong data analysis, forecasting, and visualization skills.

Responsibilities

• Design, build, and maintain automated dashboards, KPI reporting, and forecasting models
• Develop and maintain revenue forecasting models to support the sales team
• Apply statistical techniques, including multiple regression analysis
• Develop intuitive visualizations for operational and financial decision-making
• Perform ad hoc reporting submitted through Jira for multiple divisions
• Partner with IT and business teams to integrate data sources and validate outputs
• Automate recurring reporting and forecasting workflows
• Provide training and documentation to help users effectively consume insights

Skills

BI experience

Excel advanced

Data analysis concepts

Statistics basics

Attention to detail

Communication

Automation/AI in analytics

Python basics

Power Automate

Low-code tools

AI-assisted analysis

SQL basics

Qlik familiarity

Tools

Power BI

Jira

Qlik

Power Query

Python

Power Automate

SQL

Job description

• Design, build, and maintain automated dashboards, KPI reporting, and forecasting models
• Develop and maintain revenue forecasting models to support the sales team in new business opportunities
• Apply statistical techniques, including multiple regression analysis, to identify performance drivers and improve forecast accuracy
• Develop intuitive visualizations for operational and financial decision-making
• Perform ad hoc reporting submitted through Jira for multiple divisions
• Partner with IT and business teams to integrate data sources and validate outputs
• Automate recurring reporting and forecasting workflows to reduce manual effort
• Provide training and documentation to help users effectively consume insights

Requirements

• 3+ years of experience in business intelligence, analytics, forecasting, or reporting roles
• Expert-level Microsoft Excel skills including advanced formulas, PivotTables, Power Query, and basic modeling
• Experience building reports or dashboards in Power BI
• Strong understanding of data analysis, forecasting concepts, and data visualization best practices
• Foundational statistics knowledge, including correlation and multiple regression analysis
• Basic understanding of data structures, tables, and relationships
• Strong attention to detail and data accuracy
• Ability to communicate insights clearly to non-technical stakeholders
• Understanding of how automation and AI can be embedded into analytics and forecasting workflows
• Working knowledge of Python for data cleaning, automation, statistical analysis, or forecasting workflows
• Experience using Power Automate to automate workflows, integrate systems, or support low-code solutions
• Exposure to building low-code or no-code internal tools or lightweight web applications
• Familiarity with AI-assisted analysis, including how to structure effective AI prompts and questions to support analysis, documentation, and insight generation
• Basic SQL experience for querying and validating data
• Experience working with enterprise BI platforms such as Qlik or similar tools

Demonstrates expertise in business intelligence and analytics, with a strong focus on revenue forecasting, data visualization, and automation. Proficient in utilizing advanced Excel functions, Power BI, and Python for data analysis and reporting.

Highest-signal resume keywords

• Business Intelligence
• Revenue Forecasting
• Data Visualization
• Power BI Reporting
• Python for Data Analysis

Hard Skills

• Advanced Microsoft Excel
• Multiple Regression Analysis
• Data Analysis
• Statistical Techniques
• SQL Querying
• Power Automate
• Data Structures
• KPI Reporting
• Forecasting Models
• Ad Hoc Reporting

Soft Skills

• Attention to Detail
• Clear Communication
• Training and Documentation

Industry Keywords

• Business Intelligence
• Analytics
• Forecasting
• Reporting
• Data Visualization Best Practices

Tools & Technologies

• Power BI
• Jira
• Qlik
• Power Query
• AI-Assisted Analysis