Data Engineer AWS

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.

• 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

• 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 Micro Strategy, Microsoft Power BI, data modeling tools such as Erwin, Oracle, SQL server, No
  
  SQL, 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

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