Business Intelligence Engineer

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. Understands department, segment, and organizational strategy and operating objectives, including their linkages to related areas. Makes decisions regarding own work methods, occasionally in ambiguous situations, and requires minimal direction and receives guidance where needed. Follows established guidelines/procedures.

Some of the responsibilities include, but are not limited to:

• 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.

Required Qualifications
Use your skills to make an impact

• 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 PowerPoint
• Expertise in assessing complex data sets and performing root cause analysis
• Possesses a 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

Preferred Qualifications

• 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

Additional Information
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 build 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

Work At Home Requirements
At minimum, a download speed of 25 Mbps and an upload speed of 10 Mbps is recommended; wireless, wired cable or DSL connection is suggested.

• Satellite, cellular and microwave connection can be used only if approved by leadership
• Associates who live and work from Home in the state of California, Illinois, Montana, or South Dakota will be provided a bi-weekly