Power BI Data Analyst II - Advanced Reporting & SQL

Insight Global; Topeka (KS); On-site; USD 65,000 - 90,000; Full time

Job summary

Insight Global is seeking a Data Analyst II to lead Power BI reporting and BI delivery across insurance and workforce analytics. The role designs, develops, and maintains complex BI solutions using DAX, Power Query, data modeling, and advanced visualization techniques.

The candidate will write & optimize SQL queries, navigate data warehouses, and partner with stakeholders to translate requirements into technical solutions. Mentorship and process-improvement initiatives are part of the role.

Qualifications

• 2+ years in a Data Analyst I or equivalent role, with demonstrated growth in technical ability and independence.
• Advanced Power BI skills, including DAX, Power Query/M, data modeling, performance tuning, and visualization design.
• Intermediate-to-advanced T-SQL experience, including query development, optimization, and troubleshooting within Microsoft SQL Server.
• Working knowledge of relational and dimensional data architectures, including data warehouse schemas, star schemas, fact tables, and dimension tables.
• Experience in a public-sector or government-agency data environment.
• Experience with ETL processes, dimensional modeling, and cloud platforms such as Azure Synapse Analytics or Azure Data Factory.
• Microsoft Certified: Power BI Data Analyst Associate, PL-300, or another relevant analytics certification.
• Experience using Python or R for data manipulation and automation; familiarity with Jira or similar project management platforms.

Responsibilities

• Design, develop, optimize, and maintain complex Power BI reports and dashboards that meet performance and design standards.
• Use advanced DAX, Power Query, data modeling, and visualization techniques to create production-ready reporting solutions.
• Write, troubleshoot, and optimize SQL queries while navigating data warehouse schemas and resolving data issues with minimal DBA support.
• Partner with business stakeholders to gather requirements, translate needs into technical solutions, and support end-user adoption.
• Mentor junior analysts and contribute to reporting standards, automation, and data modernization initiatives.

Skills

Power BI

DAX

Power Query

Data modeling

SQL/T-SQL

ETL concepts

Azure data services

Python/R

Stakeholder collaboration

Documentation

Mentoring juniors

Tools

Azure Synapse Analytics

Azure Data Factory

Power BI Desktop

SQL Server

Jira

Job description

Insight Global is seeking a Data Analyst II to lead Power BI reporting and BI delivery across insurance and workforce analytics. The role designs, develops, and maintains complex BI solutions using DAX, Power Query, data modeling, and advanced visualization techniques.

The candidate will write & optimize SQL queries, navigate data warehouses, and partner with stakeholders to translate requirements into technical solutions. Mentorship and process-improvement initiatives are part of the role.