Data Engineer(Data Modeling)

Overview

Remote
Depends on Experience
Full Time

Skills

Data Engineer
AWS
Snowflake
DBT
Python
SQL

Job Details

Job Title: Data Engineer(Data Modeling)

Location: Orlando, FL (Complete Remote)

Type: Fulltime

Duration: Long Term

Position Summary
We are seeking a skilled Data Engineer with 7+ years of experience to join our growing team. The successful candidate will work on client engagements involving modern data stack implementations, focusing on AWS cloud infrastructure, Snowflake data warehousing, DBT transformations, SQL, Python, Linux and job scheduling(Control M). This role offers the opportunity to work with diverse clients across industries while developing expertise in the latest data engineering technologies.

Key Responsibilities
- Design, build, and maintain scalable data pipelines using AWS services (S3, Lambda, Glue, Step Functions, etc.)
- Implement ETL/ELT processes to ingest data from various sources into Snowflake data warehouse
- Develop automated data workflows to ensure reliable and timely data delivery
- Write and maintain DBT models for data transformation and business logic implementation
- Create efficient SQL queries and stored procedures for data processing and analysis
- Design and implement dimensional data models following best practices
- Develop Python scripts for data wrangling, cleaning, and preprocessing
- Create reusable Python modules and libraries for common data engineering tasks
- Optimize Snowflake warehouse performance and cost management
- Linux system and commands knowledge
- Job Scheduling through Control M

Required Qualifications

Technical Skills:
- 7+ years of experience in data engineering
- AWS Cloud Platform: Hands-on experience with core AWS services (S3, Lambda, Glue, RDS, Redshift, etc.)
- Snowflake: Proficiency in Snowflake data warehouse including architecture, security, and performance optimization
- DBT (Data Build Tool): Experience building and maintaining DBT models, testing, and documentation
- SQL: Advanced SQL skills including complex queries, window functions, and performance optimization
- Python: Strong Python programming skills for data manipulation using pandas, numpy, and other data libraries
- Version Control: Proficiency with Git and collaborative development workflows
- Linux system and commands knowledge
- Job Scheduling through Control M
Soft Skills:
- Strong analytical and problem-solving abilities
- Excellent communication skills with experience working in consulting or client-facing roles
- Strong attention to detail and commitment to data quality
Education & Certifications:
- Masters degree in Computer Science, Engineering, Mathematics, or related technical field
- AWS certifications preferred
- Snowflake certifications (SnowPro Core, Advanced) is a big plus

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.