Senior Data Engineer - AWS

3 days ago

Apply Now

Receive Emails with Similar Jobs

ICF

WebsiteLinkedInAll Job Openings

Aviation • Climate • Cybersecurity • Digital and Marketing • Education

5001 - 10000

💰 Grant on 2023-02

Description

• We are seeking a talented Data Engineer to join our team and play a pivotal role in transforming raw data into actionable insights. • As a Data Engineer, you will design, develop, and maintain robust data pipelines and ETL processes, ensuring seamless data flow from various sources to our data warehouse. • Your expertise in AWS technologies and BI tools will be instrumental in delivering high-quality data solutions that drive informed decision-making. • Develop and implement efficient ETL pipelines to extract data from diverse legacy systems, transform it to meet business requirements, and load it into our data warehouse or data lake. • Develop security procedures and creating systems to keep data secure. • Design and build scalable data warehouses and data lakes to store and manage large volumes of structured and unstructured data. • Ensure data quality by implementing data validation and cleansing processes, identifying and resolving data inconsistencies. • Create and maintain data models that accurately represent the business domain, ensuring data integrity and consistency. • Leverage AWS services like AWS Glue, S3, Redshift, EMR, and Lambda to build and manage data pipelines effectively. • Integrate data with BI tools (e.g., Tableau, Power BI) to enable data-driven insights and reporting. • Work closely with data analysts, data scientists, and business stakeholders to understand their data requirements and deliver solutions that meet their needs.

Requirements

• Bachelor's degree in Computer Science, Data Engineering, or a related field. • 3+ years of experience in data engineering or a similar role. • 3+ years of experience building ETL pipelines from multiple database systems using SQL, Spark, Unix, Python, Java or C# languages. • 3+ years of experience with SQL and Python or other scripting languages. • 3+ years of experience with ETL processes and tools. • 3+ years of experience with AWS technologies, including S3, Redshift, EMR, and Lambda. • 2+ years of experience with RDBMS such as Oracle 12c, MS SQL Server, DB2 etc. • Green Card Holder or US Citizenship required due to federal contract requirements. • Must be able to obtain Public Trust clearance. • MUST RESIDE IN THE United States (U.S.) and the work MUST BE PERFORMED in the United States (U.S.), as this work is for a federal contract and laws do apply.