Data Engineer
Infotree Service Inc
San Jose, CR
hace 3 días

Job Description

As a Healthcare company that operates with a significant amount of patient data

records (Claim and EMR healthcare data), the client needs to upgrade the ETL and

extract processes to be generic, repeatable, and applicable to as many data sources as

possible.

You Perfectly Match If you have :

3+ years of commercial experience with hands-on Database Design, Modeling

  • and Warehousing;
  • Strong knowledge of all traditional Data Warehouse-related components

    Sourcing, ETL, Data Modeling, Infrastructure, BI, Reporting) and the modern

  • tools to support those components;
  • Strong experience with SQL design and implementation best-practices (i.e. index

  • management, constraints, and foreign key relationships, etc.);
  • Be familiar with Linux and Bash scripting;
  • Expertise in query tuning and performance optimization;
  • Visualization skills : Power BI / Tableau would be a plus;
  • Good spoken and written English.

    Nice To Have :

  • Experience with AWS-based database systems (Snowflake, Redshift;
  • RDS / Aurora, etc. )

    Familiarity with the MPP Databases (Redshift or Vertica), Hadoop ecosystem and

  • HQL;
  • Understanding of CDM (Common Data Model) concepts such as OMOP OHDSI;
  • Python programming experience;
  • PySpark;
  • Familiarity with continuous delivery and DevOps;
  • Experience with Claim and EMR healthcare data.

    Your day-to-day activities :

    Convert logical models into physical data models employing sound database

  • normalization techniques;
  • Create physical database objects like tables and views with appropriate data

    types, foreign keys, constraints, and upfront design and maintenance of proper

  • indexes;
  • Create and maintain easy to follow technical documentation of data models;
  • Perform SQL code reviews and ensure that new database code meets company

  • standards for readability, reliability, and performance;
  • Assist with resolving the performance of poorly executing stored procedures and

  • queries;
  • Support building and deploying the infrastructure for ingesting high-volume data

  • from various sources;
  • Research individually and in collaboration with other teams on how to solve

    problems

    Reportar esta oferta
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Inscribirse
    Mi Correo Electrónico
    Al hacer clic en la opción "Continuar", doy mi consentimiento para que neuvoo procese mis datos de conformidad con lo establecido en su Política de privacidad . Puedo darme de baja o retirar mi autorización en cualquier momento.
    Continuar
    Formulario de postulación