Financial Data Analyst

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

Job summary

Iowa Ortho in Des Moines, IA is seeking a Data Analyst to develop, maintain, and deliver reporting and data visualization solutions that support operations and decision-making across departments.

The role focuses on dashboards, data accuracy, and translating complex data into clear insights for non-technical users, with collaboration across teams to ensure scalable reporting. Proficiency in Power BI, SQL, Access, and Excel is required, along with strong analytical skills and attention to detail.

Qualifications

• Bachelor’s degree in data analytics or related field.
• 2–4 years of data analysis or reporting experience.
• Proficient in Power BI, SQL, Access, and Excel.
• Ability to translate data into clear insights for non-technical users.

Responsibilities

• Design and maintain Power BI dashboards and reports.
• Write and optimize SQL queries across systems.
• Support data modeling and governance initiatives.
• Collaborate with departments to gather reporting requirements.
• Ensure data accuracy and consistency across reports.
• Translate complex data into actionable insights for users.
• Identify opportunities to automate and improve reporting processes.
• Document data sources, definitions, and reporting logic.

Skills

Analytical thinking

Problem solving

Communication

Time management

Independent work

Collaboration

Education

Bachelor's in Data Analytics

Tools

Power BI

SQL

Microsoft Access

Excel

Large datasets

Data quality

Job description

Description

This position is onsite in Des Moines, Iowa.

This position is not eligible for sponsorship

Position Summary

The Data Analyst is responsible for developing, maintaining, and delivering reporting and data visualization solutions that support organizational operations and decision-making. This role works across departments to gather requirements, ensure data accuracy, and provide clear, actionable insights through dashboards and reports. While positioned within the Finance department, this role primarily supports enterprise-wide reporting needs rather than direct financial analysis.

Job Type

Full-time

Key Responsibilities

• Design, develop, and maintain dashboards and reports using Power BI
• Write, optimize, and maintain SQL queries to extract and transform data from multiple systems
• Utilize Microsoft Access and Excel to support data analysis and reporting requirements
• Partner with operational, clinical, administrative, and leadership teams to gather reporting requirements
• Develop and maintain data models to support consistent and scalable reporting
• Produce standard and ad hoc reports to support business operations
• Ensure the accuracy, integrity, and consistency of data across systems and reports
• Translate complex data into clear, actionable insights and visualizations for non-technical users
• Identify opportunities to automate and improve reporting processes
• Document data sources, definitions, and reporting logic
• Support data governance and standardization efforts across the organization

Requirements

• Bachelor’s degree in Data Analytics, Information Systems, Business, or a related field
• 2-4 years of experience in data analysis, reporting, or a related field

Advanced Proficiency In

• Power BI (dashboard development and visualization)
• SQL (data querying and manipulation)
• Microsoft Access and Excel
• Experience working with large, complex datasets from multiple systems
• Strong understanding of data structures, reporting design, and data quality best practices
• Strong analytical and problem-solving skills
• High attention to detail and commitment to data accuracy
• Ability to translate business needs into technical solutions
• Ability to communicate data insights clearly to non-technical audiences
• Strong organizational and time management skills
• Ability to work independently and collaboratively across teams

Physical Requirements

• Must be able to remain in a stationary position for extended periods
• Frequent use of computer, keyboard, and visual displays

Working Conditions

Normal office environment. Non-standard or extended work may be required based on business unit needs. Some travel may be required.

ADA

The above statements cover what are generally believed to be principal and essential functions of this job. Specific circumstances may allow or require some people assigned to the job to perform a somewhat different combination of duties.