Quick overview
Job description
Job Title: Business Intelligence Analyst Location: Lenexa, KS
Responsibilities
- Partner with Accounting, Operations, and other stakeholders to understand analytical and reporting needs and deliver accurate, actionable business intelligence solutions.
- Gather, analyze, and document reporting and analytical requirements through research, data analysis, and stakeholder collaboration.
- Translate complex internal and external business intelligence requests into high-quality analytical products using credible data sources.
- Design, develop, and maintain recurring and ad hoc financial and operational reports, dashboards, and analyses using SQL, Power BI, SSRS, and Excel.
- Develop, optimize, and maintain complex SQL queries, stored procedures, and views to extract, transform, and analyze financial, claims, enrollment, capitation, and utilization data.
- Analyze datasets to identify trends, variances, risks, and opportunities related to budgeting, forecasting, cost analysis, and financial performance.
- Ensure data accuracy, integrity, and consistency through validation, reconciliation, and quality assurance processes.
- Identify and resolve data quality issues and automate reporting processes to improve workflows and self-service analytics.
- Maintain comprehensive documentation of reports, data sources, business logic, and methodologies.
Requirements
- Minimum of 4 years’ experience in a data-focused role leveraging data for business decisions.
- At least 4 years’ experience working with SQL, with a preference for advanced skills and SQL Server.
- Experience developing reports and dashboards using BI tools such as Power BI, SSRS, Excel, or similar platforms.
- Proficiency with SSAS and business intelligence concepts is preferred.
- Ability to analyze and interpret complex data trends and patterns.
- Strong problem-solving, critical-thinking, and attention to detail skills, ensuring data accuracy.
- Ability to translate business questions into effective data solutions.
- Strong SQL skills, including writing and optimizing complex queries (subqueries, window functions, temp tables, CTEs, etc.).
- Proficiency with Microsoft Office Suite, including Word, Excel, PowerPoint, Outlook, and Teams.
- Excellent written and verbal communication skills, with strong interpersonal and organizational skills.
- Ability to manage multiple priorities and projects within tight deadlines.
System One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.
System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.
#M- #LI-
Ref: #431-IT Tampa #LI-BS1 #M1Similar jobs
- MI
Cognos BI Developer/AnalystRecently posted
Mindlance · Rensselaer, NY · On-site · Posted 16 Nov 2026 🇺🇸
SQLTechnologySalary not listed - BG

Governance & Analytics ManagerRecently posted Auto Apply
BGIS · Dallas · Hybrid · Posted 16 Nov 2026 🇺🇸
OracleMicrosoft ExcelMicrosoft Office+8TechnologySalary not listed - CC

Business Intelligence AnalystRecently posted
CrossCountry Consulting · Dallas, TX · Hybrid · Posted 16 Nov 2026 🇺🇸
SQLSnowflakeTableau+3Technology$120k - $175k/yr - CC

Business Intelligence AnalystRecently posted
CrossCountry Consulting · New York, NY · Hybrid · Posted 16 Nov 2026 🇺🇸
SQLSnowflakeTableau+3Technology$120k - $175k/yr - SP

Business Intelligence AnalystRecently posted
Spyglass Partners, LLC · Webster, MA · On-site · Posted 16 Nov 2026 🇺🇸
SQLMicrosoft ExcelPower BITechnologySalary not listed - CC

Business Intelligence AnalystRecently posted
CrossCountry Consulting · Chicago, IL · Hybrid · Posted 16 Nov 2026 🇺🇸
SQLSnowflakeTableau+3Technology$120k - $175k/yr - CC
Business Intelligence AnalystRecently posted
Colorado Community College System Career Site · Colorado Springs, CO · Hybrid · Posted 16 Nov 2026 🇺🇸
SQLMicrosoft OfficeTableau+1Technology$85k - $105k/yr - ME
Business Intelligence AnalystRecently posted
Mitsubishi Electric US, Inc. · Vernon Hills, IL · Hybrid · Posted 16 Nov 2026 🇺🇸
Microsoft ExcelMicrosoft OfficeMicrosoft PowerPoint+3Technology$72.8k/yr - WC
Business Intelligence AnalystRecently posted
West Coast Logistics · Plano, TX · On-site · Posted 16 Nov 2026 🇺🇸
SQLMicrosoft ExcelTableau+2Technology$43/hr - CC

Business Intelligence AnalystRecently posted
CrossCountry Consulting · McLean, VA · Hybrid · Posted 16 Nov 2026 🇺🇸
SQLSnowflakeTableau+3Technology$120k - $175k/yr - EE
Business Intelligence AnalystRecently posted
Enclave Enterprise LLC · Minneapolis, MN · On-site · Posted 16 Nov 2026 🇺🇸
SQLMicrosoft ExcelPower BI+1TechnologySalary not listed - FL
BUSINESS INTELLIGENCE ANALYSTRecently posted
Frank L Blum Construction Co · Asheville, NC · Hybrid · Posted 16 Nov 2026 🇺🇸
SQLdbtSQL Server+2TechnologySalary not listed
