FreshRemote.Work

Senior Data Engineer (AWS)- Remote

Nationwide Remote Office (US99)

 *We are open to supporting 100% remote work anywhere within the US*

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. 

Responsibilities: 

  • Data Extraction, Transformation, and Loading (ETL): 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.  

  • Data Security: Develop security procedures and creating systems to keep data secure   

  • Data Warehousing and Data Lake: Design and build scalable data warehouses and data lakes to store and manage large volumes of structured and unstructured data. 

  • Data Quality: Ensure data quality by implementing data validation and cleansing processes, identifying and resolving data inconsistencies. 

  • Data Modeling: Create and maintain data models that accurately represent the business domain, ensuring data integrity and consistency. 

  • AWS Technologies: Leverage AWS services like AWS Glue, S3, Redshift, EMR, and Lambda to build and manage data pipelines effectively. 

  • BI Tools: Integrate data with BI tools (e.g., Tableau, Power BI) to enable data-driven insights and reporting. 

  • Collaboration: Work closely with data analysts, data scientists, and business stakeholders to understand their data requirements and deliver solutions that meet their needs. 

Basic Qualifications:

  • 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 

Preferred Qualifications:

  • Familiarity with data warehousing and data lake concepts. 

  • Experience with data governance and data quality frameworks. 

  • Knowledge of cloud-native data platforms and technologies. 

  • Certifications in AWS or other relevant technologies.  

Working at ICF

ICF is a global advisory and technology services provider, but we’re not your typical consultants. We combine unmatched expertise with cutting-edge technology to help clients solve their most complex challenges, navigate change, and shape the future.

We can only solve the world's toughest challenges by building an inclusive workplace that allows everyone to thrive. We are an equal opportunity employer, committed to hiring regardless of any protected characteristic, such as race, ethnicity, national origin, color, sex, gender identity/expression, sexual orientation, religion, age, disability status, or military/veteran status. Together, our employees are empowered to share their expertise and collaborate with others to achieve personal and professional goals. For more information, please read our EEO & AA policy.

Reasonable Accommodations are available, including, but not limited to, for disabled veterans, individuals with disabilities, and individuals with sincerely held religious beliefs, in all phases of the application and employment process. To request an accommodation please email Candidateaccommodation@icf.com and we will be happy to assist. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations. Read more here: Requesting an Accommodation for the ICF interview process.

Read more about workplace discrimination rights, the Pay Transparency Statement, or our benefit offerings which are included in the Transparency in (Benefits) Coverage Act.

 

Pay Range - There are multiple factors that are considered in determining final pay for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, geographic location, education and certifications as well as contract provisions regarding labor categories that are specific to the position.

The pay range for this position based on full-time employment is:

$84,533.00 - $143,706.00

Nationwide Remote Office (US99) Apply

Job Profile

Restrictions

100% remote Federal contract requirements Green card holder or US citizenship required Must be able to obtain Public Trust clearance MUST BE PERFORMED in the United States Must obtain public trust clearance Must reside in the United States Remote work Work must be performed in the United States

Benefits/Perks

100% Remote 100% remote work Collaboration Cutting-edge technology Equal opportunity employer Fully remote Inclusive workplace Professional development opportunities Reasonable accommodations Remote Remote-first company Remote work

Tasks
  • Collaborate with stakeholders
  • Collaboration
  • Data extraction
  • Design and maintain data pipelines
  • Develop security procedures
  • Ensure data quality
  • Ensure data quality and security
  • Implement ETL processes
  • Implementing
  • Navigate change
  • Reporting
  • Shape the future
Skills

AWS AWS Glue BI Tools Business Business Requirements C Cloud Collaboration Database Systems Data engineering Data Extraction Data Governance Data integrity Data Lake Data Modeling Data Pipelines Data Quality Data Security Data Solutions Data Validation Data Warehousing Design Education EMR Engineering ETL ETL Processes Governance Integrity IT Java Lambda Modeling MS SQL Oracle Policy Power BI Public Trust Clearance Python RDBMS Redshift Reporting S3 Science Scripting Security Spark SQL SQL Server Tableau Technology Services UNIX WELL

Experience

3 years

Education

Bachelor Bachelor's Bachelor's degree Bachelor's degree in Computer Science Business Computer Science Data Education Engineering IT MS Policy Related Field Relevant Work Experience Science Technology

Certifications

AWS Certification Public Trust Public Trust clearance Relevant Technology Certification

Timezones

UTC-5