Data Analyst

Data AnalystCome Smile with Us! Turn data into insights that make a difference! 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. Primarily supporting our Professional Relations team, you will also partner with Sales and other areas of the organization to provide insights that support operational, quality, contractual, and business objectives.Learn why Karmin enjoys working for Delta Dental of Iowa.Why Delta Dental of Iowa? For your smile. For your health. For your community.At Delta Dental of Iowa, we're more than just a dental and vision insurance company. Improving health and wellness is at the center of everything we do. As a not-for-profit, we aim to build stronger communities by investing in actions that promote and improve health. Delta Dental of Iowa invests 40% of our dollars directly back into the communities we serve.Come see why we are passionate about "Bringing Smiles" to our customers. Our team enjoys competitive pay and benefits, an awesome "One Team" approach, and a company culture that fosters "Exceptional Quality Service" and "Leadership at All Levels." Together, we can make a difference – not only in Iowa but across the country.Essential Functions and Principal Accountabilities:Develop a comprehensive understanding of business areas supported by role.Collaboratively work with internal stakeholders to identify informatics, reporting requirements, and desired outcomes measurement.Develop, analyze and distribute, and manage reporting and analysis related to requested deliverables, including ad hoc data requests.Generate and analyze reports to identify statistical aberrant treatment profiles; evaluate targeted claims for utilization review, appropriateness, and adherence to national processing policies; work with appropriate staff to educate dentists and dental office staff to appropriate treatment reporting and compliance to 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 operationsPerform deep dive analysis to effectively translate broad data sets into performance insight; 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.Utilize SQL, Power BI, Network360, geoaccess mapping, and other tools to mine database(s) for analytic data.Advise on data policies and data process best practice standards.Be 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 any required follow-up activities including corrective action plans.Effectively and clearly communicate results to stakeholders.Perform other duties as assigned.RequirementsRequired:Bachelor's Degree in Data Analytics, Business, Finance, Mathematics, or related field.Three to five years of relevant work experience.Must possess superior math and impact analysis skills.Self-motivated and able to work with a high degree of autonomy.Ability to work as an analytical, problem solver who can make high-quality judgments and decisions quickly with excellent organization skills to work across functions, with internal leadership, and external customers.Ability to interpret and develop data reporting and monitoring requirements.Experience using critical thinking skills working with results, metrics and data management and desire to create and build new processes.Strong collaboration skills and the ability to work effectively on project teams, as well as independently.Excellent verbal, written, and communication skills working with all levels of employees, including Leadership.High level of 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.Preferred:Experience in health, financial, or operational data analysis.Experience in Insurance or dental.Delta Dental of Iowa is an Equal Opportunity Employer that does not discriminate on the basis of race, sex, national origin, religion, age, disability and any other characteristic protected by applicable law. It is also the policy of Delta Dental of Iowa to take affirmative action to employ and to advance in employment, all persons regardless of their status as individuals with disabilities or protected veterans, and to base all employment decisions only on valid job requirements.