OHSU School of Dentistry · 1 day ago
Business Intelligence Analyst (System Application Analyst, Sr)
United States
Full-time
Remote
Mid, Senior Level
$100K/yr - $151K/yr
4+ years expOHSU School of Dentistry is committed to being a national leader in health and science innovation, and they are seeking a Business Intelligence Analyst to support clinical analytics and operational reporting priorities. This role involves developing BI solutions, conducting business analysis, and providing production support to improve decision-making processes within the organization.
Higher Education
Responsibilities
Use business requirements to develop BI solutions, including ad hoc operational and analytical reports, dashboards, scheduled reports
Identifies opportunities for leveraging existing reporting assets to meet business requirements
Works closely with other OHSU IT staff to meet expectations for design reviews and coding standards
Provides issue resolution during Quality Assurance / User testing
Troubleshoot and analyze data processing failures and data issues using Chart review, Record Viewer, Clarity Data dictionary, and Caboodle Data Dictionary
Work through established processes to resolve system or data problems, and communicate updates and status to affected groups
Recommend changes to data models and metadata models to improve existing structures and code to increase performance, reliability, and efficiency
Provides technical expertise to departmental staff and customers to improve user experience
Facilitate the implementation and migration of the solution objects into production
Validating and testing with the customer as frequently as necessary to get sign-off that the solution meets the requirements
Provide training as necessary to the customer of the new report solution
Conduct discovery sessions with end users, front line staff, leadership, analysts, engineers and informaticians to gather and document detailed requirements that inform the design and development of new or modifications to existing BI solutions
Data analysis and profiling of source data to identify source tables, data definitions and business rules
Solution design. Taking into consideration options of tools and report structure/format that best meet the customer requirements, department direction, and policy
Respond to requests from customers to fix issues or apply enhancements to existing production reports
Communication with the customer to get clarification on support needs
Perform high level data analysis and initial sizing of the work to be done
Facilitate and coordinate the solution with other groups, e.g. Workflow, BIAA and other IT groups, as needed
Design, develop and test the solution
Work with the Customer to validate the solution and close the Ticket
Coordinate the migration of the changed report objects
Continually work to improve existing processes and daily work
Identify improvement opportunities for department or system
Facilitate the prioritization of improvement opportunities with organizational leadership
Serve as clinical BI content experts for cross-department projects such as Upgrades or Migration efforts
Mentorship of junior staff on Tools, subject matter and Process
Primary representation for Clinical BI in division level projects; will include impact analysis of Clinical BI stewarded content, the development of a mitigation plan, assignment and/or ownership of project tasks, oversight of project task executions, status reporting to leadership
Leading the creation, maintenance, and improvement of standard work and process documentation. This includes all reference documentation categorized as a responsibility of a BIAA analyst in the BIAA RACI Matrix. This documentation will serve as the knowledgebase for all junior staff
Expert level understanding of BIAA toolset, serving as the go-to technical expert in an ETL or BI application
Mentorship of junior staff for process, clinical subject matter, and department tools
Other duties as assigned
Qualification
Required
Master's degree in computer science, a related field, or a clinical field and four years work related experience in the information technology field or a combination of clinical or operational healthcare environments; OR
Bachelor's degree in computer science, a related field, or a clinical field and six years work related experience in the information technology field or a combination of clinical or operational healthcare environments; OR
Associate's degree in computer science, a related field, or a clinical field and seven years work related experience in the information technology field or a combination of clinical or operational healthcare environments; OR
Eight years work related experience in the information technology field or a combination of clinical or operational healthcare environments; OR
Equivalent combination of education and experience where one year of experience will be substituted for an Associate's degree and two years of experience will be substituted for a Bachelor's degree
Four years paid work experience as BI Developer (or equivalent classification)
Four years working with relational databases
Four years experience with developing semantic layers for data preparation
Experience with facilitating and documenting system requirements sessions
Experience creating technical documentation of reports and data/report models
Experience with utilizing star schema data stores as the basis for report development
Experience planning and managing small projects
Proven communication, analytical, and problem solving skills
Experience with Systems Development Life Cycle (SDLC) processes and procedures
Ability to read and explain a data model
Ability to read, write and maintain SQL Code
Knowledge of data warehousing architecture and dimensional modeling concepts
Exceptional customer service skills - both in person and on the phone
Exceptional interpersonal skills - able to resolve conflicts and to problem solve between parties
Demonstrated evidence of strong written and verbal communication skills
Ability to manage competing priorities
Ability to work independently; willingness to serve as a positive and professional role model
Must have demonstrated record of reliable attendance, punctuality and proven successful performance in past and present
Epic Clarity/Caboodle Certifications within 6 months of hire
Microsoft Power BI Data Analyst Associate Certification within 6 months of hire
Preferred
Four or more years of current experience with Epic applications and/or the Epic Clarity environment
Six or more years of experience with SQL coding and tuning
Experience interpreting execution plans
Epic Clarity Certification
Epic Caboodle Certification
Epic RWB Certification
Epic Radar Certification
Microsoft Power BI Data Analyst Associate Certification
Benefits
Healthcare for full-time employees covered 100% and 88% for dependents.
$50K of term life insurance provided at no cost to the employee.
Two separate above market pension plans to choose from.
Vacation - up to 200 hours per year dependent on length of service.
Sick Leave - up to 96 hours per year.
9 paid holidays per year.
Substantial Tri-Met and C-Tran discounts.
Employee Assistance Program.
Childcare service discounts.
Tuition reimbursement.
Employee discounts to local and major businesses.
Company
OHSU School of Dentistry
The School of Dentistry shares the mission of the Oregon Health & Science University to provide educational programs, basic and clinical research, and high-quality care and community programs.
201-500 employees
H1B Sponsorship
OHSU School of Dentistry has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (1)
2022 (5)
Funding
Current Stage
Growth StageCompany data provided by crunchbase