Data Analyst

Delta Dental of Iowa is looking for a data-focused analyst to turn operational and business information into dashboards, reports, and recommendations. This onsite role in Johnston, IA primarily supports the Professional Relations team, with opportunities to partner with Sales and other areas to help drive decisions across quality, contractual, and business objectives.

What you’ll do

• Build a comprehensive understanding of the business areas supported by the role, and align analytics to team and department outcomes.
• Collaborate with internal stakeholders to define informatics needs, reporting requirements, and how success should be measured.
• Develop, analyze, distribute, and manage reporting and analysis deliverables, including ad hoc data requests.
• Produce and analyze reports to identify statistical aberrant treatment profiles, evaluate targeted claims for utilization review, appropriateness, and adherence to national processing policies, and support staff education on compliant treatment reporting.
• Lead annual fee schedule analysis and maintain fee schedule documentation for all lines of business.
• Perform quality assurance and management checks to confirm compliance and accuracy with data and department operations.
• Conduct deep-dive analysis to translate broad datasets into actionable performance insights, presenting findings and recommendations to multiple levels of management.
• Report and analyze data for cost containment reporting, dental consultant activity, and other required department outputs.
• Use SQL, Power BI, Network360, geoaccess mapping, and other tools to mine database sources for analytic data.
• Advise on data policies and data process best practice standards, and serve as the go-to resource for data definitions, data flows, and data issue troubleshooting.
• Support data dictionary enhancements and contribute complete, accurate audit documentation for initial requests, follow-ups, and corrective action plan activities.
• Communicate results clearly to stakeholders, and perform other duties as assigned.

Requirements

• Bachelor’s Degree in Data Analytics, Business, Finance, Mathematics, or a related field.
• 3 to 5 years of relevant work experience.
• Superior math and impact analysis skills.
• Self-motivated with the ability to work with a high degree of autonomy.
• Ability to interpret and develop data reporting and monitoring requirements.
• Experience using critical thinking with metrics and data management, including a desire to create and build new processes.
• Strong collaboration skills across project teams and independently.
• Excellent verbal and written communication skills across all levels of employees, including leadership.
• High proficiency with Microsoft Office applications.
• Strong working knowledge of database environments and 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.

Tools you’ll use

• SQL, Power BI, Network360, geoaccess mapping, Microsoft Office

Preferred

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