Data Engineer - Remote

5 days ago

Apply Now

Receive Emails with Similar Jobs

ICF

WebsiteLinkedInAll Job Openings

Aviation • Climate • Cybersecurity • Digital and Marketing • Education

5001 - 10000 employees

Founded 1969

☁️ SaaS

⚡ Energy

💰 Grant on 2023-02

Description

• Lead and develop data engineering design and build efforts for our client initiative • Develop extract, transform, and load (ETL) processing routines and data engineering pipelines • Perform extensive data profiling and analysis based on client data • Work with UI, UX and business analysis team members and the client to define data and reporting requirements • Design and implement custom data analytic and BI/reporting products, custom reports, and data visualization products • Write, optimize , and maintain complex SQL queries for querying large datasets efficiently • Develop and maintain SAS scripts and stored processes • Work with cloud-based platforms such as Snowflake and AWS (e.g., S3, Lambda) to integrate, process, and manage data • Troubleshoot and resolve data-related issues, optimizing processes for speed and efficiency • Document technical processes, queries, and database configurations for internal and client use

Requirements

• US Citizenship or Green Card Holder is required (required by federal government for this position) • Bachelor’s degree (e.g., Computer Science, Engineering or related discipline) • 2+ years of hands-on experience specifically in AWS and Big Data technologies such as S3, Lambda, Glue, Athena, Python, R-Studio, SageMaker, Eventbridge, LakeFormation, Redshift, RDS, ECS, etc. • 3 + years of experience developing ETL, and data engineering pipelines using AWS services, Python • 3 + years of experience in writing complex SQLs, performance tuning queries • 3+ years of hands-on experience in programming languages such as Python, SQL, SAS. • 2+ years of experience with AWS Redshift or Snowflake