Data Analyst

Delta Dental of Iowa•Urbandale, 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 areas of the organization to provide insights supporting operational, quality, contractual, and business objectives. The position develops, analyzes, distributes, and manages reporting and analysis, including ad hoc requests; evaluates treatment profiles and claims; conducts fee schedule analysis; leads quality assurance and management checks; and translates broad data sets into performance insights and recommendations for management. It also supports data policies, data processes, data definitions, data flows, troubleshooting, and audit documentation. The role uses SQL, Power BI, Network360, geoaccess mapping, and other tools to mine databases and communicate findings 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-motivation and ability to work with a high degree of autonomy.
Analytical problem-solving ability, sound and timely judgment and decision-making, and excellent organization skills for working across functions with internal leadership and external customers.
Ability to interpret and develop data reporting and monitoring requirements.
Critical-thinking experience working with 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 outcomes measurement.
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 on 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 data sets 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 analytic data.
Advise on data policies and data process best-practice standards.
Serve as the go-to person 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 required follow-up activities, including corrective action plans.
Clearly communicate results to stakeholders.
Perform other duties as assigned.