Senior Specialist, Business Intelligence & Analytics

This position is responsible for technical support of inbound and outbound eligibility feeds, dashboard development, automation efforts, and custom report generation in support of internal and external customer needs.  Also provides advanced technical product support for Employer Population Health applications working closely with internal and external customers. This position is also responsible for gathering business requirements for inbound analytics requests, designing, and developing solutions using Tableau and/or Alteryx, and presenting output to leadership. This position does not directly supervise others but is responsible for driving results across cross functional teams and coaching junior developers on best use of models and processes.

This is a remote opportunity however the incumbent must reside in a commutable distance to one of our Major labs in Kansas (Lenexa Lab), Missouri (St Louis Lab), Colorado (Denver Lab), Ohio (Cincinnati Lab), Indiana (Indianapolis Lab), Illinois (Wood Dale Lab, Schaumburg Lab)

No Sponsorship available. 

Pay Range: $80,000 - $100,000/ year, 5% Bonus

Salary offers are based on a wide range of factors including relevant skills, training, experience, education, and, where applicable, certifications obtained. Market and organizational factors are also considered. Successful candidates may be eligible to receive annual performance bonus compensation.

Benefits Information:

We are proud to offer best-in-class benefits and programs to support employees and their families in living healthy, happy lives. Our pay and benefit plans have been designed to promote employee health in all respects – physical, financial, and developmental. Depending on whether it is a part-time or full-time position, some of the benefits offered may include:

· Medical/Prescription Drugs

· Dental

· Vision

· Flexible Spending Accounts (FSAs)

· Supplemental Health Plans

· 401(k) Plan – Company match dollar-for-dollar up to 5%

· Employee Stock Purchase Plan (ESPP)

· Supplemental Life Insurance

· Dependent Life Insurance

· Short- and Long-Term Disability buy-up

· Blueprint for Wellness

· Emotional Well-Being Resources

· Educational Assistance

· Paid time off / Health Time

• Independently leads gathering and evaluating business requirements for incoming business analytics requests and provide efficient and effective solutions.
• Leads design, development, deployment and support of custom data solutions for high impact, high visibility products, processes and customers—including but not limited to APIs, interfaces, and linked servers. 
• Leads design, development, deployment and support of sustainable/automated BI, reporting and analytics solutions such as dashboards, scorecards, workflows and various other forms of data visualization and delivery. 
• Designs, develops, deploys and supports measure algorithms in the form of complex SQL scripts and database queries. 
• Collaborates strongly with Product and IT teams to ensure product and platform design integrates successfully with BI solutions. 
• Proactively anticipates internal/external customer needs and uses customer insight to drive and guide the development of new solutions and offerings. 
• Serves as a strategic partner to build, grow and maintain effective relationships with data partners.  
• Maintains proactive communication and transparency with key internal and external stakeholders to provide status of projects.
• Provides support, guidance and collaboration with Application Developers to implement database and workflow design, and review developer’s work to ensure correct implementation. 
• Upgrade and improve data and application schema, preparing design documents and functional specifications. 
• Build solutions to drive scalable solutions that leverage data warehousing, dimensional modelling and design, Analytics, Dashboarding, Key performance Indicators (KPIs), Data Quality, Data Management and Data governance best practices.

Required Work Experience: 

• 5+ years recent progressive Data science related experience including Data Analytics, Dashboarding, Data Profiling and Data Management.
• 5+ years recent progressive Python experience in intelligent automation, web app development, scripting, desktop application development.
• 2+ years of any Intelligent Automation platform like Power Automate, UiPath/gen AI, etc.
• 2+ years strong demonstrated business intelligence experience including dashboarding in Tableau/Power BI/Looker for dashboard creation and visual data storytelling, data visualization – creating dashboard and giving insights from the data.
• Demonstrated proficiency in SQL and ETL processes
• Proficient in Excel

Preferred Work Experience: 

• 2+ years' experience in project management or continuous improvement methodologies.

Skills: 

• Advanced Excel User
• Advanced data analysis skills
• Proficient in Tableau & SQL
• Advanced knowledge of Alteryx
• Demonstrated ability to apply statistical analysis tools to drive improvement and demonstrate ROI
• Demonstrated understanding and experience in continuous improvement, process management, or system thinking
• Problem-solving skills: uses a systematic, disciplined and data-driven approach that identifies the root causes of various issues and designs solutions to resolve them.
• Effective written and verbal communication skills
• Project Management

Education

• Bachelor’s Degree Bachelor's degree in IT, Technology, Data Science, Data Analytics (Required)
• Master’s Degree (Preferred)