Data Warehouse Specialist

• 
  Share on Facebook
  
• 
  Share on Twitter
  
• 
  Share on LinkedIn
  
• Share via Email

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 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 you'll 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 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 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.
  
  
  
  

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 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.

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/hour. Compensation 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 Hopkins Health System and its affiliates are drug-free workplace employers.