Mid-Level Cloud Data Engineer

Summary

Join SMX as a Cloud Data Engineer and contribute to creative solutions for our clients. This remote position, supporting a Washington, DC team, requires hands-on experience with AWS technologies and RDMS. You will collaborate with the Cloud Data Architect and client data professionals. Responsibilities include assisting in requirements gathering, implementing data loading and quality control, and implementing CI/CD pipelines. The role demands expertise in SQL, AWS, and RDBMS concepts, along with strong communication and collaboration skills. US Citizenship and the ability to obtain a Public Trust clearance are required.

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
• Ability to obtain and maintain a Public Trust clearance.  US Citizenship is required
• Strong team collaborator and communicator
• Bachelor's degree in Computer Science, Information Systems, or a related field

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

Preferred Qualifications

• Version control CI/CD knowledge (Git, TFS, Azure DevOps, etc)
• Awareness of network authentication and authorization protocols (Kerberos, SAML/OAUTH)
• Some network knowledge

Benefits

• Health insurance
• Paid leave
• Retirement
• Learning & development opportunities