SMX is seeking creative technical problem solvers who can develop solutions with our clients. We are looking for a Cloud Data Engineer who has hands-on experience with using AWS technologies and solid RDMS experience related to data migration, modeling, and optimization. This person will be closely collaborating with the Cloud Data Architect and client data professionals to produce creative solutions. This position is a remote position supporting a Washington, DC team. Must be willing to work EST time zone hours, but maybe required to work off-hours based on client needs.
Essential Duties and 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.
Required Skills:
• 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
Desired Skills:
• AWS related certifications
Education and Certifications:
• Bachelor's degree in Computer Science, Information Systems, or a related field. Additional years of experience in lieu of degree will be considered.
Application deadline 11-29-2024
#LI-Remote
At SMX®, we are a team of technical and domain experts dedicated to enabling your mission. From priority national security initiatives for the DoD to highly assured and compliant solutions for healthcare, we understand that digital transformation is key to your future success.
We share your vision for the future and strive to accelerate your impact on the world. We bring both cutting edge technology and an expansive view of what’s possible to every engagement. Our delivery model and unique approaches harness our deep technical and domain knowledge, providing forward-looking insights and practical solutions to power secure mission acceleration.
SMX is committed to hiring and retaining a diverse workforce. All qualified candidates will receive consideration for employment without regard to disability status, protected veteran status, race, color, age, religion, national origin, citizenship, marital status, sex, sexual orientation, gender identity or expression, pregnancy or genetic information. SMX is an Equal Opportunity/Affirmative Action employer including disability and veterans.
Selected applicant will be subject to a background investigation.