Landmark Health

  • SQL ETL Developer - Healthcare

    Job Locations US-CA-Huntington Beach
    Posted Date 2 weeks ago(10/5/2018 4:00 PM)
    Category
    Information Technology
    Type
    Regular Full-Time
    Job ID
    2018-2529
  • 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 databases like MongoDB or similar
    • 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
    • Support offshore development team with future development needs 
    • Deploy new upgrades and releases in production

    Qualifications

    • 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) and strong understanding of DW processes and OLAP concepts
    • Experience working with X12 EDI files (834, 837) is a plus
    • Knowledge of HL7 is a plus
    • Knowledge in SQL Queries and Stored Procedure writing
    • SQL Server Reporting Services (SSRS) experience
    • At least 3 years health care experience is preferred
    • 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.

    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.