Data Analyst II: AI-Driven Analytics & Viz Expert

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

Job summary

Aureon is seeking a data analytics professional to collect, clean, and analyze data from multiple systems using SQL, Python, and Power Query. You will publish dashboards and semantic models with Power BI and Excel, and apply AI-assisted analytics to speed exploration and reporting.

You will identify trends and translate findings into clear recommendations for both technical and nontechnical audiences, partnering with business users to define data requirements and build scalable solutions.

Qualifications

• Bachelor's degree in data analytics, computer science, information systems, statistics, business, or related field.
• Two+ 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 machine learning concepts.

Responsibilities

• Collect, clean, integrate, and analyze data from multiple business systems using SQL, Python, Power Query, or approved tools.
• Create and publish dashboards, reports, scorecards, semantic models, and presentations using Power BI, Excel, and other tools.
• Apply AI-assisted analytics tools to accelerate data exploration, documentation, insight generation, and report development.
• Identify trends, patterns, anomalies, and business drivers; translate findings into clear recommendations for technical and nontechnical audiences.
• Partner with business users to understand objectives, define data requirements, document rules, and translate needs into specifications and 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 processes and opportunities for automation, self-service analytics, and improved user experience.
• Stay current on analytics, Microsoft Fabric, Power BI, AI, data governance, and visualization best practices.

Skills

Analytical thinking

Data storytelling

Independent work

Communication

Problem solving

Education

Bachelor's degree in data analytics or related field

Tools

SQL

Power BI

Power Query

Excel

DAX

Python

SQL Server

Job description

Aureon is seeking a data analytics professional to collect, clean, and analyze data from multiple systems using SQL, Python, and Power Query. You will publish dashboards and semantic models with Power BI and Excel, and apply AI-assisted analytics to speed exploration and reporting.

You will identify trends and translate findings into clear recommendations for both technical and nontechnical audiences, partnering with business users to define data requirements and build scalable solutions.