Landmark Health

Returning Candidate?

SQL ETL Developer - Healthcare

SQL ETL Developer - Healthcare

Job Locations 
US-CA-Huntington Beach
Category 
Information Technology
Type 
Regular Full-Time
Posted Date 
6/22/2018
Job ID 
2017-1568

More information about this job

Overview

The SQL ETL Developer / Data Analyst will assist in the design and development of data feeds, interfaces, data warehouses and enterprise reporting. The Data Analyst must demonstrate strong working knowledge of extract, transform, and load (ETL) development using SQL Server Integration Service (SSIS), transformation of no-sql data into relational architecture and ability to interact with non-technical business customers to determine requirements and apply the business rules to the data. Experience and familiarity with various types of healthcare-related data—membership, claims, laboratory, pharmacy, authorizations, EDI, HL7 etc.—utilized in healthcare organization that take insurance risk is highly desirable. This individual will work closely with internal departments and with counterparts with health plans during implementation and through ongoing operations.

Responsibilities

  • Design, develop, debug and support complex data integration interfaces and processes (including stored procedure and queries) using various tools and technologies including SSIS, SSAS, SSRS, T-SQL, MSBI, ASP.Net, VB.Net, PowerShell, C# and SQL Server technology
  • Lead the analysis, development, testing and maintenance of complex ETL for NoSQL database like MongoDB
  • Translate business requirements into technical documents and build or redesign existing applications and report dashboards by evaluating integration needs, migration of data between the two systems and building and new data visualizations that meets user expectation
  • Enhance and maintain relational databases to support new application features and maintain data repository with data definitions, relationships, linkages and sources
  • Analyze workflow charts and diagrams and translate operations requirements into technical designs to map and automate data load from source systems to data warehouses, downstream applications, and trading partners
  • Troubleshoot and performance tune the data ingress and egress process and build internal controls and checks to maintain data quality
  • Analyze and develop data integration interfaces and processes for Landmark proprietary data warehouse
  • Support the current production version and help investigate and issues and identify root causes and get it fixed as soon as practical.
  • Using the background knowledge of current intricate transformation logic implemented in the load process, lead the development, testing and maintenance of complex data transformation and load process for new Landmark Proprietary Ubiquity EMR application
  • Continue to perform R&D on new technological capabilities and evaluate incorporation of those technologies in our software (Ubiquity).
  • Troubleshoot, performance tune and monitor the data ingress and egress processes and build internal controls to maintain data quality
  • Train onsite staff with technical and operational aspects of the integration processes
  • Analyze workflow charts and diagrams and translate operations requirements into technical designs to map and automate data load from source systems to data warehouses, downstream applications and trading partners
  • Support offshore development team with future development needs and provide guidance on the technical abilities and limitations based on their strong wealth of knowledge.
  • Deploy new upgrades and releases in production

Qualifications

  • Bachelor's degree in Computer Science, Information Systems or equivalent experience plus 4 years of experience utilizing Microsoft technologies in development and operation of Data Warehouse, ETL, and application integration solutions via Microsoft SSIS.
  • 2+ years of experience with MongoDB
  • In-depth knowledge of SQL Server Integration Services (SSIS) and strong understanding of DW processes and OLAP concepts
  • Experience working with X12 EDI files (834, 837) is a plus
  • Prefer knowledge of HL7
  • Expert knowledge in SQL Queries and Stored Procedure writing
  • SQL Server Reporting Services (SSRS) experience
  • At least 3 years health care experience is a must
  • Ability to work under pressure to resolve critical production issues
  • High energy; demonstrates an ability to function in a creative, entrepreneurial enviornment and think outside the box
  • Good problem solving and debugging skills

 

 

Landmark Health, LLC is an Equal Employment Opportunity/Affirmative Action employer.

 

Need help finding the right job?

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