Назад
Company hidden
41 минуту назад

Data Engineer (ETL/Data Warehousing)

Тип работы
project
Грейд
senior
Английский
b2
Страна
US
Вакансия из списка Hirify.GlobalВакансия из Hirify Global, списка международных tech-компаний
Для мэтча и отклика нужен Plus

Мэтч & Сопровод

Для мэтча с этой вакансией нужен Plus

Описание вакансии

Текст:
/
TL;DR
Data Engineer (ETL/Data Warehousing): Designing and implementing ETL/ELT pipelines, dimensional data models, data warehouses, and business intelligence reporting with an accent on large-scale data integration, complex SQL, and data quality. Focus on orchestrating workflows with UNIX and shell scripting, applying Spark and Python integration patterns, and maintaining data integrity in Databricks-based environments.

Location: Richmond, VA, United States

Company

hirify.global provides cloud technology services.

What you will do

  • Design, develop, and implement ETL and ELT pipelines for large volumes of data.
  • Build dimensional data models using star schemas and slowly changing dimensions.
  • Write complex SQL for data warehouse environments and integrate data into analytical models.
  • Deliver business intelligence reporting warehouses using tools such as MicroStrategy, Tableau, and Birst.
  • Orchestrate complex workflows and exception handling with UNIX/Linux and shell scripting.
  • Monitor data quality, maintain data integrity, and establish consistent data definitions.

Requirements

  • 5+ years of experience with ETL/ELT development using Informatica, Talend, DMS, or Syncsort.
  • 5+ years of experience with dimensional data modeling, including star schemas and SCD1.
  • 5+ years of experience writing complex SQL in data warehouse environments.
  • 5+ years of experience delivering business intelligence reporting warehouses.
  • 3+ years of experience with UNIX/Linux, shell scripting, Spark, and Python or Spark SQL.
  • At least 2 years of experience with Databricks, Snowflake, Python, or Jupyter.

Culture & Benefits

  • Long-term contract engagement.
  • Interviews conducted by telephone or Zoom.

Будьте осторожны: если работодатель просит войти в их систему, используя iCloud/Google, прислать код/пароль, запустить код/ПО, не делайте этого - это мошенники. Обязательно жмите "Пожаловаться" или пишите в поддержку. Подробнее в гайде →