FRACSYS INC
Data Engineer AWS
FRACSYS INC, Leesburg, Virginia, United States, 22075
Job DescriptionFracsys Inc is hiring an AWS Data Engineer. The ideal candidate must have at least 8+ years of industry experience and be responsible for successful technical delivery of Data Warehousing and Business Intelligence projects. This position 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 coding to solve problems.
Build Data Marts and Data Warehouses to facilitate analytical capabilities across 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 and Data Warehouses on-premise and on cloud for real-time and batch processing frameworks.
Experience building and optimizing big-data pipelines and datasets 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) with 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, 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 them 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.
#J-18808-Ljbffr
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 coding to solve problems.
Build Data Marts and Data Warehouses to facilitate analytical capabilities across 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 and Data Warehouses on-premise and on cloud for real-time and batch processing frameworks.
Experience building and optimizing big-data pipelines and datasets 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) with 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, 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 them 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.
#J-18808-Ljbffr