Data Engineer

Overview

Remote
$110,000 - $120,000
Full Time
No Travel Required

Skills

Agile
Analytics
Business Intelligence
Dashboard
Cloud Computing
Data Quality
Data Lake
Data Warehouse
Databricks
Master Data Management
Extract
Transform
Load
Snow Flake Schema
Security Clearance
Metadata Modeling
Reporting

Job Details

We are seeking a Data Engineer with strong experience in data architecture, ETL development, and reporting to help design, optimize, and maintain modern data pipelines and warehouses in a cloud-native environment.

Responsibilities:

  • Design and develop data warehouse and data lake solutions that scale across structured, semi-structured, and unstructured data.
  • Build robust ETL pipelines to support high-volume data ingestion, transformation, cleansing, and aggregation.
  • Develop dimensional data models and implement advanced concepts like slowly changing dimensions (SCDs) and fact aggregation to support enterprise reporting.
  • Partner with data analysts and stakeholders to define reporting architecture, metadata models, and dashboards.
  • Ensure data accuracy, governance, and integrity through master data management and advanced data quality practices.
  • Work in an Agile/Scrum environment, collaborating cross-functionally to iterate quickly and deliver business value.
  • Leverage tools across AWS, Oracle, and Amazon RDS, while integrating modern solutions like Snowflake, Databricks, Redshift, or Tableau.

Experience Requirements:

  • 3+ years of experience designing and building data warehouses/lakes and complex ETL pipelines.
  • Expertise with dimensional modeling, data aggregation, and SCDs.
  • Hands-on experience with ETL and analytics tools, plus a strong understanding of data cleansing and master data management.
  • Experience with report architecture, metadata design, and report development.
  • Solid technical background using AWS services, Oracle, and Amazon RDS.
  • Familiarity with Agile or SDLC practices.
  • Eligible to obtain a U.S. security clearance.
  • Experience with Snowflake and/or Databricks.
  • Knowledge of Amazon Redshift.
  • Proficiency with Tableau or similar BI tools.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.