Business Intelligence Analyst Iii

GENERAL SUMMARY

The Business Intelligence Analyst III (Analyst III) provides data-driven guidance and recommendations to leadership to optimize and improve processes in ways that support the goals and mission of the organization. The Analyst III ensures a robust data environment is available to departmental stakeholders and within the Process Improvement &Analytics (PI&A) team for reporting and analysis. The Analyst III is proactive in using data to interpret and measure performance to drive direction, develop strategy, and set goals for the organization.

ESSENTIAL JOB FUNCTIONS

General Responsibilities

• Collaborate with and advise Senior Leadership on the development of the organization’s goals, key metrics, and performance indicators.

• Acts as a leader of analytics function to drive the development of data infrastructure and culture at LifeCenter.

• Defines success metrics through strong partnership with leadership.

• Delivers applied analytics within the Business Intelligence infrastructure, utilizing SQL, DAX, M, Python, and other skills to query, manipulate, and analyze data.

• Designs and oversees development of enterprise and departmental Business Intelligence, data warehousing and reporting solutions using existing tools – SQL Server, Power BI, Azure services, Power Apps, Power Automate.

• Identifies, evaluates, and implements new technology platforms into the environment, creating the relevant business case analysis (BCA) as needed.

• Manipulates data and design of ad hoc reporting and creation of interactive standardized reporting / dashboards using multiple data sources.

• Ensures accuracy of reported data/information.

• Identifies and drives process improvement opportunities through data analysis.

• Drives adoption and utilization of reporting tools through technical training and data literacy.

• Mentors cross-departmental analysts and PI&A team members who may benefit from working within the BI environment.

• Collaborates with the Data Architect & Engineer in the creation and maintenance of Data Standards, Best Practices, Data Modeling, Management & Governance (including Data Quality & Metadata) and Data Security (including PII).

Supervisory Responsibilities

• This position does not have formal supervisory responsibility. The position does serve as an advisor and consultant for the organization and coach and mentor for other positions within the department.

Other Responsibilities

• Performs other related duties as required by the needs of the company and the leadership team.

• Participates in, and may lead, employee committees and events.

• Complies with applicable laws, regulations, and LifeCenter policies and procedures.

KNOWLEDGE, SKILLS, ABILITIES

• Expertise utilizing Microsoft ETL/data integration tools.

• Strong experience working with data warehousing and dimensional modeling concepts, terminology, and architecture.

• Strong experience designing and developing complex SSAS Tabular/Power BI data models.

• Demonstrate SQL skills with extensive experience in developing stored procedures, views, functions, triggers, and advanced logical methods.

• Ability to make complex ideas understandable.

• Strong skills in Microsoft Excel and/or Excel services, SharePoint, expertise in SQL servers.

• Troubleshoot and rectify any production environment related issues.

• Work closely with customers to deliver effective global BI architecture in a timely manner.

• Must be highly professional and able to interact with all levels of management.

• Must possess initiative and a desire for continuous improvement.

• Must be able to perform analysis and create deliverables from general direction.

• Must be able to work effectively with others, some in remote locations.

• Must be highly organized and analytical.

• Must be able to present the results of analysis in a clear and concise format, with a focus on actionable insight.

BEHAVIORAL REQUIREMENTS

The employee in this position must uphold the core values of LifeCenter; these include:

• Integrity: We are trustworthy, reliable, respectful, and accountable.

• Collaboration: We work in partnership with others, seeking to understand and be understood, and finding common ground and shared goals to build upon together.

• Courage: We take personal responsibility and face challenges head-on.

• Service: Through professionalism and dedication, we honor our commitment to serve others and our obligation to be good stewards of the gift of life.

Physical Activities/Requirements

• Must have the ability to operate phones, computers, and other office equipment.

• The individual must have the ability to communicate clearly using the English language, to accurately convey and receive information person and over the phone.

• Specific vision abilities required by this position include close vision and the ability to adjust focus.

• Generally, working conditions do not require exposure to hazardous materials nor extremes in health and safety hazards. Work is performed in an office setting.

ANTICIPATED WEEKLY TIME COMMITMENT

This position may require work outside of regular business hours, including evenings and weekends, sometimes without advance notice.

EDUCATION, EXPERIENCE & JOB REQUIREMENTS

• Bachelor’s degree in Computer Science or a related field is preferred

• Relevant work experience can be considered and substituted for academic requirements

• At least 5 years related work experience with developing technical BI data solutions, preferably with Microsoft tools (PowerBI, SQL, SSAS, SSRS)

• Demonstrated experience in critical thinking, influencing and strategic problem solving.

LifeCenter Northwest offers medical, dental, vision, basic life insurance, accidental death & dismemberment insurance, long-term disability insurance, and travel accident insurance. Employees have the option of enrolling in the following supplemental or voluntary plans: life insurance, short-term disability, accident insurance, hospital indemnity, critical illness coverage and pet insurance. Employees enrolled in our 403(b) program will receive an employer match of up to 7% after one year, employees are auto enrolled at 3% and may change their enrollment at any time. LifeCenter encourages all employees to find balance and well-being and provides all employees access to an Employee Assistance Program (EAP) and provides a quarterly Wellness Reimbursement. Employees enjoy paid holidays throughout the calendar year and earn 119 hours of PTO annually (to start) as well as Health Time Off hours that is earned 1 hour per 30 worked, paid living donor leave, two weeks paid jury duty leave after 6 months of service, and three weeks of paid parental leave after one year of service is complete. A comprehensive review of benefits can be found at https://lcnw.org/about/employment-opportunities/.

LifeCenter Northwest is proud to be an Equal Opportunity Employer.