What are the responsibilities and job description for the Business Intelligence Analyst III position at LifeCenter Northwest?
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
The employee in this position must uphold the core values of LifeCenter; these include:
Because of the nature of this position, the incumbent may need to work outside of regular business hours, including evenings and weekends, sometimes without advance notice.
Education, Experience & Job Requirements
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/.
The pay range for this role is provided above. Where a candidate’s compensation falls within this range is based on several bona fide factors such as experience, tenure, and other specialized knowledge. LifeCenter Northwest is committed to providing its employees equitable and competitive compensation.
LifeCenter Northwest is proud to be an Equal Opportunity Employer.
Essential Job Functions
General Responsibilities
- Collaborates with and advises 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).
- This position has no formal supervisory responsibilities.
- Participates in, and may lead, employee committees and events.
- Complies with applicable laws, regulations, and LifeCenter policies and procedures.
- Expertise utilizing Microsoft ETL/data integration tools.
- Demonstrated experience working with data warehousing and dimensional modeling concepts, terminology, and architecture.
- Demonstrated experience designing and developing complex SSAS Tabular/Power BI data models.
- Demonstrated SQL skills with extensive experience in developing stored procedures, views, functions, triggers, and advanced logical methods.
- Ability to make complex ideas understandable.
- Demonstrated skills in Microsoft Excel and/or Excel services, SharePoint, expertise in SQL servers.
- Ability to troubleshoot and rectify any production environment related issues.
- Ability to work closely with customers to deliver effective global BI architecture in a timely manner.
- Ability to interact professionally with all levels of management.
- Must possess initiative and a desire for continuous improvement.
- Ability to perform analysis and create deliverables from general direction.
- Ability to work effectively with others, some in remote locations.
- Demonstrated organizational and analytical skills.
- Ability to present the results of analysis in a clear and concise format, with a focus on actionable insight.
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.
- 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.
Because of the nature of this position, the incumbent may need to 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 (Power BI, SQL, SSAS, SSRS)
- Demonstrated experience in critical thinking, influencing and strategic problem solving.
- Proof of COVID-19 vaccination, or applicable medical or religious exemption, will be required as a condition of employment upon offer.
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/.
The pay range for this role is provided above. Where a candidate’s compensation falls within this range is based on several bona fide factors such as experience, tenure, and other specialized knowledge. LifeCenter Northwest is committed to providing its employees equitable and competitive compensation.
LifeCenter Northwest is proud to be an Equal Opportunity Employer.