Data Warehouse Specialist

Johns Hopkins Health Plansis 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 the 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 youll do:

• Design develop document and manage ETL (Exchange Transfer Load) processes for database and data warehouse solutions.
• You are involved in the design of technical and functional requirements for data integration projects.
• Responsible for 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.
• Evaluates 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 youll 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 to include 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 development tools and/or other software development languages (Python PowerShell C# Microsoft SQL Server Integration Services etc.) is desirable
• The ability to read and understand data model (ER) diagrams.
• A thorough knowledge of data warehouse and data management principles and processes.
• Understanding of ETL advanced concepts of data flow data enrichment data consolidation change data capture and transformation.
• Understanding of 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.
• 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 educational requirements.
  • Additional education may be substituted for some experience.

Requires a degree in Computer Science or related technology field; Masters Degree Preferred.

Who we are:

Johns Hopkins Health Plans (JHHP) is the managed care and health services business of Johns Hopkins Medicine. JHHP is a $3B business serving over 500000 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.

Many organizations talk about transforming the future of healthcare at Johns Hopkins Health Plans we are setting the pace for change within the healthcare industry. We develop innovative 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.

Salary Range: Minimum 41.32/hour - Maximum 72.31/ will be commensurate with equity and experience for roles of similar scope and responsibility.

In cases where the range is displayed as a $0 amount salary discussions will occur during candidate screening calls before any subsequent compensation discussion is held between the candidate and any hiring authority.

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

Diversity and Inclusion are Johns Hopkins Medicine Core Values. We are committed to creating a welcoming and inclusive environment where we embrace and celebrate our differences where all employees feel valued contribute to our mission of serving the community and engage in equitable healthcare delivery and workforce practices.

Johns HopkinsHealth Systemand its affiliatesare 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.