Financial Data Analyst

Iowa Orthopedic Center; Des Moines (IA); On-site; USD 65,000 - 90,000; Full time

Job summary

Iowa Orthopedic Center in Des Moines, IA is seeking a Data Analyst to develop, maintain, and deliver reporting and data visualization solutions across the organization. This role works with multiple departments to gather requirements and ensure data accuracy, providing clear, actionable insights through dashboards and reports.

Position sits in Finance but supports enterprise-wide reporting rather than pure financial analysis; requires Bachelor's in a related field and 2–4 years of experience.

Qualifications

• Bachelor’s degree in a related field
• 2–4 years of experience in data analysis, reporting, or related field
• Proficiency with Power BI, SQL, Access, and Excel is expected

Responsibilities

• Design, develop, and maintain dashboards and reports using Power BI
• Write, optimize, and maintain SQL queries to extract data from multiple systems
• Utilize Microsoft Access and Excel to support data analysis and reporting
• Collaborate with operational, clinical, administrative, and leadership teams to gather reporting requirements
• Develop and maintain data models to support consistent reporting
• Produce standard and ad hoc reports to support business operations
• Ensure data accuracy, integrity, and consistency across systems and reports
• Translate complex data into clear insights 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

Skills

Data analysis

Data visualization

Reporting

Requirements gathering

Communication of insights

Problem solving

Attention to detail

Independent and collaborative

Education

Bachelor's degree in Data Analytics, Information Systems, Business, or related field

Tools

Power BI

SQL

Microsoft Access

Excel

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

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.