Cloud Data Architect

SMX is looking for a Cloud Data Architect who has hands-on experience with leading the design and implementation of an AWS big data solution which would include data warehousing and/or data lake approaches.  This role would recommend and design innovative data solutions using AWS cloud-native services.  This person would also guide applications teams to adapt their application to leverage AWS Data Analysis Services.  Additionally, this role will be a team player who engineers and supports data solutions and operations.  This is a full-time position which is primarily remote but may require quarterly travel to the client’s office located in Washington, DC.

Essential Duties and Responsibilities:

•    Develop and implement data architecture roadmap
•    Build relationships with client Chief Data Officer & leadership and Lead Data Scientist
•    Designs and oversees implementation of big data and architecture solutions
•    Is part of the team that implements and supports data solutions
•    Help design and develop database objects (tables, views, etc.) and SQL-based ETL processes in support of the implementation.
•    Maintain optimal data architecture as business requirements evolve and upstream system changes are implemented

Required Skills:  
•    Experience with implementing data analytics tools in AWS (Redshift, S3, QuickSight)
•    Experience with AWS Storage Services (S3 and RDS)
•    Experience in AWS Event/Data Processing Services (Lambda, Glue, SageMaker)
•    Expert in SQL knowledge
•    Experience with ETL Tools (e.g., Python)
•    Experience with Reporting/Analytics tools
•    Excellent collaboration skills and communication skills
•    Experience with administration of users, roles, security policies, etc. on AWS

•    Understanding of core AWS services, uses, and AWS architecture best practices 


Required Experience: 
•    Bachelor’s Degree in Statistics, Science, Computer Science, Management Information Systems, Engineering, Business Analytics disciplines, or related area
•    3+ years of experience with AWS administration, Redshift, and SQL

Desired Skills:

  • Big Data Architecture