AWS Data Engineer

4 days ago

Columbia, MO, United States LHH Full-time

Requirements: Coding Assessment and final onsite interview

MUST HAVE CURRENT AWS experience

Final interview is onsite in Florida

Must provide valid state ID and References to be submitted

Role: Senior Data Engineer

Salary: $150,000-170,000

Fully remote

Benefits include 401K, Medial and Dental, and annual bonus

NOT OPEN TO C2C, Sponsorship, or any Visas

Client can only hire SC or GC Holders

As a Senior Data Engineer, you will be working on our data systems and services with other data engineers to deliver projects and systems critical to Platform Ventures business. We expect our data engineers to be versatile, display leadership qualities and be enthusiastic about taking on new problems across our businesses as we continue to build great things for our customers.

Strong Communication with vendors, customers, C-Suite executives, and co workers is imperative.

Job Description

The candidate will design and develop data pipelines, data marts, and schemas to support our data warehousing environments and analytical requirements

Data Platform & Architecture

  • Design and implement scalable data Lakehouse architectures using AWS S3, Delta Lake, and Redshift.
  • Build and maintain high-performance data pipelines to ingest, transform, and curate large datasets.
  • Define best practices for data modeling, partitioning, and storage optimization in a Lakehouse/medallion environment.
  • Develop and maintain data cataloging and metadata management solutions.

Data Engineering & Processing

  • Develop ETL/ELT pipelines using Python, PySpark, and AWS Glue.
  • Build robust batch and streaming data pipelines.
  • Implement transformation workflows using DBT.
  • Optimize performance for Spark workloads and Redshift queries.

Workflow Orchestration

  • Design and maintain workflow orchestration using Apache Airflow.
  • Monitor pipeline performance and implement alerting and failure recovery.

Data Governance & Quality

  • Implement data validation, lineage, and monitoring frameworks.
  • Maintain data documentation and data catalog integration.
  • Ensure data reliability, consistency, and security across platforms.

DevOps & Automation

  • Implement CI/CD pipelines for data workflows.
  • Automate testing, deployment, and monitoring of data pipelines.
  • Use infrastructure-as-code where possible to maintain reproducible environments.

Collaboration

  • Work closely with data consumers, analysts, and platform engineers.
  • Support self-service analytics through well-structured datasets and semantic models.

Minimum Qualifications:

  • 7+ years of data warehousing / OLAP experience
  • 7+ years multidimensional database architecture, data modeling, and design experience
  • 5+ years of SQL Experience
  • 3+ years of Python Experience
  • 2+ years of Redshift Experience
  • 2+ years of NoSQL Experience
  • Team and vendor partner management
  • Clear understanding of principles and techniques of Web development
  • Experience with AWS Glue, Lambda, Step Functions, and Airflow
  • Experience with data ingression from APIs
  • Dimensional database architecture experience
  • Formal systems life cycle methodology experience
  • Experience implementing CI/CD pipelines for data workflows
  • Experience working with data catalogs and metadata management

Desired Qualifications:

  • AWS Data Warehouse operations experience
  • Tableau, Quicksight, Looker, big data and Realtime BI experience
  • Experience with data streaming <