Cloud Data Migration Architect

Droisys is an innovation technology company focused on helping companies accelerate their digital initiatives from strategy and planning through execution. We leverage deep technical expertise, Agile methodologies, and data-driven intelligence to modernize systems of engagement and simplify human/tech interaction.

Amazing things happen when we work in environments where everyone feels a true sense of belonging and when candidates have the requisite skills and opportunities to succeed. At Droisys, we invest in our talent and support career growth, and we are always on the lookout for amazing talent who can contribute to our growth by delivering top results for our clients. Join us to challenge yourself and accomplish work that matters.

Job Title AWS Cloud Data Migration Architect

Job Location Saint Louis, MO (Onsite)

Duration 12 Months

Key Responsibilities

Strategy & Planning

Define overall data migration strategy and roadmap for moving on-premises and/or other cloud workloads to AWS.

Assess existing data landscape, source systems, volumes, data quality, and integration patterns to determine migration approach.

Select appropriate AWS services and components (e.g., AWS DMS, SCT, S3, Glue, Snowball/Snowcone, RDS, Aurora, Redshift) based on requirements.

Develop detailed migration plans including timelines, cutover approaches, rollback plans, and resourcing.

Solution Design & Architecture

Design target data architectures on AWS including landing zones, staging, raw/curated zones, and data consumption layers.

Define standards and patterns for data ingestion, transformation, and loading using AWS components (e.g., S3, Glue, Lambda, Step Functions, Kinesis, EMR, Redshift).

Work with security and architecture teams to ensure designs meet enterprise standards, including IAM, encryption, network architecture (VPC, PrivateLink), and compliance requirements.

Execution & Delivery

Lead end-to-end execution of migration waves/phases, including pilots, test migrations, and final cutovers.

Configure and manage AWS migration tools such as AWS Database Migration Service (DMS) and Schema Conversion Tool (SCT).

Oversee data extraction from source systems, data transformation/cleansing, and loading into AWS target systems.

Coordinate with application teams to validate application behavior post-migration and support go-live.

Monitor migration performance and troubleshoot issues with data latency, data loss, schema mismatches, and dependencies.

Data Quality, Governance & Security

Define and implement data validation and reconciliation procedures to ensure completeness and accuracy of migrated data.

Establish data quality rules, checks, and reporting; resolve defects in collaboration with source and target system owners.

Ensure adherence to data governance, privacy, and security policies across all migration activities.

Implement and validate security controls using AWS services (KMS, IAM, CloudTrail, CloudWatch, Config, Macie, GuardDuty, etc.).

Stakeholder Management & Leadership

Lead a cross-functional migration team (data engineers, DBAs, BAs, QA, and vendor resources).

Act as primary point of contact for migration status, risks, and issues; provide regular updates to leadership and project stakeholders.

Conduct migration readiness assessments, risk assessments, and lessons-learned reviews.

Provide guidance, coaching, and knowledge sharing on AWS data migration best practices.

Required Qualifications

Strong hands-on experience with AWS data and migration services such as:

AWS Database Migration Service (AWS DMS)

AWS Schema Conversion Tool (SCT)

Amazon S3, Glue, Lambda, Step Functions

Amazon RDS / Aurora and/or Amazon Redshift

Proven experience leading end-to-end data migration projects (assessment through cutover) in complex enterprise environments.

Solid understanding of relational databases (e.g., Oracle, SQL Server, MySQL, PostgreSQL) and/or data warehouse platforms.

Experience with data modeling, ETL/ELT processes, and SQL.

Strong understanding of cloud security, IAM, networking basics (VPC, subnets, security groups), and encryption.

Excellent communication, stakeholder management, and leadership skills; ability to coordinate cross-functional teams.

Preferred Qualifications

Experience migrating from on-premises or other cloud platforms (e.g., Oracle, Teradata, Netezza, on-prem SQL Server) to AWS.

Experience with large-scale data warehouse or data lake implementations on AWS (e.g., Lakehouse architectures).

Familiarity with CI/CD and Infrastructure as Code (IaC) tools (e.g., CloudFormation, Terraform, CodePipeline).

Knowledge of streaming and real-time ingestion solutions (e.g., Kinesis, MSK).

AWS certification(s) such as:

AWS Certified Solutions Architect – Associate/Professional

AWS Certified Data Engineer – Associate / Big Data (legacy)

AWS Certified Database – Specialty

Experience working in Agile or hybrid project management methodologies.

Droisys is an equal opportunity employer. We do not discriminate based on race, religion, color, national origin, gender, gender expression, sexual orientation, age, marital status, veteran status, disability status or any other characteristic protected by law. Droisys believes in diversity, inclusion, and belonging, and we are committed to fostering a diverse work environment