Data Analyst

Delta Dental of Iowa•Johnston, IA

About The Position

As a Data Analyst with Delta Dental of Iowa, you will transform data from multiple sources into meaningful dashboards, reports, and recommendations that help teams make informed decisions. The role primarily supports the Professional Relations team and also partners with Sales and other organizational areas to provide insights supporting operational, quality, contractual, and business objectives. The position develops and manages reporting and analysis, including ad hoc requests; examines treatment profiles and targeted claims; conducts fee schedule analysis; performs quality assurance and management checks; and translates broad datasets into performance insights and recommendations for management. It also supports data governance and troubleshooting, audit documentation, and clear communication of results to stakeholders.

Requirements

Bachelor’s degree in Data Analytics, Business, Finance, Mathematics, or a related field.
Three to five years of relevant work experience.
Superior math and impact analysis skills.
Self-motivated and able to work with a high degree of autonomy.
Analytical problem-solving ability, sound judgment, and the ability to make high-quality decisions quickly.
Excellent organizational skills and ability to work across functions with internal leadership and external customers.
Ability to interpret and develop data reporting and monitoring requirements.
Critical-thinking skills applied to results, metrics, and data management, and a desire to create and build new processes.
Strong collaboration skills and ability to work effectively on project teams and independently.
Excellent verbal, written, and communication skills when working with employees at all levels, including leadership.
High proficiency with Microsoft Office applications.
Strong working knowledge of database environments.
Strong understanding of analytical SQL scripting.
Understanding of Power BI with applicable experience.
Strong ability to organize, analyze, and solve complex problems with attention to detail and accuracy.

Nice To Haves

Experience in health, financial, or operational data analysis.
Experience in insurance or dental.

Responsibilities

Develop a comprehensive understanding of the business areas supported by the role.
Collaborate with internal stakeholders to identify informatics and reporting requirements and desired outcome measures.
Develop, analyze, distribute, and manage reporting and analysis for requested deliverables, including ad hoc data requests.
Generate and analyze reports to identify statistically aberrant treatment profiles; evaluate targeted claims for utilization review, appropriateness, and adherence to national processing policies; and work with appropriate staff to educate dentists and dental office staff about appropriate treatment reporting and compliance with Delta Dental of Iowa processing policy.
Perform annual fee schedule analysis and update fee schedule documentation for all lines of business.
Lead quality assurance and management checks to confirm compliance and accuracy with data and department operations.
Conduct deep-dive analysis to translate broad datasets into performance insights and present findings and recommendations to multiple levels of management.
Report, analyze, and summarize data for cost containment reports, dental consultant activity, and other required department reporting.
Use SQL, Power BI, Network360, geoaccess mapping, and other tools to mine databases for analytical data.
Advise on data policies and data process best-practice standards.
Serve as a point of contact for data definitions, data flows, and troubleshooting data issues, and support data dictionary enhancement.
Work with internal and external audit and project teams to provide complete and accurate audit documentation for initial requests and follow-up activities, including corrective action plans.
Communicate results clearly and effectively to stakeholders.
Perform other duties as assigned.