Data Analyst II

Required Skills & Experience

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

Nice to Have Skills & Experience

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

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