Cloud Data Engineer

Summary

Join our team as a Cloud Data Engineer at SMX, where you'll develop solutions with clients using AWS technologies and collaborate with the Cloud Data Architect and client data professionals.

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. Etc.)
• 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

Responsibilities

• Assist Data Architect and customer (data scientists) in collecting requirements and documenting tasks for maintaining and enhancing data loading platform (ETL / data pipelines), emphasizing performance and data quality
• Implementation of data loading and quality control activities as prescribed by project requirements and/or customer tickets
• Implementation of CI/CD pipelines in support of both infrastructure and data loading activities related to data warehouse maintenance
• Coding and implementation of unique data migration requirements based on AWS technologies such as DMS and Lambda/Python
• Implementation and problem resolution for end user identity and access management to various data sets in Postgres, Redshift, and SQL server platforms

Benefits

• Health insurance
• Paid leave
• Retirement