JobsData AnalystUnited StatesData Analyst II
Aureon
Posted 7 days ago
Data Analyst II
Aureon · West Des Moines, Iowa, United States
SAVE THIS JOB
In short
The Data Analyst II will collect, clean, and analyze data from multiple systems to create dashboards and actionable insights for business stakeholders. They will also develop reusable data pipelines and explore AI-assisted analytics to improve business processes and decision-making.
What they're looking for
MUST-HAVE SKILLS
ALSO MENTIONED
Candidates should have a bachelor's degree in a relevant field and at least two years of experience in data analysis or business intelligence. Proficiency in SQL, Power BI, and data modeling is required, along with strong analytical and communication skills.
About the employer
Aureon
Connect with Aureon. Connect with Solutions.
We're a leading provider of connectivity and managed technology services in Iowa. Founded in 1984 and owned by 112 independent telecom companies, our network spans over 60,000 miles of fiber and supports more than 1,500 cell towers across the region. Businesses across Iowa rely on us for dedicated internet, managed IT, cybersecurity, UCaaS, and data center services. Our local team supports the organizations that keep Iowa running.
Read moreShow less
Iowa's technology partner. Local infrastructure. Local support. www.aureon.com 800-469-4000
- INDUSTRY
- Technology, Information and Internet
- COMPANY
- Privately Held
- FOUNDED
- 1984
- HEADQUARTERS
- West Des Moines, IA
- SIZE
- 201-500
- OFFICES
- 4 on LinkedIn
KNOWN FOR
Is your LinkedIn profile ready for roles like this?
A free review of your profile, scored against what Data roles ask for, and what to fix first.
Questions about this role
- Is this Aureon role remote?
- Tagged on site.
- Does it sponsor visas?
- Listed as no visa sponsorship.
- What experience does it ask for?
- Listed as 2-5 years.
The posting, in full
Collect, clean, integrate, and analyze structured and unstructured 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 visualization tools. Apply AI-assisted analytics tools, including Copilot features and approved generative AI capabilities, to accelerate data exploration, documentation, insight generation, and report development.
▶ READ THE FULL POSTING▼ CLOSE THE FULL POSTING
ESSENTIAL DUTIES AND RESPONSIBILITIES
- Collect, clean, integrate, and analyze structured and unstructured 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 visualization tools.
- Apply AI-assisted analytics tools, including Copilot features and approved generative AI capabilities, 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.
- Other duties and responsibilities as assigned and required.
EDUCATION, TRAINING, AND EXPERIENCE
- Bachelor's degree from a four-year university in data analytics, computer science, information systems, statistics, business, or a related field desired.
- Two or more years of related experience in data analysis, analytics, business intelligence, reporting, or data administration desired.
- 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 desired.
REQUIRED SKILLS
- Strong analytical problem-solving skills with the ability to connect data findings to business outcomes.
- Ability to work independently under general supervision while collaborating effectively with business and technical stakeholders.
- Ability to plan and prioritize work, manage multiple assignments, and meet deadlines in a changing environment.
- Strong written, verbal, presentation, and data storytelling skills.
- Ability to translate complex technical concepts into clear business language.
- Attention to detail and commitment to data accuracy, documentation, reproducibility, and continuous improvement.
- Ability to adhere to confidentiality, information security, privacy, data governance, and responsible AI standards.
- Curiosity and willingness to learn emerging data and AI technologies.
TOOLS, EQUIPMENT, AND SOFTWARE
- Required: SQL, Microsoft SQL Server, Power BI, DAX, Power Query, and Excel.
- Desired: Microsoft Fabric, including OneLake, Lakehouse, Warehouse, Data Factory, Dataflow Gen2, notebooks, semantic models, and Direct Lake.
- Desired: Python or R for data analysis, automation, statistical analysis, or machine learning.
- Desired: ETL or ELT development, source control, deployment pipelines, data cataloging, and data lineage practices.
- Desired: Experience using Copilot or other approved AI tools for analytics, while validating outputs and protecting confidential data.
- Desired: Use Microsoft Fabric capabilities such as OneLake, Lakehouse, Warehouse, Data Factory, notebooks, data pipelines, Dataflow Gen2, and Direct Lake where appropriate
WORKING CONDITIONS AND PHYSICAL REQUIREMENTS
- Primarily indoor work in an office environment requiring long periods of sitting
- Frequent utilization of manual dexterity and visualizing of a computer screen
- No unusual physical requirements
SAVE THIS JOB
Similar roles open now
Qlik Developer (Data Analyst)
Akira Technologies
Arlington County, Virginia$90k–$120kHybrid · 2 days in office
EMPLOYER'S OWN SITE
POSTED TODAY
Data Analyst, Lead
Booz Allen Hamilton
Colorado$99k–$225kOn site
EMPLOYER'S OWN SITE
POSTED TODAY
Senior Data Analyst
Toast
United States$92k–$187kHybrid
EMPLOYER'S OWN SITE
POSTED TODAY
Senior Data Analyst
Mayo Clinic
Phoenix, Arizona$91k–$136kHybrid
EMPLOYER'S OWN SITE
POSTED TODAY
Marketing Data Analyst, Global Partnerships
Los Angeles, California$96k–$136kOn site
EMPLOYER'S OWN SITE
POSTED TODAY