Data Analyst II

Insight Global; Topeka (KS); In loco; USD 65.000 - 90.000; Tempo pieno

Descrizione del lavoro

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.

Competenze

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

Mansioni

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

Conoscenze

Power BI

DAX

Power Query

Data modeling

SQL/T-SQL

ETL concepts

Azure data services

Python/R

Stakeholder collaboration

Documentation

Mentoring juniors

Strumenti

Azure Synapse Analytics

Azure Data Factory

Power BI Desktop

SQL Server

Jira

Descrizione del lavoro

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.

Skills and Requirements

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

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [e-mail].