Overview

Join to apply for the Data Warehouse Specialist role at Johns Hopkins Health Plans.

Requisition #:657161 | Location: Johns Hopkins Health Plans, Hanover, MD 21076

Johns Hopkins Health Plans is a leader in provider-sponsored health plans. If you are interested in improving how healthcare is delivered, and have a passion to be at the forefront of change, JHHP is the place to call home. YOU belong here.

What Awaits You

• Work-life balance - This is a remote role. Applicants living in MD, DC, VA, PA, DE, or FL will be given first consideration.
• Medical, Dental, and Vision Insurance.
• 403B Savings Plan w/employer contribution.
• Paid Time off & Paid holidays.
• Employee and Dependent Tuition assistance benefits.
• Health and wellness programs and MORE!

Who You Are

As an ETL Developer, you have the perfect blend of ETL experience, along with experience in Health Insurance concepts (claims, pharmacy, regulatory programs such as HEDIS, etc.) to successfully design and implement data engineering solutions in a dynamic, high-productivity team.

What You’ll Do

• Design, develop, document, and manage ETL (Exchange, Transfer, Load) processes for database and data warehouse solutions.
• Involved in designing technical and functional requirements for data integration projects.
• Developing and maintaining ETL mappings for multiple development projects.
• Assist in the development of reporting and analytics solutions for the data warehouses.
• Work closely with the data architects to ensure that the models are loaded, using effective and efficient ETL practices.
• Evaluate reported defects and performance problems related to ETL.
• Participate in setting and enforcing departmental standards for analysis, development and quality assurance within the ETL process.

What You’ll Bring

• 5+ years’ experience designing ETL solutions for data migration or data integration.
• 3+ years of SQL Server experience or other relational database management systems.
• Knowledge of medical coding systems, i.e. ICD10, CPT, or HCPCS is desirable.
• Knowledge of Managed Care and Health Insurance concepts including HEDIS, Stars, and other NCQA programs is highly preferred.
• Expertise and experience in the use of Informatica PowerCenter ETL development tool is required.
• Working knowledge of other ETL tools and/or software development languages (Python, PowerShell, C#, Microsoft SQL Server Integration Services, etc.) is desirable.
• Ability to read and understand data model (ER) diagrams.
• Thorough knowledge of data warehouse and data management principles and processes.
• Understanding of ETL concepts such as data flow, data enrichment, data consolidation, change data capture and transformation.
• Understanding of ETL design techniques such as change data capture, key generation and optimization.
• Experience with data quality, data profiling, metadata management and reporting.
• Strong proficiency in SQL programming, query writing, query performance tuning, and database technologies.
• Experience in developing Entity Relationship (ER) and dimensional models, data architecture and data warehousing.
• Effective communication skills for interaction with staff, peers and customers.
• A degree in Computer Science or related technology field; work experience may substitute for some education.
• Master’s Degree preferred.

About Johns Hopkins Health Plans

Johns Hopkins Health Plans (JHHP) is the managed care and health services business of Johns Hopkins Medicine. JHHP is a $3B business serving over 500,000 active members with lines of business in Medicaid, Medicare, commercial, military health, health solutions, and venture investments. JHHP is a leader in provider-sponsored health plans and is poised for future growth.

We are committed to transforming healthcare with analytics-driven health programs in collaboration with provider partners to drive improved quality and better health outcomes for our members and the communities we serve.

Equal Opportunity Employer

Johns Hopkins Health Plans is an Equal Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity and expression, age, national origin, mental or physical disability, genetic information, veteran status, or any other status protected by federal, state, or local law.

Johns Hopkins Health System and its affiliates are drug-free workplace employers.

JHM prioritizes the health and well-being of every employee. Come be healthy at Hopkins!