Data Engineer AWS - US Citizens

Fracsys Inc

Leesburg (VA)

On-site

USD 120,000 - 180,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Fracsys Inc is hiring an AWS Data Engineer to lead the technical delivery of Data Warehousing and BI projects. The ideal candidate has 8+ years of industry experience and must meet clearance and US citizenship requirements.

Responsibilities include building data marts, writing complex SQL, and designing cloud data patterns using AWS services. The role requires strong data engineering, analytics, and communication skills to present conclusions to diverse audiences.

Qualifications

  • 8+ years of experience in Data Engineering, Data Analysis, and Data Science.
  • Experience building Data Marts and Data Warehouses on-premise and on cloud.
  • Strong SQL and relational DB expertise with Postgres and AWS RDS.
  • Hands-on experience with ETL tools (Informatica/Talend) and BI tools (Power BI, MicroStrategy).
  • Familiarity with cloud-native AWS data services (S3, Athena, Redshift).
  • Excellent written and verbal English communication skills.

Responsibilities

  • Lead delivery of Data Warehousing and BI projects.
  • Write complex SQL queries and procedures for data extraction and analysis.
  • Develop and optimize data pipelines for batch and real-time processing.
  • Build and optimize data patterns on cloud data warehouses and data virtualization.
  • Evaluate new data tooling and technologies for cloud data ecosystems.
  • Collaborate with stakeholders to communicate analytical insights effectively.

Skills

Data engineering
SQL
Python
ETL
BI tooling
Cloud data platforms
Data warehousing
Data analysis
Communication

Education

Bachelor's degree in CS/Analytics/IS
Master’s degree (preferred)

Tools

Informatica
Talend
Power BI
MicroStrategy
Erwin
Oracle
SQL Server
NoSQL
Python
AWS
S3
Redshift
Snowflake
Hadoop
Kafka
Airflow
Hive

Job description

Fracsys Inc is hiring a AWS Data Engineer position. The ideal candidate must have at least 8+ years of industry experience. He or she must be responsible for successful technical delivery of Data Warehousing and Business Intelligence projects. This positions requires US Citizenship due to Clearance requirements.

Responsibilities
  • Data extraction, Data cleaning, Data Loading, Statistical Data Analysis, Exploratory Data Analysis, Data Wrangling,
  • Write complex SQL queries and stored procedures to extract, manipulate, and analyze data from relational databases
  • Conduct diagnostic, troubleshooting steps and present conclusions to a varied audience
  • comfortable slinging some code to solve a problem
  • Build Data Marts and Data warehouses to facilitate analytical capabilities across the varied sources of data
  • Design and implement data patterns on cloud using cloud Data warehouse and data virtualization tools
  • Evaluate new tools and technologies for target state on cloud
  • Learn and implement new ETL, BI tools and data warehousing technologies
Qualifications
  • Senior Data professional with over 8 years of expertise in Data Engineering, Data Analysis, and Data Science.
  • Experience creating Data Marts, Data warehouses on-premise and on cloud for real time and batch processing frameworks
  • Experience building and optimizing big-data data pipelines and data sets including Postgres, AWS Relational Data Service
  • extensive hands-on experience building and optimizing data structures for data analytics, data science and business intelligence
  • Experience building self-service data consumption patterns and knowledge of cloud-based data Lake platforms
  • Experience wrangling data (structured and unstructured), in-depth knowledge of database architecture
  • Experience utilizing or leading implementations leveraging ETL tools (Informatica / Talend), BI Reporting tools such as MicroStrategy, Microsoft Power BI, data modeling tools such as Erwin, Oracle, SQL server, NoSQL, JDBC, UNIX shell scripting, PERL and JAVA, XML/JSON files, SAS , Python, AWS cloud-native technologies, S3, Athena, Redshift
  • Experience in snowflake is an added bonus.
  • Familiarity with the following technologies: Hadoop, Kafka, Airflow, Hive, Presto, Athena, S3, Aurora, EMR, Spark
  • Ability to drive, contribute to, and communicate solutions to technical product challenges
  • Ability to roll-up your sleeves and work in process or resource gaps and fill it in yourself
  • Excellent written and oral communication skills in English
Education

Bachelor’s degree in computer science, Data Analytics, Information Systems, or a related degree or equivalent experience. Master’s degree is preferred.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer AWS US Citizens
Data Engineer AWS US Citizens

FRACSYS INC • Leesburg (VA)

On-site
USD 110,000 - 140,000
Senior AWS Data Engineer: Data Warehousing & BI
Senior AWS Data Engineer: Data Warehousing & BI

Fracsys Inc • Leesburg (VA)

On-site
USD 120,000 - 180,000
AWS Data Engineer
AWS Data Engineer

Qode • United States

On-site
USD 150,000 - 210,000
AWS Data Engineer
AWS Data Engineer

Valiant Technologies LLC • Seattle (WA)

On-site
USD 120,000 - 170,000
AWS Data Engineer
AWS Data Engineer

Ethereum Technologies LLC • New Jersey

On-site
USD 120,000 - 180,000
AWS Data Engineer
AWS Data Engineer

Ethereum Technologies LLC • Seattle (WA)

On-site
USD 110,000 - 160,000
AWS Data Engineer
AWS Data Engineer

Quantum Technologies LLC • Chicago (IL)

On-site
USD 120,000 - 170,000
Data Engineer
Data Engineer

The Value Maximizer • South Carolina

On-site
USD 90,000 - 120,000
Data Engineer
Data Engineer

Compunnel Inc. • Boston (MA)

On-site
USD 110,000 - 140,000
AWS Data Engineer
AWS Data Engineer

Robotic Process Automation LLC • Dallas (TX)

On-site
USD 77,000 - 110,000