Lead AWS Data Engineer Job at SFE, Maryland

  • SFE
  • Maryland

Job Description

Must Have Technical/Functional Skills:
  • 12+ years of solid hands-on experience in Python, AWS Data Services, DBT, Apache Airflow (on Astronomer platform), SQL and PySpark
  • Very Good hands-on knowledge on SQL and Data Warehousing life cycle is an absolute requirement.
  • Experience in creating data pipelines and orchestrating using DBT & Apache Airflow
  • Significant experience with data migrations and development of Operational Data Stores, Enterprise Data Warehouses, Data Lake and Data Marts.
  • Experiencing in fixing performance issues / parallelism, Data model exposure is a must.
  • Good to have: Experience with cloud ETL and ELT in one of the tools like Glue/EMR or any other ELT tool
  • Experience in using Snowflake, DB2, Postgres and other database technologies is plus.
  • Excellent communication skills to liaise with Business & IT stakeholders.
  • Expertise in planning execution of a project and efforts estimation.
  • Exposure to working in Agile ways of working

Roles & Responsibilities:

  • Lead the design of reliable, secure, and highly available data lakes, data marts and data meshes
  • leads the design, development, and maintenance of data integration solutions using Python, AWS Data Services, DBT ensuring data pipeline & data quality
  • Collaborate with business stakeholders and architects to define the enterprise data strategy, data models, and migration Roadmap
  • Translate complex technical constraints into business insights and manage expectations across cross-functional teams
  • Develop, modify, configure & debug existing data pipeline as per the business requirement.
  • Troubleshoot and resolve technical issues. Debug, tune and optimize code for optimal performance
  • Manage the new requirements, Review the existing jobs, Perform gap analysis & Fixing performance issues, etc.
  • Guide, coach, and upskill junior and mid-level data engineers on best practices, coding standards, and modern data patterns
  • Document all data flow & mappings, sessions and workflows
  • Ticket handling and problem ticket analysis skills in Agile /POD approach'

Job Tags

Permanent employment, Full time

Similar Jobs

Monte Rosa Therapeutics

Clinical Systems Specialist, IT Job at Monte Rosa Therapeutics

OverviewMonte Rosa Therapeutics is seeking a Clinical Systems Specialist to join our IT team as the technical bridge between Clinical Operations...  ...s degree in a technical, life sciences, or clinical data field, or equivalent hands-on experience.Job SummaryID: 2026-1231... 

united stars.

Metals Testing Laboratory Technician 3rd Shift Job at united stars.

 ...Summary of Position: The Laboratory Technician Perform a variety of testing duties to analyze and assess the mechanical, chemical and physical properties of various metals. Job Description: Metals Testing Laboratory Technicians are responsible for: Sample... 

INTERACTION 24 LLC

Freight Broker Job at INTERACTION 24 LLC

 ...development Bonus based on performance Competitive salary Freight Broker Entry-Level & Experienced Welcome Location: Downtown...  ...apply Nice to Have (Not Required) Freight/logistics experience Bilingual English/Spanish (a plus, especially for the Miami... 

Lovington Healthcare

Certified Medication Aide 6P-6A Job at Lovington Healthcare

 ...Description Job Description Objective Administers prescribed medications and treatments as defined by state regulations 1to residents...  ...medication, using specified procedures Qualifications Certified as required by state law. Previous experience in long-term... 

Legacy Funeral

Funeral Director & Embalmer Job at Legacy Funeral

Funeral Director & EmbalmerThe Funeral Director & Embalmer compassionately facilitates funeral arrangement discussions and implements choices made by the families' legal representatives regarding the funeral, final disposition of the body, and memorialization of the individual...