AWS Senior Data Engineer

Employer
Savvy Technology Solutions
Location
Washington, DC
Posted
Nov 14, 2022
Closes
Nov 27, 2022
Ref
717692316
Function
Engineer, IT, QA Engineer
Hours
Full Time
*Responsibilities *Provide Information and Architecture solutions to ensure efficient manipulation, organization and sharing of information, data and/or master data in data-lake, lake-house and data-mart constructs.Collaborate with Cloud Enterprise Architect to define the appropriate Cloud Database solution for current and new systems, such as AWS Redshift, Database Migration Service, Glue, EMR, Elastic Compute Cloud (EC2), S3, Relational Database Service (RDS)/Aurora, and Amazon Kinesis.Define access patterns, storage methods and integration patterns for the movement and maintenance of data into unstructured, relational and noSQL databasesDevelop and design the models for complex analytical and data warehouse systems including performing tasks related to database design, data analysis, data quality, metadata management and support.Work with highly diverse data from a wide variety of sources, in a wide variety of formats, and employed by a wide variety of highly siloed systems.Apply best practices to design and build complex ETL processesSupport services vendor and third party product vendors in the migration of data to the Cloud*Competences **Yrs. *Bachelor's degree in computer science or engineering or equivalent work experienceAWS Solutions Architect - Associate certification within past three yearsAWS Certified Data Analytics - Specialty or AWS Certified Big Data - Specialty certificationsSolutions architecture experience in an enterprise environment with emphasis on data systems5Specific experience designing, executing and supporting AWS data lakes at scale3Experience designing, optimizing, and maintaining relational and non-relational databases including MySQL, MS SQL, Redshift, AWS RDS and other NoSQL databases5Experience with the design and building of ETL packages, data pipelines and connecting these to BI applications5Knowledge of data movement and data presentation tools such as; Informatica, MS SSIS, AWS Glue, Cognos, Tableau3Ability to pass a background check and pass the criteria for a CJIS environmentWillingness to research and self-study to keep technical skills relevant in a highly complex environmentAbility to multi-task and prioritize deadlines as needed to deliver resultsAbility to work independently or as part of a teamMentors and coaches colleagues and seeks opportunities for continuous improvementExcellent verbal and written communication skills with great attention to detail and accuracyExperience working in an Agile/Scrum environmentJob Types: Full-time, ContractPay: $89,677.00 - $125,000.00 per yearBenefits:* 401(k)* Dental insurance* Health insurance* Paid time off* Vision insuranceSchedule:* Monday to Friday* On callExperience:* AWS Cloud Engineer: 8 years (Required)* AWS Cloud Architecture: 5 years (Required)* Data warehouse: 3 years (Required)License/Certification:* AWS Certification - Professional (Required)Work Location: One location