Landmark Health

Returning Candidate?

SQL ETL Developer - Healthcare

SQL ETL Developer - Healthcare

Job Locations 
US-CA-Huntington Beach
US-MD-Baltimore
Category 
Information Technology
Type 
Regular Full-Time
Posted Date 
10/17/2017
Job ID 
2017-1568

More information about this job

Overview

Who Are We?

Landmark Health is a high growth, entrepreneurial organization committed to improving healthcare for patients with the most serious and complex medical needs wherever they reside and whenever they need it.

Landmark is built upon the core belief that a physician-led, patient-centric, and contextually relevant intervention plan is the key to driving meaningful impact to patient care. Our clinical model is transformative – it represents a landmark in the evolution of our nation’s healthcare system.

Turning this vision into reality requires exceptional people who share our unwavering commitment to the patients we serve.

Do you want to make a difference?

Join us today!

Visit our website: www.landmarkhealth.org

Responsibilities

In this high-profile role, The SQL ETL Developer on our Business Intelligence team will assist in the design and development of data feeds, interfaces, data warehouses and enterprise reporting. To be successful, the SQL ETL Developer will demonstrate a strong working knowledge of extract, transform, and load (ETL) development using SQL Server Integration Service (SSIS). In addition, you will have the opportunity to consult with non-technical business customers to determine requirements and apply the business rules to the data. This individual will work closely with internal departments and counterparts within health plans during implementation and through ongoing operations.

What you'll be doing:

  • Analyze, develop, test, maintain and support complex data/process models, reports and processes in an ETL environment using SSIS and SSRS
  • Design, develop, and support complex integration processes (including interfaces) using SQL Server technology, stored procedures and SQL program code
  • Translate business requirements into technical designs to map and load data from source systems to data warehouses, downstream applications, and trading partners.
  • Work closely with operations and IT to ensure all necessary Client data (eg Lab, Rx, Claims/Encounters, EDI) feed into Landmark tools
  • Ensure quality and accuracy of the data mapped from staging environments to the target reporting environments.
  • Maintaining data repository with data definitions, relationships, linkages and sources.
  • Communicate open items and issues to key stakeholders, including management, development teams, and business areas.
  • Perform root cause analysis for issues and provide effective and timely resolution

Qualifications

What we're looking for:

  • Bachelor's Degree in Computer Science or Information Systems preferred or equivalent experience.
  • 4+ years of experience utilizing Microsoft technologies in development and operation of Data Warehouse, ETL, and application integration solutions via Microsoft SSIS.
  • In-depth knowledge of SQL Server Integration Services (SSIS).
  • Experience working with EDI files (834, 837) helpful.
  • Knowledge in SQL Queries and Stored Procedure writing.
  • SQL Server Reporting Services (SSRS) experience.
  • MSBI Certification is a plus
  • Ability to resolve critical production issues.
  • High energy, ability to work in a high growth, entrepreneurial environment and think outside the box.

Bonus Points Awarded for: 

Experience and familiarity with various types of healthcare-related data—membership, claims, laboratory, pharmacy, authorizations, EDI, HL7 etc.—utilized in healthcare organizations that take insurance risk.

Need help finding the right job?

We can recommend jobs specifically for you! Click here to get started.