HomeData Science Jobs- USAOregon Health & Science University | Business Intelligence Engineer (Application Engineer) |...

Oregon Health & Science University | Business Intelligence Engineer (Application Engineer) | Portland, OR | United States | BigDataKB.com | 13 Oct 2022

Job Location: Portland, OR

Department Overview:

Positioned at the confluence, where the business of patient care meets the need for insights and data driven decisions, this role provides the opportunity to use data analysis and development skills to improve the health and well-being of Oregonians and beyond.
As part of the OHSU Business Intelligence & Advanced Analytics (BIAA) division, this position is responsible for developing a comprehensive data and analytics toolset for the OHSU Health Critical Care Service Line (CCSL). This includes operational reporting and dashboards, providing data and analysis in support of clinical quality and research initiatives, and related project efforts as prioritized by CCSL leadership.
This person will be responsible for designing, developing, testing, implementing and maintaining data and analytics solutions, including:
  • SAP Business Objects Web Intelligence for department reporting
  • Dashboard and data visualization development in Azure BI Analytics and/or Tableau;
  • ETL development using Epic’s Caboodle Data Warehouse and SQL Server Integration Services (SSIS);
  • SQL data extracts using T-SQL stored procedures and SSIS;
  • Views and stored procedures for reporting using Microsoft SQL Server and the Epic Clarity and Caboodle data models;
This position will be developing primarily in the Epic Caboodle Console, Microsoft SQL Server tools, and BusinessObjects. However, duties may extend to Azure DataFactoty, PowerBI, and additional analytics tools. Azure DevOps will be used for version control, code management, and code deployment. All development will observe the OHSU BIAA data governance policies and SDLC.
Candidates must be able to excel in a collaborative environment, where open and honest communication drives innovation and process improvement. The ideal candidate will seek out opportunities to lead and lift others by offering consulting and providing technical expertise to assist clinical BI end users and fellow team members.

Function/Duties of Position:

Data and System Engineering
  • Contribute to the growth of the OHSU Caboodle Data Warehouse architecture by designing, developing, testing and implementing ETL.
  • Work with BI architects, developers, analysts, and customers to design, create and publish data models, ETL processes, and metadata using the Epic Caboodle Console, as well as third party ETL tools.
  • Provide complete and consistent documentation of data warehouse content in the Caboodle Console to ensure that users can determine what data is available in the warehouse, how this data is defined, and lineage to Epic Clarity.
  • Document assets in the appropriate BI asset library.
  • Develop Epic Clarity and Caboodle data feeds using SSIS, ensuring data feeds have undergone appropriate security review, and are transported abiding by the guidelines of the information privacy and security office, as well as any further security requirements outlined in a business associates’ agreement or data use agreement.
  • Troubleshoot and analyze ETL process failures, data anomalies and other ETL or data warehouse issues identified by automated monitoring, other developers, and end users.
  • Work through established processes to resolve any system or data problems and communicate updates and status to affected groups.
  • Recommend improvements to ETL processes, tool sets, data models, and monitoring techniques to improve existing structures and code to increase reliability and efficiency.
  • Coordinate data integration projects with system architects, DBAs, and vendors.
  • Deploy data warehouse content using approved Azure DevOps systems and processes
Analysis and Reporting
  • Conduct discovery sessions with customers to gather and document detailed requirements that inform the design and development of new or modifications to existing BI solutions.
  • Data Analysis, data profiling and solution design.
  • Develop BusinessObjects BI solutions including scheduled reports, publications and ad hoc assets.
  • Dashboard and data visualization development in Azure BI Analytics and/or Tableau
  • Create and maintain metadata models (e.g., BusinessObjects Universes).
  • Develop key metrics as prioritized by service line leadership
  • Develop roll up dashboards to provide insight into operational metric performance.
  • Provide datasets and advanced analysis.
  • Provide technical expertise to support end users developing ad-hoc queries and departmental reports.
  • Work with customers to improve user interfaces for improved reporting.
  • Works closely with other BIAA staff to meet expectations for design reviews and coding standards.
Production Support & Systems Management
  • Understand and utilize approved System Development Life Cycle (SDLC) systems, processes, and procedures.
  • Respond to and track issues using Jira Service Desk
  • Manage projects by creating timelines, identifying risks and milestones, and provide status reporting to others as defined.
  • Provide support to data warehouse developers, line-of-business analysts, and users to validate data in the data warehouse.
  • Investigate reported incidents and work to ensure the validity of the data warehouse.
  • Schedule and oversee the schedules and publications of report distributions to ensure that data are delivered only to the intended recipients at the intended time.
  • Maintain assets through system upgrades.

Required Qualifications:

Education:
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:
  • Two or more years of paid work experience as a Systems/Application Analyst or Application Administrator.
Job Related Knowledge, Skills and Abilities (Competencies):
  • Successful candidates must have experience and working knowledge in operating system software, relational and/or hierarchical databases, and technical application support for administrative and clinical systems
Also Explore All freshers Data Science Jobs in Bharat & United States below, Or simply scroll down to Continue with this job/post , just hit the + symbol to see the detail & Apply link for the job that suits u... Bharat...
United States...

Preferred Qualifications:

Experience:
  • Minimum of two (2) years of experience as an Application Engineer or Developer (or equivalent classification) developing data warehouse objects and/or data integration solutions.
  • Minimum of three (3) years SQL Server Experience, including SSIS and T-SQL, coding, performance tuning, and system optimization.
  • Minimum of five (5) years with Microsoft SQL Server T-SQL
  • Minimum of five (5) years developing reports and dashboards.
  • Minimum of two (2) years of experience in a data warehouse environment
Job Related Knowledge, Skills and Abilities (Competencies):
  • Knowledge of data warehousing architecture and dimensional modeling concepts.
  • Ability to read, write and maintain SQL code at an advanced skill level.
  • Proven communication, analytical, and problem-solving skills.
  • Ability to manage multiple projects on an ongoing basis with excellent attention to detail.
  • Ability to accurately document system technical artifacts at a level of detail sufficient for ongoing production support.
Registrations, Certifications and/or Licenses:
  • Epic Clarity Data Model Certifications and Epic Caboodle Developer Certification within 6 months of hire.

Additional Details:

Please note: Effective Oct. 18, 2021, all OHSU employees are required to be fully vaccinated against COVID-19 unless they have an approved medical or religious exception. If you are hired by OHSU after Oct. 18, you will need to be fully vaccinated (or obtain an approved exception) prior to starting work, and need to provide proof of vaccination (or approved exception) within 10 days of starting work.

All are welcome: Oregon Health & Science University values a diverse and culturally competent workforce. We are proud of our commitment to being an equal opportunity, affirmative action organization that does not discriminate against applicants on the basis of any protected class status, including disability status and protected veteran status. Individuals with diverse backgrounds and those who promote diversity and a culture of inclusion are encouraged to apply. To request reasonable accommodation contact the Affirmative Action and Equal Opportunity Department at 503-494-5148 or [email protected]

As an organization devoted to the health and well-being of people in Oregon and beyond, OHSU requires its employees to be fully vaccinated against COVID-19.




Apply Here

Submit CV To All Data Science Job Consultants Across United States For Free

Explore Other Similar Data Science Jobs wpDataTable with provided ID not found!
RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

How To Find Best Data Science Course

How To Get Guaranteed Data Science Jobs