Business Intelligence Solutions Analyst

Summary

Job Description:

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 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:
• Querying complex data models and data warehouses
• Maintaining and developing business intelligence data models
• Code workflow procedures to improve query performance
• Developing paginated and/ or prompted reports
• Developing data visualizations
• 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:
• Designing and developing
• Unit testing and user acceptance testing
• Implementing and maintaining solutions
• 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 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 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.
  
  

Note

Minimum Qualifications:

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.

All Levels

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

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

Compensation Range(s)

E4 min 65,346 mid 91,484 max 117,622

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

Please note: There may be opportunity for remote work within all jobs posted by the Excellus Talent Acquisition team. This decision is made on a case-by-case basis.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.