AWS / Azure Cloud Data Engineer (3931)

$124,300 - $186,500/Yr

Smx Corporation Limited

Full-time - Mid Level

Remote

Administrative and Support Services

About the position

The Cloud Data Engineer position at SMX involves developing solutions using AWS technologies and solid RDBMS experience for data migration, modeling, and optimization. The role requires collaboration with the Cloud Data Architect and client data professionals to enhance data loading platforms and ensure data quality. This remote position supports a Washington, DC team and requires working EST hours, with potential off-hours based on client needs.

Responsibilities

• Assist Data Architect and customer in collecting requirements and documenting tasks for maintaining and enhancing data loading platform (ETL / data pipelines).
• Implement data loading and quality control activities as prescribed by project requirements and/or customer tickets.
• Implement CI/CD pipelines in support of both infrastructure and data loading activities related to data warehouse maintenance.
• Code and implement unique data migration requirements based on AWS technologies such as DMS and Lambda/Python.
• Implement and resolve issues for end user identity and access management to various data sets in Postgres, Redshift, and SQL Server platforms.

Requirements

• Two + years of experience
• Expertise in complex SQL
• AWS knowledge
• Solid RDBMS concepts (Postgres, RedShift, SQL Server), logical data modeling, database/query optimization
• AWS data migration tools (DMS)
• Scripting/Python/lambda knowledge
• Version control and CI/CD knowledge (Git, TFS, Azure DevOps)
• Awareness of network authentication and authorization protocols (Kerberos, SAML/OAUTH)
• Some network knowledge
• Ability to obtain and maintain a Public Trust clearance. US Citizenship is required.
• Strong team collaborator and communicator

Nice-to-haves

• AWS related certifications

Benefits

• Health insurance
• Paid leave
• Retirement