Legacy Health

Business Intelligence Developer II-Training

Job Location Fremont Building
Position Status Regular Full-Time
Requisition ID
19-10599
City
Portland
State/Province
OR
Department
Informatics Training
Avg Hours Per Week
36
FTE
0.90
Pay Range
USD $37.26/Hr. - USD $55.52/Hr.
FLSA Status
Exempt
Union
Non-union
Work Days
Mon-Fri, occasional weekends
Shift
Day
Shift Length
9
Shift Start Time
0800
Shift End Time
1730

Overview

Every aspect of what we do at Legacy reinforces our commitment to improve the lives of our staff, our patients and our visitors. Information Services is no exception. IS drives so much of what we do, and we look for experts in the field to lead the way. Do you have your finger on the pulse of information systems for business and health care? Can you analyze, build, test, support and maintain systems that will benefit our hospital system and those we serve? If so, we’d like to hear from you.

Responsibilities

This role is matrixed between Clinical Informatics Training Services and Business Intelligence. Primary responsibility is to provide end-user communication, training and support in the implementation and optimal utilization of analytics tools across the BI platforms. Knowledge of and competency in Epic’s Cogito Suite, WebI, and Power BI is preferred, as this role will also perform development activities. This position provides support and coordination of end user training, including conducting classroom-training sessions, developing educational strategies, and creating learning support materials.

 

Responsibilities:

  • Participate in creation/validation of design specifications for new reports or reporting solutions.
  • Identify and review the appropriate technological solution for various reporting needs, communicating design alternatives and recommendations as necessary.
  • Analyze and document application processes and functions, including user documentation.
  • Analyze and revise existing system logic for multiple complex, integrated systems residing on diverse platforms, communicating over both wide-area networks (WANs) and local-area networks (LANs).
  • Create self-service reporting solutions (universes, cubes, views, etc.) using 3rd party applications such as SAP Business Objects.
  • Create and support advanced SQL Objects (stored procedures, functions, DataMarts, OLAP cubes).
  • Develop queries to extract data from a variety of SQL environments, using current data retrieval, management and transfer tools. May also develop queries to add data elements to the data warehouse.
  • Data modelling to produce BI and Data Warehouse solutions.
  • Assist in implementing effective business analytics practices that drive improved decision making, efficiency and performance.
  • Communicate with nontechnical business users to determine specific business requirements for reports and business intelligence solutions.
  • Identify, communicate, and help resolve data quality and data reconciliation issues.
  • Participate in and support all planning and problem resolution around BI projects.
  • Perform independent audits and reviews and validate BI artifacts (stored procedures, queries, reports, universes, etc.) to ensure data integrity.
  • Participate in development of and enforce standards and procedures for the storage and retrieval of institutional data.
  • Work collaboratively with staff and reporting officials to resolve data discrepancies and/or to clarify reporting procedures.
  • Communicate status and completion of work requests to business partners.
  • Provide support for and development in organizational standard third-party tools (e.g., PowerBI, Xcelcius, Webi, Explorer, PowerBI).
  • Support and maintain an accurate and comprehensive inventory of data, data systems, and data storage.
  • Develop test scripts to ensure software accuracy, completion and validity.
  • Review peer reports and or data model concepts for validity and compliance with appropriate team standards.
  • Comply with version control and change management standards.
  • Test report build and perform volume testing in specified testing environments.
  • Review upgrade documentation to determine impact to existing artifacts and determine how to implement the changes.
  • Maintain timely resolution of complex production problems; responsible for user support and work request processing
  • Ensure optimum service to all internal and external partners in response to all requests for service and information.
  • Establish and maintain effective collaborative and cooperative working relationships with all segments of the work environment.
  • Instruct and trains user on application, when needed.
  • Maintain behavior in accordance with established hospital standards.
  • Test report build and perform volume testing in specified testing environments.
  • Review upgrade documentation to determine impact to existing artifacts and determine how to implement the changes.
  • Maintain timely resolution of complex production problems; responsible for user support and work request processing.
  • Ensure optimum service to all internal and external partners in response to all requests for service and information.
  • Establish and maintain effective collaborative and cooperative working relationships with all segments of the work environment.
  • Work toward proficiencies and certifications as directed by team leadership.
  • Instruct and trains user on application, when needed.
  • Maintain behavior in accordance with established hospital standards.

 

Qualifications

Experience:

3+ years’ experience developing and implementing enterprise-scale reports and dashboards, including:

  • Working with users in a requirements analysis role
  • Knowledge of logical and physical data modeling concepts (relational and dimensional) and structured methodologies
  • Data flow diagrams and flowcharting
  • Understanding of data integration concepts (e.g., validation and cleansing), familiarity with complex data and structures

Two (2) to three (3) years’ experience in data mining and analytics or relative database management in systems such as SQL server.

Experience with data warehouse implementations and in business intelligence and data warehouse environments

Demonstrated knowledge of data structures and relationships used in reporting historical trends, current opportunities/problems, and future direction.

Sound knowledge of SQL and data extraction methodologies. Extensive knowledge of and demonstrated expertise in reporting and dashboard programs such as Crystal Reports and Business Objects.

Proficiency and demonstrated experience with BI development tools (e.g., SAP tools such as IDT and WebI).

 

Technically proficient across a range of computing platforms, languages, and applications

MS SQL Server Integration Services and Reporting Services knowledge required

Performance tuning experience related to reporting queries preferred

 

 

Education:

Bachelor's degree in sciences (engineering, physics, computer science, math), information systems, statistics or business required. Relevant experience may be substituted for educational requirements.

 

Skills:

Thorough understanding of current developments and trends in data integration and systems.

Demonstrated ability to do systematic, thorough problem solving and to initiate client problem resolution.

Ability to establish, conceive and describe systems, designs, flow charts, time schedules and network requirements.

Knowledge of enterprise's data and decision-making processes.

Excellent interpersonal skills (including verbal and written communication) to support working in project environments that include internal, external, and customer teams.

Requires strong analytical, conceptual and problem-solving abilities and critical thinking.

Flexibility, managing multiple priorities, assessing and adjusting quickly to changing priorities.

Ability to determine data structures that benefit the entire BI environment, not simply a reporting application.

Demonstrated attention to detail on ensuring the accuracy and efficiency of the data infrastructure and the individual work units.

Demonstrated detailed knowledge of BI areas including ETL design, analytics and reporting.

Possesses strong oral and written communication skills, clearly and accurately communicating complex and/or technical information to both technical and nontechnical audiences.

Self-motivated; able to work within a high-volume project-based environment.

Leadership qualities including ability to mentor junior members of the team.

Strong TSQL scripting abilities and understanding of complex stored procedures, views, data aggregation/manipulation through table joins/queries, database design, normalization and de-normalization techniques.

Demonstrated knowledge of data extraction and manipulation, ETL techniques required.

 

Preferred, but not required:

Comfort using both agile and waterfall development methods preferred

Familiarity with Epic applications and data model/database structure

SSAS development (OLAP and tabular models)

SSIS development for data warehouse ETL processes

Experience with cube development

 

 

LEGACY’S VALUES IN ACTION

Follow guidelines set forth in Legacy’s Values in Action.

 

Equal Opportunity Employer/Vets/Disabled

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Connect With Us!

Not ready to apply? Connect with us for general consideration.