Landmark Health

Healthcare Data Developer

Job Locations US-CA-Huntington Beach
Posted Date 1 week ago(7/24/2020 12:47 PM)
Category
Information Technology
Type
Regular Full-Time
Job ID
2020-4061

Overview

The Data Developer will assist in the design and development of data feeds, interfaces, data warehouses and enterprise reporting. The Data Developer must demonstrate strong working knowledge of extract, transform, and load (ETL) development using SQL Server Integration Service (SSIS) and ability to interact with non-technical business customers to determine requirements and apply business rules to the data. Experience and familiarity with various types of healthcare-related data—membership, claims, laboratory, pharmacy, authorizations, etc. This individual will work closely with internal departments and health plan counterparts during implementation and ongoing operations.

 

In addition to the above, the Data Developer will design, implement, and document data architecture and data modeling solutions, which include the use of relational, dimensional, and NoSQL databases. These solutions support enterprise information management, business intelligence, data science, and other business interests. Hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols) is a plus! Our ideal candidate will have:

  • High energy; demonstrates an ability to thrive in a creative, fast-paced environment
  • Ability to work under pressure to resolve critical production issues
  • Strong problem solving and analytical skills

Please note VISA SPONSORSHIP is not offered for this position

 

 

Responsibilities

  • Work with business and technical teams to design and develop the conceptual, logical, and physical data models, implement RDBMS, operational data store (ODS), data marts and data lakes on target platforms (SQL/NoSQL)
  • Oversee the expansion of existing data architecture and the optimization of data query performance leveraging best practices
  • Analyze, develop, test, maintain and support complex data/process models, and processes in an ETL environment using SSIS
  • Design, develop, and support complex integration processes using SQL Server technologies and SQL 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 (e.g. Lab, Rx, Claims/Encounters) 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
  • Provide ad-hoc reports and analysis to support the business need

 

Qualifications

• 4+ years of experience in developing customer BI products or configuring existing ones.
• Solid understanding of all the underlying infrastructure is also required: This includes the understanding of data integration tools, ETL/ELT processes, data formatting, and warehouse architecture.
• Tableau, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) experience.
• Expert knowledge in SQL queries and stored procedure writing.
• Strong analytical, data-processing and problem-solving skills.
• Background in data warehouse design.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Need help finding the right job?

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