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

Epic Data Warehouse Specialist

Requisition #: 188793
Location: Johns Hopkins Health Care, Hanover, MD 21076
Category: Information Technology
Work Shift: Day Shift
Work Week: Full Time (40 hours)
Weekend Work Required: No
Date Posted: June 28, 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.

Leads the design, development, documentation, and management of ETL (Exchange, Transfer, Load) processes for the data warehouses. Leads the design of technical and functional requirements for data integration projects. Advises and recommends best practices for design, development, and testing of ETL processes. In collaboration with the reporting manager and data warehouse manager leads the alignment of the ETL environments with operational and business needs and strategies. This position will be responsible for overseeing the development and maintenance of ETL mappings for multiple development projects. Will lead the interaction with business users and decision support staff as part of the support work for error resolution and design enhancements. Assist in the development of reporting and analytics solutions for the data warehouse. Will assist in setting the direction for data quality initiatives to profile and cleanse data prior to loading into the warehouse. Will work closely with the data architect to ensure that the models are loaded with effective and efficient ETL practices. Evaluates reported defects and performance problems related to ETL. Participates in setting and enforcing departmental standards for analysis, development and quality assurance within the ETL process.

Assists in the design, development, documentation, and management of ETL (Exchange, Transfer, Load) processes for the data warehouses. Assist with the design of technical and functional requirements for data integration projects. Advises and recommends best practices for design, development, and testing of ETL processes. Under direction of the reporting manager aligns the ETL environments with operational and business needs and strategies. This position will be responsible for developing and maintaining ETL mappings for multiple development projects. Will interact with business users and decision support staff as part of the support work for error resolution and design enhancements. Assist in the development of reporting and analytics solutions for the data warehouse. Will participate in data quality initiatives to profile and cleanse data prior to loading into the warehouse.

Job Scope/Complexity:
Responsible for full life-cycle of large/long-term highly complex projects. Typically manages multiple projects of varying complexities. Based on expert technical knowledge, skills and experience, develops broad-based solutions involving multifaceted technologies, and business processes. Leads overall strategy, design & architecture for solutions.

Job Responsibilities:
The responsibilities listed below are typical examples of the work performed by this position. Not all duties assigned to this position are included, nor is it expected that everyone in this position will be assigned every job responsibility.

• Assist with the design of technical and functional requirements for data integration projects
• Advises and recommends best practices for design, development, and testing of ETL processes
• Under direction of the reporting manager aligns the ETL environments with operational and business needs and strategies
• Developing and maintaining ETL mappings for multiple development projects
• Interact with business users and decision support staff as part of the support work for error resolution and design enhancements
• Assist in the development of reporting and analytics solutions for the data warehouse
• Participate in data quality initiatives to profile and cleanse data prior to loading into the warehouse
• Develop ETL architecture standards, procedures and policies and assist in developing ETL processes for the organization

Requirements:

  1. Education:

Requires a degree in Computer Science or related technology field; Master’s Degree Preferred.

Work experience may substitute for some educational requirements.

B. Knowledge:

Requires a thorough knowledge of data warehouse and data management principles and processes.
Understand ETL advanced concepts of data flow, data enrichment, data consolidation, change data capture and transformation.
Understands the range of options and best practices for common ETL design techniques such as change data capture, key generation and optimization.

Significant experience with data quality, data profiling, metadata management and reporting.

Experience with all phases of the Software Development Life Cycle (SDLC).

Strong proficiency in SQL programming, query writing, query performance tuning, and database technologies.

Knowledge of medical coding systems, i.e. ICD9, CPT, HCPCS, ACGs is desirable. Knowledge of data modeling, process modeling, data warehouse, and data management principles and processes preferred.

C. Skills:

Requires strong SQL, analytical, and computational skills.
Expertise and experience in the use of an ETL development tool (Informatica PowerCenter, DataStage, Business Objects Data Integrator, Microsoft SQL Server Integration Services)
The ability to read data model (ER) diagrams.

Should possess strong leadership skills. Advanced interpersonal skills to interface effectively with department heads, employees, clients, consultants and JHHC and JHMCIS staff. Effective communication skills for interaction with staff, peers and customers. Experience with data modeling tools and software preferred. Must be able to work as a member of a problem solving team.

Must be able to read and understand software application manuals related to job tools.

D. Required Licensure, Certification, Etc.:

None

E. Work Experience:

Data Warehouse Specialist I

5+ years experience with ETL tools and ETL programming.

3+ years experience designing ETL solutions for data migration or data integration.

10+ years experience with IT projects and software development
1+ years of SQL Server experience

Additional education may be substituted for some experience.

Data Warehouse Specialist II

5+ years experience with ETL tools and ETL programming.

5+ years experience designing ETL solutions for data migration or data integration.

10+ years experience with IT projects and software development
1+ years of SQL Server experience

Additional education may be substituted for some experience.

Experience in developing ER and dimensional models, data architecture and data warehousing.

F. Machines, Tools, Equipment:

Works effectively with PC productivity tools e.g. MS Office as required. Development tools such as Data Services, Informatica, Embarcadero, Red Gate, Microsoft SSRS, SSAS, SSIS, SharePoint integration, SQL Programming, SQL server management studio, relational databases. Web Technologies, MS SQL Server 2008/2010/2014, Oracle, IBM DB2, ODBC, OLE DB, Active Directory

Citizenship Requirement: Please note that under the terms of a government contract, this specific position requires U.S. citizenship status to ensure compliance with the Department of Defense Personnel Security Program. We expect the team, at times, to work after hours as well as downtime weekends as necessary.

#LI-AH1

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.