Our pre-employment assessment is changing as of 10/29. If you are applying to newly posted positions, you will need to take the revised assessment.

Job Details

Clinical Analytics Systems Architect

Requisition #: 187341
Location: Johns Hopkins Medicine International, Baltimore, MD 21201
Category: Information Technology
Work Shift: Day Shift
Work Week: Full Time (40 hours)
Weekend Work Required: No
Date Posted: Aug. 8, 2019

Johns Hopkins Health System employs more than 20,000 people annually. Upon joining Johns Hopkins Health System, you become part of a diverse organization dedicated to its patients, their families, and the community we serve, as well as to our employees. Career opportunities are available in academic and community hospital settings, home care services, physician practices, international affiliate locations and in the health insurance industry. If you share in our vision, mission and values and also have exceptional customer service and technical skills, we invite you to join those who are leaders and innovators in the healthcare field.

Employer

Johns Hopkins Health System Corporation

Worksite

1300 Thames Street, Suite 200, Baltimore, MD 21231

Responsibilities

Design, develop, code, test, debug, and implement software for systems to analyze operational and clinical data. Perform sophisticated data analysis to create Microsoft Business Intelligence (BI) reports and Tableau dashboards that will be used to provide meaningful information to support and inform operations, quality, and safety improvement initiatives for Johns Hopkins Health System (JHHS). Distill and articulate a technical and organizational approach to JHHS’s clinical data needs. Recommend and implement information systems to collect data needed for various JHHS reports. Automate Extract, Transform and Load (ETL) code modules for data warehouse, data integration, and business intelligence projects using tools such as Microsoft Business Intelligence (BI) and Informatica PowerCenter tools. Develop operations plans, prepare clinical reports, and create dashboards using enterprise-level reporting packages such as Tableau desktop and SAP Business Objects. Develop dashboards for trending analysis to support business planning, predictive analytics, and volume forecasting. Determine options and best practices for ETL design techniques, such as change data capture, key generation, and optimization and performance tuning. Optimize SQL programming. Tune and improve performance of SQL queries with MS SQL Server database. Design ETL solutions for data migration and data integration. Design and develop data quality and profiling routines for cleansing the data with Informatica tools. Use patient encounter data to run predictive models in order to identify potential risks and opportunities. Provide strategic guidance for automating business processes and architecting data warehouses using industry best practices. Apply knowledge of big data framework and programming in Python for advanced data processing and analytics. Perform other related duties as assigned.

Requirements

Bachelor’s degree (or foreign equivalent) in Information Systems, Information Technology, Computer Science, or a related field, and five (5) years of project management experience, which must include the following:

-Five (5) years of experience in data integration using Extract, Transform and Load (ETL) methods with Microsoft Business Intelligence (BI) and Informatica PowerCenter tools;

-Three (3) years of experience in SQL programming;

-Three (3) years of experience in performance tuning SQL queries with MS SQL Server database;

-Two (2) years of experience using Tableau desktop and SAP Business Objects for predictive analytics, volume forecasting, trending analysis, and creating dashboards; and

-One (1) year of experience with big data framework and programming in Python.

All experience may be concurrent.

In lieu of a Bachelor’s degree and five (5) years of experience, employer will accept a Master’s degree (or foreign equivalent) in Information Systems, Information Technology, Computer Science, or a related field, and three (3) years of project management experience, which must include the following:

-Three (3) years of experience in data integration using Extract, Transform and Load (ETL) methods with Microsoft Business Intelligence (BI) and Informatica PowerCenter tools;

-Three (3) years of experience in SQL programming;

-Three (3) years of experience in performance tuning SQL queries with MS SQL Server database;

-Two (2) years of experience using Tableau desktop and SAP Business Objects for predictive analytics, volume forecasting, trending analysis, and creating dashboards; and

-One (1) year of experience with big data framework and programming in Python.

All experience may be concurrent.

Johns Hopkins Hospital is a smoke free campus.

Johns Hopkins Health System and its affiliates are Equal Opportunity/Affirmative Action employers. All qualified applicants will receive consideration for employment without regard to race, color, religion, sexual orientation, gender identity, sex, age, national origin, disability, protected veteran status, and or any other status protected by federal, state, or local law.

APPLY

Learn More About
Johns Hopkins Medicine.