Actuarial Data Analyst
Number of Positions:
1
Location:
Okemos, MI
Location Specifics:
Hybrid Position
Job Summary:
At Delta Dental of Michigan, Ohio, and Indiana we work to improve oral health through benefit plans, advocacy and community support, and we amplify this mission by investing in initiatives that build healthy, smart, vibrant communities. We are one of the largest dental plan administrators in the country, and are part of the Delta Dental Plans Association, which operates two of the largest dental networks in the nation.
At Delta Dental, we celebrate our All In culture. It's a mindset, feeling and attitude we wrap around all that we do - from taking charge of our careers, to helping colleagues and lending a hand in the community.
Position Description
Develops, maintains, and troubleshoots data-driven projects to support the Actuarial and Underwriting teams. Data responsibilities include but are not limited to; forecasting and financial tracking, triangle lag reports, rating formulas, sales requests, ad hoc reporting, and data governance.
Primary Job Responsibilities:
- Improves, maintains, and troubleshoots existing programs that support core Actuarial functions, including, claims lag data, rating formula and factor management, profitability reporting, sales requests, and company and industry survey responses
- Extracts, develops, and maintains data from databases by creating new or altering existing SQL scripts and queries.
- Creates new reports that will provide timely, accurate, and relevant data to various business units; supporting and improving decision making across the company.
- Develops and presents robust ad-hoc reports, data models, and deep dive analysis to provide clear observations so that managers can make more informed decisions.
- Ensures efficient and accurate upload and maintenance of rates for individual products.
- Collaborates with the Finance department to align and improve the company's financial reporting suite and cadence to ensure necessary reporting is available and appropriate conclusions can be drawn.
- Collaborates with the company's central data area to provide accurate and meaningful data to essential stakeholders and ensure data needs are being met efficiently to advance data-related company initiatives.
- Monitors and implements emerging artificial intelligence technology as appropriate to improve department efficiencies and capabilities.
Perform other related assigned duties as necessary to complete the Primary Job Responsibilities as described above.
#LI-Hybrid
Minimum Requirements:
Position requires a bachelor's degree in mathematics, statistics, actuarial science, computer science, information systems, or a related field and three years of experience working with both structured and unstructured data sets and/or performing data analysis in a business setting. Experience in the dental insurance industry, consulting and/or supporting product/service development preferred. Will accept any suitable combination of education, training, or experience.
Position requires experience with Oracle-based systems and using PL/SQL, SAS and/or other querying languages to create and analyze data sets; experience with Python, R, Power BI, and Tableau preferred; the ability to work efficiently with both structured and unstructured data sources, including identification of trends or patterns; ability to translate business needs to more technically oriented teammates and convey more technical information in business-friendly terms to non-technical stakeholders; ability to convey written and oral summaries of data analysis to clients, team members, and business leaders; ability to lead end-to-end data analysis projects; strong working knowledge of Microsoft Excel; ability to analyze and resolve complex problems, use independent judgment and communicate effectively with internal and external contacts as necessary.
The company will provide equal employment and advancement opportunity within the context of its unique business environment without regard to race, color, religion, gender, gender identity, gender expression, age, national origin, familial status, citizenship, genetic information, disability, sex, sexual orientation, marital status, pregnancy, height, weight, military status, or any other status protected under federal, state, or local law or ordinance.