Data Engineer AWS - US Citizens

Fracsys Inc
Leesburg, VA, United States
4 days ago
Apply on www.careerbuilder.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
8 years minimum
Compensation
$120,000
Working hours
Regular working hours
Languages
English

Tech stack

Java (Programming Language) Airflow Amazon Web Services Amazon S3 Data Analysis Batch Processing Big Data Cloud Database Information Systems Databases Data Cleansing Information Engineering
+38 more
Data Files Extract Transform Load (ETL) Data Mart Data Mining Data Structures Data Virtualization Data Warehousing Database Analysis Relational Databases Perl (Programming Language) Apache Hadoop Apache Hive Java Database Connectivity JSON Python (Programming Language) PostgreSQL Unix Shell Microsoft SQL Server MicroStrategy NoSQL Oracle (Applications) Power BI SAS (Software) SQL Stored Procedures SQL Databases Talend Extensible Markup Language (XML) Data Processing Freeform SQL Snowflake Apache Spark Er-Win Information Technology Data Analytics AWS Data Analytics Apache Kafka Presto Data Pipelines

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, ExploratoryData Analysis, Data Wrangling,
  • Write complex SQL queries and stored procedures to extract, manipulate, and analyze data fromrelational 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

Requirements

Amazon Web Services (AWS), Business Intelligence, Technical Delivery, Data Warehousing, United States Citizen, Amazon Web Services (AWS), Stored Procedures, SQL (Structured Query Language), Data Analysis, Database Analysis, * Senior Data professional with over 8 years of expertise in Data Engineering, Data Analysis, and DataScience.

  • 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. Compensation: $120,000.00 per year

About the company

Fracsys, Is A Women Owned Small Business (WOSB) and SBA Hubzone certified IT Services Organization. Fracsys provides IT Services With A Focus On Enterprise Modernization and Data Analytics as a service. Fracsys also provides Cloud Migration strategies that align with organizations IT and Data Strategies. We Provide Services That Help Clients Design, Develop And Execute A Custom IT / Data Strategy, Architect And Implement The Solution. Fracsys provides end to end Application development and data solutions on the Cloud (AWS, Azure). Our Current/Past Clients include NIH, CMS, FDA, FCC, FannieMae We Work With Our Clients To provide solutions that generate value and provide business process re-engineering services to produce efficient systems. We Develop Strategies that utilizes our services to provide the best ROI and deliver modernized systems that provide efficient data collection, processing, analytics, and business applications.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerbuilder.com
Prepare application

Good distractions

Loading talks and stories from around this role…