***Not able to use 3rd Party Agencies***
Business Intelligence Analyst
Our client is seeking a Business Intelligence Analyst to join their team in Portland, OR. The mission of the Information Technology Group (ITG) is to develop, implement and maintain technology-based services and solutions enabling our client to effectively manage information to accomplish its missions. This position partners with the Oregon Clinical and Translational Research Institute (OCTRI) which has the mission to “improve human health by enhancing clinical and translational research” through the Institute’s Biomedical Informatics Program.
This position is responsible for data analysis efforts in support of the Research Data Warehouse (RDW). This includes independently and collaboratively works with OCTRI Research Associates to translate data requirements into specifications. The primary focus is BI solution design, testing and implementation of ETL and Data Warehouse structures using a combination of Epic Clarity, Microsoft SQL Server Integration Services (SSIS), SSMS, T SQL queries, PL/SQL along with SQL Server and Oracle database objects. This person will work with Microsoft SQL Server, T SQL and Oracle PL/SQL to process Research and Clinical data to meet analytic requirements. This position will need to perform scoping and estimating on Data Warehouse activities. Present technical information and design proposals in easily understood terms in both verbal and written form. This position is also responsible for detailed data analysis to assure the availability and accuracy of data processed by the ETL or contained in the Research Data Warehouse.
The selected candidate 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 security directives, incorporating security measures in the delivery of their everyday tasks, and are required to report security concerns to the Integrity Office and/or ITG Security Engineering team.
Responsibilities of the Business Intelligence Analyst
Analyze Epic Data Sources such as Clarity and Caboodle to develop requirements for extracting data.
Leverage Microsoft SSIS, TSQL and related expertise to provide support to data warehouse developers, data analysts, and users in the ETL migration and support of the Research Data Warehouse environment.
Analyze and test Oracle PL/SQL and related database objects in the ETL migration and support of the Research Data Warehouse environment.
Participate in peer code review sessions and offer suggestions that improve performance, maintainability, and best practice compliance.
Apply updates and ensure that data are loaded into the data warehouse according to defined requirements.
Perform necessary QA testing and validation of SSIS processes, TSQL and database objects.
Perform query and process tuning and optimization.
Follow change and version control procedures.
Ensure appropriate security structures and/or policies to data and/or database objects are applied
Make recommendations on best practices for ETL and Data Warehouse design in conjunction with Application Engineers, DBAs and enterprise data architects.
Work with Research Data Analysts to establish test plans that evaluate ETL performance and data quality of deliverables. Assume responsibility for mitigating all issues discovered during the QA process. Provide support to data warehouse developers, line-of-business analysts, and users to validate data in the data warehouse. Investigate and report on problems and work to ensure the validity of the data warehouse.
Collaborate with team members and analysts to validate data in the data warehouse.
Investigate and report on problems and work to ensure the validity of the data warehouse.
This position may perform other duties as directed by ITG and OCTRI management.
Qualifications of the Business Intelligence Analyst
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.
Experience:3 years of experience applying advanced MS SQL server knowledge in the use of SSIS, T SQL and data base 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 such as Views, tables, indexes, stored procedures. Demonstrate Core Competencies as established for your position (Leading Self, Leading Others, Leading Leaders, Leading Function).
MS SQL Server Developer Certification.
MS SQL Server Administrator Certification.
Experience working as an MS SQL Server Data Base Administrator.
Epic Clarity Experience.
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.
Benefits are available to eligible VanderHouwen contractors and include coverage for medical, dental, vision, life insurance, short and long term disability, and matching 401k.
VanderHouwen is an award-winning, Women-Owned, WBENC certified professional staffing firm. Founded in 1987, VanderHouwen has been successfully placing experienced professionals throughout the Pacific Northwest and nationwide. Our recruitment teams are highly specialized in either Technology and IT, Engineering, or Accounting and Finance career markets. Our recruiters value building meaningful, professional relationships with each candidate as well as developing honed knowledge of companies' staffing needs and workplaces. Partner with us to land your next exciting career.
VanderHouwen is an Equal Opportunity Employer and participates in E-Verify. VanderHouwen does not discriminate on the basis of race, color, religion, sex, national origin, age, disability, or any other characteristic protected by applicable local, state or federal civil rights laws.
Not Ready to Apply?