Business Intelligence Analyst

Job Title:

Business Intelligence Analyst

Location:

Lenexa, KS

• 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.

• 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.