Senior Business Intelligence Analyst - Oregon, United States - ClareMedica Health Partners LLC

Description

Job Description: Senior Business Intelligence Analyst

Location: Corporate, Remote Classification: FT-Exempt

Department: Data Analytics Reports to: Sr. Director, Business Intelligence

Position Category: Non-Managerial Last Revised: November 2023

At ClareMedica, exceptional is the standard.

Driven by our purpose to enhance the lives of the seniors in the communities where we have the privilege to work, live, and play, the ClareMedica team is comprised of the brightest and best in their fields of expertise. From clinical excellence to unparalleled administrative support and beyond, we're working together to help seniors live happier, healthier, fuller lives.

That kind of teamwork and passion for excelling can only exist in a workplace that fosters employees' growth and wellness and where their full potential and value are realized. At ClareMedica, we're excited about great people like you. We're even more excited to support you with the resources, training, benefits, competitive compensation, and more to help you thrive and succeed in our communities.

Opportunity awaits – welcome to ClareMedica.

ESSENTIAL FUNCTIONS:

The Senior Business Intelligence (BI) Analyst's primary role is to develop reporting and data analysis solutions. They work closely with internal customers and teams to turn data into critical information and knowledge that can be used to make sound business decisions. BI Analysts educate and train users on how to use the data as an analytical tool, displaying the information in new forms and content for the purpose of analysis and decision support.

BI Analysts scope business requirements, priorities, define key performance indicators (KPI), and develop BI and data warehouse (DW) strategies. This includes working with business and development teams to design and document dashboards, alerts, and reports. This role is accountable for facilitating information gathering, structured documentation and presentation of findings to all levels of management. They conduct analyses of functional business processes and functional business requirements and participate in the development of business cases in the support of process changes and/or IT projects.

DUTIES AND RESPONSIBILITIES:

• Design and create data visualizations, reports and dashboards as required to support operational and clinical areas
• Build datasets that can be utilized by reports and visualizations to support productivity and production key metrics
• Work with users to identify data needs and business metric definitions
• Collaborate with data subject matter experts, technical staff, and users to understand and troubleshoot platform issues and develop appropriate solutions
• Develop and maintain SQL scripts that generate reports based
• Assists in the development of end-user training materials
• Participates in workstream planning process including inception, technical design, development, testing and delivery of BI solutions
• Interprets business requirements and determines optimal BI solutions
• May perform analysis for a wide range of requests using data in different formats and from various platform
• Research business problems and creates models that help analyze these business problems
• Provides input to the development of information quality metrics
• Trains users to transform data into action-oriented information and to use that information correctly
• Directs, organizes, and leads BI workstream projects in the implementation and use of new BI software tools and systems
• Provides subject matter expertise for key BI core functions.
• Conducts analyses of functional business processes and functional requirements and participates in the development of business cases in the support of process changes
• Advises executives on how BI (processes, practices and technologies) plays a critical role in improving business management and optimization
• Explores the data and discovers patterns, meaningful relationships, anomalies and trends
• Develops best practices for report deployments
• Tests results to ensure the BI solution meets the needs of the business

QUALIFICATIONS/REQUIREMENTS

• Bachelor's degree in Computer Science, Mathematics, Business Management or specialized training/certification or equivalent work experience
• 3+ years of report and analysis design and development experience
• Experience querying data directly from a data warehouse
• Proven ability to improve processes, be proactive, and take initiative
• Enthusiastic about data, data visualization, and data science
• Strong analytical, quantitative, problem solving, and organizational skills; attention to detail; and ability to coordinate multiple tasks, set priorities, and meet deadlines
• Strong written and verbal communication skills
• Ability to collaborate with key team members and subject experts
• Intermediate to advanced Excel skills including data manipulation, data cleansing, and data blending.
• 3+ years' experience with Electronic Medical Records systems and/or
• 3+ years' experience with medical economics (claims, utilization, HCC/RAF, HEDIS)
• Tableau or Microsoft PowerBI report design including dashboards, reporting, and front-end visualizations
• SQL Server programming experience (SSMS)
• Familiarity with Population Health applications
• Experience with full life cycle of development in a BI or Analytics environment
• Python and SSIS programming experience is a plus

WORKING CONDITIONS

General office working conditions

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential function.

While performing the duties of this job, the employee will be required to stand; walk; sit; use hands to finger, handle, or feel objects, tools or controls; reach with hands and arms; climb stairs, balance; stoop, kneel, crouch or crawl; talk or hear. The employee must occasionally lift and or move up to 15 pounds. Specific vision abilities required by the job include close vision, distance vision, peripheral vision, depth perception, and the ability to adjust to focus. Manual dexterity is required to use desktop computers and peripherals. Exposure to variable weather conditions is likely.

WORK ENVIRONMENT

Work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of his job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

The noise level in the work environment is usually moderate.

TRAVEL

Travel is primarily local during the business day, although some out-of-area and overnight travel may be expected.

SAFETY HAZARD OF THE JOB

Minimal Hazards

_____________________________________________________________________________________________________________________________________________________________________

This job description does not list all the duties and responsibilities of the job. You may be asked by supervisors or managers to perform other instruction, duties and responsibilities, as appropriate. You will be evaluated in part based upon your performance of the duties and responsibilities identified in this job description.

Management has the right to revise this job description at any time. The job description is not a contract for employment, an either you or the employer may terminate employment any time, with or without cause.

PI9e0870cd8b