Business Intelligence Analyst II

Portland, OR 97239

Posted: 02/12/2019 Industry: Computer Science Job Number: 201035 Pay Rate: $109.00
A major teaching hospital located in downtown Portland, OR is seeking a Business Intelligence Analyst.

This position is part of Business Intelligence & Advanced Analytics (BIAA) and is responsible for developing and implementing a variety of business intelligence solutions for reporting and accessing healthcare information. The scope of work is focused on migrating client analytics and reporting assets from a legacy BI infrastructure including Oracle, PLSQL, IBM Datastage, and IBM Cognos to a new healthcare analytics stack largely focused in Epic Cogito Analytics, SQL Server, and SAP BusinessObjects.

Requirements:

Required experience developing in the SAP Business Objects environment, including hands-on experience developing BOBJ Universes, Crystal Reports, and Web Reports.

Developing analytics solutions against the Microsoft SQL Server 2016 analytics stack, including hands-on experience with Microsoft Transact-SQL queries, stored procedures, and SQL Server Integration Services (SSIS).

-Bachelor’ s degree in computer science, a related field, or a clinical field and six years work related experience in the information technology (6 years) OR Associate’ s degree in computer science, a related field, or a clinical field and seven years work related experience in information technology(7 years), OR Eight years of work-related experience in the information technology field, OR Equivalent combination of education and experience.

-3 years of experience applying advanced MS SQL server knowledge in the use of SSIS, T SQL and database object definition

-3 years designing, developing, implementing and optimizing Oracle PL/SQL solutions.

-3 years supporting and maintaining a Data Warehouse and associated ETL in a MS SQL Server database.

-Knowledge of data warehousing architecture. Ability to read, write and maintain T SQL, define and maintain, MS SQL Server database objects

-Demonstrate Core Competencies as established for your position (Leading Self, Leading Others, Leading Leaders, Leading Function)

-Experience working as an MS SQL Server Data Base Administrator.

-Demonstrate Core Competencies as established for your position (Leading Self, Leading Others, Leading Leaders, Leading Function)

Preferred experience
Developing in the Epic Cogito Analytics environment, including hands-on experience developing: Reporting Workbench Reports, Epic to Crystal Reports, Radar Dashboards, CER rules, Analytic Registries, and SlicerDicer solutions.

The ideal candidate will also possess a good understanding of healthcare terminology and experience with the Epic Caboodle Data Warehouse and Epic Clarity Data model.

-Experience working as an MS SQL Server Data Base Administrator.

-2 years in a data warehouse environment utilizing Epic Healthcare Data and Research Data.

-Proficiency working with Apache Hadoop based open-source tools such as Hive, Spark, HBase

-Experience in a research or academic health care environment.

-Experience with HIPAA and PHI compliance.

-MS SQL Server Developer Certification

Pay
109.00/HR (Negotiable based on experience)

Schedule: Mon - Fri, 8AM - 5PM

Position
Details:
This position will work closely with clinical customers, IT staff and project managers to obtain and clarify requirements, develop, validate, test, and deploy analytics and reporting solutions. Solution development shall follow the client software development methodology and adhere to data governance, data security, change management, and report standards.

The Incumbent will observe due care, objectivity and respect for confidentiality. All employees must keep confidential what they hear and what they see when handling, reviewing, or observing: communications and records thereof (calls, email, pages, fax, etc.), data transmission, databases, or other forms of information. Confidentiality extends to the identities of the parties of the communications, and even to the fact that the communication took place. When sharing information, consider whether the recipient has a true “ business need to know.” ITG employees are responsible for the security of client technology. In exercising their duties, ITG employees must follow security directives, incorporating security measures in the delivery of their everyday tasks, and are required to report security concerns to the client's Integrity Office and/or ITG Security Engineering team.

The mission of the Information Technology Group (ITG) is to provide and support technology and information services that enable our client to be a national leader in health and science innovation. The work of the Business Intelligence & Advanced Analytics (BIAA) ensures that the informational assets of the enterprise are leveraged to enhance financial, clinical, operational, and research decision-making.


This position, as part of Business Intelligence & Advanced Analytics (BIAA), is responsible for developing and implementing a variety of business intelligence solutions for reporting on and accessing clinical healthcare information. The scope of work is focused on migrating Clinical Analytics and Reporting assets from a legacy BI infrastructure including Oracle, PLSQL, DataStage, and Cognos; to an analytics stack largely focused in Epic Cogito Analytics, SAP Business Objects, and MS SQL Server.

Required experience developing in the SAP Business Objects environment, including hand on experience developing: BOBJ Universes, Crystal Reports, and Webi Reports.

Required experience developing in Microsoft SQL Management Studio, including the development of T-SQL queries, Stored Procedures, and Views. Experience should include calling stored procedures from Crystal reports and passing parameters from report to procedure.

The ideal candidate will also possess a good understanding of healthcare terminology and experience with the Epic Caboodle Data Warehouse and Epic Clarity Data model.

This position will work closely with clinical customers, IT staff, and project managers to obtain clarify requirements, develop, validate, test, and deploy analytics and reporting solutions. Solution development will follow the software development methodology and adhere to data governance, data security, change management, and report standards.

The Incumbent will observe due care, objectivity and respect for confidentiality. All employees must keep confidential what they hear and what they see when handling, reviewing, or observing: communications and records thereof (calls, email, pages, fax, etc.), data transmission, databases, or other forms of information. Confidentiality extends to the identities of the parties of the communications, and even to the fact that the communication took place. When sharing information, consider whether the recipient has a true “ business need to know.” ITG employees are responsible for the security of technology. In exercising their duties, ITG employees must follow client security directives, incorporating security measures in the delivery of their everyday tasks, and are required to report security concerns to the client's Integrity Office and/or ITG Security Engineering team.

Who is Abbott & Associates Professional Placement?

We are a family-owned and operated staffing agency working in the Oregon and SW Washington market since 2002. We are a Woman Business Enterprise and Emerging Small Business certified company, also accredited by the Better Business Bureau.

Abbott & Associates has recently been recognized as a Finalist for the Excellence in Family Business awards by the Austin Family Business program at Oregon State University.

Why you should work with us:

Work with a small, locally-owned staffing agency that takes a personally tailored approach to every match they make. Helping people is our greatest passion and what drives us every day. With Abbott & Associates, you won't just feel like a number, you will feel like family!

Visit our website to learn more about us or simply do a quick google search to read the wonderful things people have said about working with us!
www.Abbott-associates.Com
Apply Online

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.