Business Intelligence Analyst

Delta Dental of Wisconsin • Town of Hull, WI

24d • Hybrid

About The Position

Delta Dental of Wisconsin is seeking a Business Intelligence Analyst to support their data strategy through in-depth data analysis, advanced analytics, and dynamic dashboarding. This full-time hybrid position is located at their corporate headquarters in Stevens Point. In this role, the analyst will leverage their understanding of the 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.

Requirements

• Leverage understanding of our business model, data structure, and data sources
• Utilize modern data and visualization tools such as Power BI, Snowflake, Sigma, Tableau, and SQL Server Management Studio

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
• Generous PTO package that grows with your tenure
• Company holidays
• Time off for volunteering

What This Job Offers

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