Job ID: 22-22836 Type: Regular Full-Time System Office 1120 Building
***Hire On Bonus provided for this position***
Remote Position (OR/WA Only)
This is a remote position – incumbents, who reside in Oregon or Washington only. There may be occasional situations that require work to be performed on-site at an assigned Legacy Health location.
All new hires are required to come to a designated Legacy Health office location in Portland, Oregon prior to their start date for a new hire health assessment and to complete new hire paperwork.
Note that our employee health plan coverage is for providers based in the Legacy Health geographic region. To find providers in our network click here. Urgent and emergent coverage is available outside Legacy Health’s geographic region and telehealth is available within Oregon and Washington.
This position may require initial training and orientation to be site-based, before transitioning to the remote schedule.
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.
The Business Intelligence (BI) Developer I works collaboratively with other BI Developers, Application Systems Analysts and business partners to develop detailed specifications (requirements), reporting systems, and BI artifacts that provide accessible information for decision-making. Under direction, the BI Developer I facilitates use of data to solve organizational problems through development of reports, universe, stored procedures, and SQL objects supporting analysis and data visualization. The BI Developer I will provide enterprise-wide business intelligence expertise with emphasis on data design, access, usage, security and quality of information assets. The BI Developer II will work in support of all managers and users requiring data for decision support and in particular with Application Systems Analysts, Clinical Informatics staff, Power Users and other data consumers, to develop requirements.
This roles works on maintenance tasks and smaller scale projects under general supervision, leveraging many of the skills and abilities listed below:
Participate in creation/validation of design specifications for new data and analytics 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 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 artifacts.
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, Power Apps, SQL databases, Azure Data Warehouse).
Support and maintain an accurate and comprehensive inventory of data, data systems, and data storage.
Review peer reports and or data model concepts for validity and compliance
This is an entry level development position. The incumbent may have 0-3 years’ experience developing and implementing enterprise-scale reports and dashboards, including:
Working with users and more senior team members 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
0-3 years’ or classroom 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 in one or more of a range of computing platforms, languages, and applications
MS SQL Server Integration Services and Reporting Services knowledge desirable
Knowledge and understanding of Performance tuning and other technical skills and concepts
Associate’s or bachelor’s degree in sciences (engineering, physics, computer science, math), information systems, statistics or business required. Relevant experience may be substituted for educational requirements.
Interest in and understanding of some of the many 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 analytical, conceptual and problem-solving abilities and critical thinking
Flexibility, managing multiple priorities, assessing and adjusting quickly to changing environment
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, able to clearly and accurately communicate complex and/or technical information to both technical and nontechnical audiences
Self-motivated; able to work within a high-volume project based environment, and continue to learn on their own
Developing TSQL scripting abilities and understanding of basic stored procedures, views, data aggregation/manipulation through table joins/queries, database design, normalization and de-normalization techniques (Can read code and model it, if not yet able to develop efficient code from scratch)
Preferred, but not required:
Knowledge of data extraction and manipulation, ETL techniques
Exposure to both agile and waterfall development methods, and willingness to work in either
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 developmen
LEGACY’S VALUES IN ACTION
Follow guidelines set forth in Legacy’s Values in Action.