Business Intelligence Analyst

Delta Dental of WI • Stevens Point, WI

1d

About The Position

At Delta Dental of Wisconsin, we are champions of Oral Health, and we have built our company on a foundation of delivering innovative products and services within our culture of legendary service. Our culture that sets us apart within our industry and the way we do business and it is different. Our employees stay here because the organization supports them as employees and their career growth. We have many employees who have stayed for 25, 30, or even 45 years within our organization. Delta Dental of Wisconsin is seeking full-time Business Intelligence Analysts to support our data strategy through in-depth data analysis, advanced analytics, and dynamic dashboarding. In this role, you will leverage your understanding of our business model, data structure, and data sources—while utilizing modern data and visualization tools such as Power BI, Snowflake, Sigma, Tableau, and SQL Server Management Studio—to empower data-informed decision-making and provide on-demand access to critical insights

Responsibilities

• Understand the various data sources available for analysis and ability to identify the source or sources of data best suited for each situation
• Understand the data in each data source and the opportunities and limitations of using the data from each source
• Work with team members to provide requirements and user acceptance testing for new data tables/data needs to support reporting, analysis, and analytics
• Train team members on techniques to query data to support building reports, models, and dashboards
• Provide analysis at the following life stages of the analytics maturity model: Descriptive, Diagnostic, Predictive, and Prescriptive Analytics of products and related factors, including, but not limited to, claims experience, profit margins, administrative expenses, rate adequacy, sales, terms, provider reimbursements, network value, experience studies, and competitive positioning
• Ensure consistency, accuracy, usability, and scalability of all analytical solutions; ensure applicable branding and formatting standards are followed
• Collaborate with other DDWI teams on data analytics needs and work with these teams to define the purpose and scope of analysis, perform the analysis, and communicate the results
• Support the data needs/analysis related to the strategic planning process
• Conduct analysis of various business relationships and partnerships including analysis of key experience
• Analyze historical trends including, but not limited to, claim utilization and intensity, fee inflation, premium and enrollment by product, segment, and employer contribution.
• Develop solutions to streamline data analysis to support departmental and company-wide data needs more effectively and efficiently
• Identify and analyze the internal and external factors which affect statistics for use in data analysis, forecasting, trending, reporting/dash-boarding, etc.
• Keep informed about analytical tools/concepts available to support necessary analytics and understand the application/relevancy to Delta Dental’s business This includes, but is not limited to, use of complex/big data, cloud database software, analytical tools, etc.
• Keep informed about market conditions, competitive information, and political factors that may impact the goals and interests of the organization.
• Communicate key developments to appropriate stakeholders and use information appropriately when performing analysis or collaborating on internal and external projects.

Benefits

• Health, vision, dental, and life insurance
• Short- and long-term disability coverage
• HSA, FSA, and Dependent Care Accounts
• Competitive salary and incentive compensation based on company results
• 401(k) with employer match and a 6.5% employer contribution to retirement accounts
• Robust wellness programs, whether you work on-site or remotely
• We also value work-life balance with a generous PTO package that grows with your tenure, company holidays, and time off for volunteering.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Education Level: No Education Listed