The Business Intelligence (BI) Solutions Analyst is responsible for designing, developing, testing, implementing, and maintaining business intelligence solutions that drive analytical and data driven decision making across the organization. The BI Solutions Analyst collaborates with project teams, internal business partners, data scientists, and enterprise data warehouse experts to understand requirements and scope to recommend and develop the most appropriate business intelligence solution. The BI Solutions Analyst will leverage one or more of the current technologies in developing solutions: Power BI, Power Platform, Cognos Analytics, SQL, SAS EG, SAS Dataflux, R, Python, TIBCO, Databricks.

Essential Responsibilities/Accountabilities:

Level I:

• Develops business intelligence solutions to solve business problems and to improve member health outcomes. This may include, but is not limited to:

o Querying complex data models and data warehouses

o Maintaining and developing business intelligence data models

o Code workflow procedures to improve query performance

o Developing paginated and/ or prompted reports

o Developing data visualizations

o Developing automated workflows, applications, virtual agents

• Leverages best practices and project methodologies, including, but not limited to the Software Development Lifecycle to implement business intelligence solutions. Components may include:

o Designing and developing

o Unit testing and user acceptance testing

o Implementing and maintaining solutions

o Waterfall, Agile, or other methodologies may also apply

• Assists in the development and validation of business requirements to ensure scope and timelines.

• Analyzes data to ensure accuracy of business intelligence solutions.

• Effectively communicate the results of projects to stakeholders.

• Addresses risks on projects before they become system-wide issues.

• Consistently demonstrate the job competency characteristics, adheres to the company code of conduct, embraces the organization’s mission and values including the “Lifetime Way Values”, and consistently demonstrates high standards of integrity.

• Follows the company’s corporate privacy policies and procedures regarding confidential and private data; including, but not limited to member level PHI and PII.

• Regular and reliable attendance is expected and required.

• May perform other functions as assigned by management.

• Consistently demonstrates high standards of integrity by supporting the Lifetime. Healthcare Companies’ mission and values, adhering to the Corporate Code of Conduct, and Leading to the Lifetime Way values and beliefs.

Level II (in addition to Level I essential responsibilities/accountabilities):

• Follows trends in business intelligence and disseminates information accordingly, assists with the continual evolution of the team’s technical competencies and processes.

• Drives the development and validation of business requirements to ensure scope and timelines.

• Responsible for larger assignments crossing lines of business with the ability to present to managers and above.

• Develops and deliver presentations as a technical or subject matter expert (SME).

• Addresses risks on larger projects before they become system issues and provides recommendations for remediation.

Level III (in addition to Level II essential responsibilities/accountabilities):

• Is recognized as an organization’s SME in key analytic capabilities and/or is of strategic importance to the enterprise.

• Leads cross-training efforts of team members on SME capabilities.

• Advises and consults key stakeholders of technical and business directions.

• Interacts regularly with business area partners at director/VP level, presenting recommendations and status updates.

• Leads the reporting and analytics competencies throughout the organization and defines accurate and comprehensive technical documentation for business intelligence solutions.

• Proactively identifies and addresses risks on platforms before they become system issues and provides recommendations for remediation and prevention.

Minimum Qualifications:

NOTE:

We include multiple levels of classification differentiated by demonstrated knowledge, skills, and the ability to manage increasingly independent and/or complex assignments, broader responsibility, additional decision making, and in some cases, becoming a resource to others. In addition to using this differentiated approach to place new hires, it also provides guideposts for employee development and promotional opportunities.

Level I:

• In lieu of a degree six (6) cumulative years of experience required. Bachelor’s degree required.

• Prior professional, internship, or co-op, experience developing reporting or analytical solutions preferred.

• Experience with Business Intelligence tools; preferred tools include, but are not limited to: Cognos Analytics, Power BI, SAS, Tableau.

• Understanding concepts of creating report metrics, attributes, and dimensions.

• Understanding of report and dashboard design, charts and graphs, and data visualization.

• Analytical and problem-solving skills.

• Good communication skills both written and verbal, and across multiple channels of communication (email, chat, phone, documentation, etc.).

• Understanding of collaboration techniques and project management methodologies.

• Flexibility to learn and work with a variety of technologies.

Level II (in addition to Level I minimum qualifications):

• Intermediate experience with Business Intelligence tools; preferred tools include, but are not limited to: Cognos Analytics, Power BI, SAS, R, Python, Databricks, SQL.

• Intermediate experience in data warehousing, database design, and data modeling.

• Intermediate experience in report and dashboard design, charts and graphs, and data visualization.

• Experience in training and documentation.

• Experience in facilitating presentations.

• Experience with software development practices and tools (DevOps, Git, SharePoint).

• Master’s degree preferred.

Level III (in addition to Level II minimum qualifications):

• Extensive experience with Business Intelligence tools; preferred tools include, but are not limited to: Cognos Analytics, Power BI, SAS, R, Python, Databricks, SQL.

• Extensive experience in data warehousing, database design, and data modeling.

• Extensive experience in report and dashboard design, charts and graphs, and data visualization.

• Experience with cloud computing environments (Azure, AWS, Google).

• Extensive experience in training and documentation.

• Experience in presenting to high-level stakeholders.

Physical Requirements

• Ability to complete work in a traditional office environment under fluorescent lighting.

• Ability to orally communicate.

• Must be able to function while sitting at a desk viewing a computer and using a keyboard and mouse for 3 or more hours at a time.

• Must be able to travel across the enterprise.

• Ability to work in a home office for continuous periods of time for business continuity.

The salary range indicated in this posting represents the minimum and maximum of the salary range for this position. Actual salary will vary depending on factors including, but not limited to, budget available, prior experience, knowledge, skill and education as they relate to the position’s minimum qualifications, in additional to internal equity. The posted salary range reflects just one component of our total rewards package. Other components of the total rewards package may include participation in group health and/or dental insurance, retirement plan, wellness program, paid time away from work, and paid holidays.

Level I Min: $62,400.00 - Max: $115,800.00

Level II Min: $70,200.00 - Max: $130,300.00

Level III Min: $78,900.00 - Max: $146,600.00

************

One Mission. One Vision. One I.D.E.A. One you.

Together we can create a better I.D.E.A. for our communities.

At the Lifetime Healthcare Companies, we’re on a mission to make our communities healthier, and we can’t do it without you. We know diversity helps fuel our mission and that’s why we approach our work from an I.D.E.A. mindset (Inclusion, Diversity, Equity, and Access). By activating our employees’ experiences, skills, and perspectives, we take action toward greater health equity.

We aspire to reflect the communities we live in and serve, and strongly encourage people of color, LGBTQ+ people, people with disabilities, veterans, and other underrepresented groups to apply.

OUR COMPANY CULTURE:

Employees are united by our Lifetime Way Values & Behaviors that include compassion, pride, excellence, innovation, and having fun! We aim to be an employer of choice by valuing workforce diversity, innovative thinking, employee development, and by offering competitive compensation and benefits.

In support of the Americans with Disabilities Act, this job description lists only those responsibilities and qualifications deemed essential to the position.

Equal Opportunity Employer

Qualifications

Education

Preferred

Bachelors

Bachelors

Bachelors

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)