Fracsys Inc · 3 weeks ago
Data Engineer AWS - US Citizens
Leesburg, VA
Full-time
Onsite
Senior Level, Lead/Staff
8+ years expFracsys Inc is hiring for an AWS Data Engineer position. The ideal candidate will be responsible for the successful technical delivery of Data Warehousing and Business Intelligence projects, requiring expertise in data extraction, analysis, and cloud technologies.
AnalyticsAppsCloud ComputingData IntegrationData ManagementSoftware
No H1B
Security Clearance RequiredU.S. Citizen Only
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
Qualification
Required
At least 8+ years of industry experience
US Citizenship due to Clearance requirements
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
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
Preferred
Master's degree is preferred
Experience in snowflake is an added bonus
Company
Fracsys Inc
Fracsys Inc, offer services that assist in creating, implementing, and managing data solutions for the Enterprise and providing tailored approach to AI for federal agencies.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase