Data Engineer AWS US Citizens

FRACSYS INC

Leesburg (VA)

On-site

USD 110,000 - 140,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

A leading data solutions firm in Virginia is seeking an experienced AWS Data Engineer. The ideal candidate will have over 8 years of experience in data engineering and will be responsible for the successful delivery of data warehousing and business intelligence projects. Responsibilities include data extraction, building data marts, and implementing cloud data patterns. A bachelor's degree is required, and familiarity with ETL and BI tools is essential.

Qualifications

  • 8+ years of experience in Data Engineering, Data Analysis, and Data Science.
  • Experience creating Data Marts and Data warehouses.
  • Hands-on experience building data structures for analytics.

Responsibilities

  • Data extraction, cleaning, and loading.
  • Write complex SQL queries.
  • Build Data Marts and Data warehouses.

Skills

Data Engineering
Data Analysis
SQL
Statistical Data Analysis
Data Wrangling
ETL tools
AWS Technologies

Education

Bachelor’s degree in computer science, Data Analytics, or Information Systems
Master’s degree (preferred)

Tools

Postgres
MicroStrategy
Microsoft Power BI
Informatica
Talend
Snowflake
Hadoop

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 120,000 - 180,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
Data Engineer
Data Engineer

Compunnel Inc. • Boston (MA)

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

The Value Maximizer • South Carolina

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

Compunnel Inc. • Pennsylvania

Hybrid
USD 85,000 - 125,000
Senior Data/Systems Analyst
Senior Data/Systems Analyst

Diaconia • Gaithersburg (MD)

On-site
USD 140,000 - 200,000
Cloud Data Engineer(Python)
Cloud Data Engineer(Python)

Premier Inn Hotels LLC (UAE) • Plano (TX)

On-site
USD 130,000 - 190,000
Data Engineer
Data Engineer

Compunnel Inc. • Texas

On-site
USD 90,000 - 120,000
Data Engineer: Scalable ETL & Analytics Pipelines
Data Engineer: Scalable ETL & Analytics Pipelines

Compunnel Inc. • Pennsylvania

Hybrid
USD 85,000 - 125,000
Data Engineer — Build Scalable Cloud Data Pipelines
Data Engineer — Build Scalable Cloud Data Pipelines

Compunnel Inc. • Westlake (OH)

On-site
USD 90,000 - 120,000