Business Intelligence Engineer – Group

Become a part of our caring community and help us put health first

The Business Intelligence Engineer 2 for Group Benefits solves complex business problems and issues using data from internal and external sources to provide insight to decision‑makers. The Business Intelligence Engineer 2 work assignments are varied and frequently require interpretation and independent determination of the appropriate courses of action.

The Business Intelligence Engineer 2 for Group Benefits utilizes tools, technologies, applications and best practices to collect, integrate, analyze and present an organization’s raw data into insightful and actionable business information. The Business Intelligence Engineer 2 should understand how to navigate and interpret databases, be able to create and understand dataflows and data models within business intelligence tools and have the ability to troubleshoot and support existing BI solutions.

They understand department, segment and organizational strategy and operating objectives, including their linkages to related areas. They make decisions regarding their own work methods, occasionally in ambiguous situations, and require minimal direction and receive guidance where needed. They follow established guidelines/procedures.

• Develop and maintain sales and retention reporting systems (standard & Ad‑Hoc reporting) using business intelligence tools such as Power BI, SQL, Excel, or similar platforms.
• Collaborate with stakeholders/business leads on requirements and understand business needs for sales and retention analytics.
• Design and implement data models, ETL processes and data pipelines to extract, transform and load data from various sources.
• Create interactive dashboards, visualizations and reports to present insights and key performance indicators related to sales and customer retention.
• Takes complex data and makes it more accessible, understandable and usable for leaders to derive insights and enable them to make better business decisions.
• Perform ad‑hoc analysis to identify trends, patterns and opportunities for improvement in sales performance and customer retention.
• Monitor data quality, integrity and accuracy to ensure reliable reporting and analysis.
• Stay updated on industry trends, best practices and emerging technologies in business intelligence and data analytics.

• Bachelor’s Degree or equivalent work experience
• 1‑5 years of technical experience in data analysis
• Comprehensive knowledge of Microsoft Office applications including Word, Excel, Access and Power Point
• Expertise in assessing complex data sets and performing root cause analysis
• Strong understanding of relational database systems, SQL languages and data structures
• Experience in building Power BI, Power Query and DAX solutions
• Experience in building self‑service solutions using Paginated Power BI or SSRS
• 1 or more years of experience in SQL, SAS or other data systems
• Experience working with big and complex data sets within large organizations
• Strong analytical and problem‑solving skills

• Advanced Degree in a quantitative discipline, such as Mathematics, Economics, Finance, Statistics, Computer Science, Engineering or related field
• In‑depth experience in Microsoft Excel including formulas, pivots, charts, graphs, etc.
• Experience with data mining and predictive modeling techniques
• Ability to use data to drive business outcomes and decisions
• Experience working with Group Benefits related data

Key

Competencies:

• Independently interprets information; identifies challenges and formulates solutions.
• Ability to handle multiple tasks and deadlines with attention to detail.
• Capable of independently managing business relationships and building trust.
• Learn quickly through self‑study via communication and collaboration with other associates.
• Ability to communicate clearly & concisely.
• Must be passionate about contributing to an organization focused on continuously improving consumer experiences.

At minimum, a download speed of 25 Mbps and an upload speed of 10 Mbps is recommended; wireless, wired cable or…