> Markdown version of [/jobs/ext/4638131-data-analyst-ii](https://www.wearedevelopers.com/jobs/ext/4638131-data-analyst-ii). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Analyst II

- **Company:** Insight Global
- **Location:** Topeka, KS, United States
- **Experience:** Experienced
- **Contract:** Permanent contract
- **Skills:** JIRA, Cloud Computing, Extract Transform Load (ETL), Data Transformation, Data Warehousing, Dimensional Modeling, Python (Programming Language), Microsoft SQL Server, Performance Tuning, Power BI, SQL Databases, Transact-SQL, Data Processing, Azure Data Factory, Powerquery, Tools for Reporting, Azure Synapse Analytics
- **Published:** November 8, 2026
- **Apply:** https://dejobs.org/x/x/9AF915265C5D446095498B7C559E5881/job/

## About the Role

* 2+ years of experience in a Data Analyst I or equivalent role, with demonstrated growth in technical ability and independence. * Advanced Microsoft 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 independently developing production reports and dashboards that meet performance standards and are accepted by stakeholders with minimal rework. * Experience working 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 a similar project and work-management platform.

## Description

Insight Global is seeking a Data Analyst II to serve as the subject matter expert for Power BI reporting and business intelligence delivery across insurance and workforce analytics. The Data Analyst II will independently design, develop, optimize, and maintain complex Power BI reports and dashboards that meet established performance and design standards. They will use advanced DAX, Power Query, data modeling, and visualization techniques to create production-ready reporting solutions. This person will write, troubleshoot, and optimize SQL queries while navigating data warehouse schemas and resolving complex data issues with minimal DBA support. They will perform root cause analysis to determine whether reporting issues originate from source data, ETL processes, warehouse structures, or report logic. The analyst will partner with business stakeholders to gather requirements, translate business needs into technical solutions, maintain documentation, and support end-user adoption. They will
also mentor junior analysts, recommend reporting standards, and contribute to automation, data modernization, and process-improvement initiatives.