- Data modeling
- SQL
- SSIS
- Communication skills
- Agile
Overview:
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.
Responsibilities:
The Business Intelligences (BI) Developer II works collaboratively with Application Systems Analysts and business partners to develop detailed specifications (requirements), reporting systems, and BI artifacts that provide accessible information for decision-making. Under general direction, the BI Developer II 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 II 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.
Using their skills and experience as a BI Report Developer II, they will then leverage those requirements to design, develop, test and implement universes and reports and collaborate on dashboards that utilize the underlying data store(s)/ data warehouse(s) / data mart(s).
Qualifications:
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.
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
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