Data Insights Analyst II — AI-Driven Analytics & Dashboards

Aureon Network Services; West Des Moines (IA); On-site; USD 65,000 - 95,000; Full time

Job summary

Aureon Network Services is seeking a data analyst to collect, clean, integrate, and analyze data from multiple business systems using SQL, Python, Power Query, and Power BI. You will create dashboards, reports, scorecards, and semantic models to support decision-making across the organization.

The role requires strong analytical problem‑solving, data storytelling, and the ability to translate technical findings into clear business recommendations for both technical and nontechnical stakeholders.

Qualifications

• Bachelor's degree in data analytics, computer science, information systems, statistics, business, or related field.
• 2+ years of experience in data analysis, analytics, BI, reporting, or data administration.
• Hands-on experience with data visualization, data modeling, data preparation, and data quality practices.
• Exposure to cloud analytics platforms, Microsoft Fabric, Azure data services, AI-assisted analytics, or ML concepts.

Responsibilities

• Collect, clean, integrate, and analyze data from multiple business systems using SQL, Python, Power Query, or other approved tools.
• Create and publish dashboards, reports, scorecards, semantic models, and presentations using Power BI, Excel, and other approved tools.
• Apply AI-assisted analytics tools to accelerate data exploration, documentation, insight generation, and report development.
• Identify trends, patterns, anomalies, and business drivers, then translate findings into clear recommendations for technical and nontechnical audiences.
• Partner with business users to understand objectives, define data requirements, document business rules, and translate needs into technical specifications and analytical solutions.
• Develop and maintain reusable data pipelines, dimensional models, semantic models, calculations, and data quality controls.
• Validate data accuracy, test solutions, troubleshoot issues, reconcile results, and document assumptions, lineage, definitions, and limitations.
• Explore practical AI and machine learning use cases, assist with prototypes, and evaluate results against business value, data quality, security, privacy, and responsible AI expectations.
• Support data migrations, system interfaces, and modernization initiatives involving on-premises and cloud data platforms.
• Review current processes and recommend opportunities for automation, standardization, self-service analytics, and improved user experience.
• Stay current on analytics, Microsoft Fabric, Power BI, AI, data governance, and visualization best practices.

Education

Bachelor's degree in data analytics or related field

Tools

SQL

Microsoft SQL Server

Power BI

DAX

Power Query

Excel

Python

R

Microsoft Fabric

OneLake

Lakehouse

Data Factory

Dataflow Gen2

Notebooks

Semantic models

Direct Lake

ETL/ELT

Source control

Deployment pipelines

Data cataloging

Data lineage

Copilot

Job description

Aureon Network Services is seeking a data analyst to collect, clean, integrate, and analyze data from multiple business systems using SQL, Python, Power Query, and Power BI. You will create dashboards, reports, scorecards, and semantic models to support decision-making across the organization.

The role requires strong analytical problem‑solving, data storytelling, and the ability to translate technical findings into clear business recommendations for both technical and nontechnical stakeholders.