Initial 4-6 weeks Onsite role then Remote…
Hi,
Please share your interest and resume at arjun@centraprise.com
AWS Data Architect
Columbia, SC (Initial 4-6 weeks Onsite then Remote)
12+ Months Contract
Job Description:
We are seeking a highly experienced, hands-on AWS Data Architect to lead the design and execution of our cloud data ecosystem. The primary focus is the end-to-end migration and modernization of legacy on-premise Microsoft stacks (SQL Server EDW, SSIS, and multi-platform reporting) to a cloud-native AWS architecture.
Core Roles & Responsibilities:
1. Architectural Strategy & Migration Design
- Modern Data Architecture: Design and evolve a Lakehouse/Mesh architecture using AWS S3, Glue, and Amazon Redshift.
- Legacy EDW Migration: Execute the migration strategy for moving MS SQL Server EDW to AWS, ensuring high performance and data integrity.
- Pipeline Modernization: Refactor legacy SSIS packages into cloud-native services using AWS Glue, Step Functions, or MWAA (Airflow).
- BI & Report Modernization: Lead the migration path for SSRS, Crystal Reports, Power BI, Tableau, and Hyperion to AWS-integrated environments or Amazon QuickSight.
- Governance & Compute: Implement multi-region scalability and robust governance using AWS Lake Formation and Glue Data Catalog, while optimizing compute via Serverless (Athena/Lambda) vs. Managed (EMR/MSK) strategies.
2. Hands-on Engineering & Implementation
- ETL/ELT Conversion: A development-heavy role refactoring SSIS logic into Python/Spark within AWS Glue or EMR.
- Database Migration: Hands-on use of AWS DMS and SCT to migrate data from MS SQL to RDS, Aurora, or Redshift.
- Real-time Streaming: Implement streaming solutions using Amazon Kinesis or Managed Kafka (MSK).
- Infrastructure as Code (IaC): Automate all deployments using Terraform, AWS CDK, or CloudFormation.
3. Optimization, Security & Compliance
- Performance: Tune Redshift (distribution styles/sort keys) and optimize SQL/Spark query performance for low-latency BI.
- FinOps: Monitor and reduce AWS spend via S3 lifecycle policies and Glue job optimization.
- Security: Design fine-grained access via IAM and Lake Formation; manage encryption using KMS and Secrets Manager.
Technical Skills & Experience Requirements:
Mandatory AWS Expertise:
- Migration/Storage: AWS DMS, SCT, Amazon S3 (Optimization & Replication).
- Processing & Analytics: AWS Glue, EMR, Lambda, Amazon Redshift (RA3), Amazon Athena.
- Data Stores: DynamoDB, Aurora (PostgreSQL/MySQL), Neptune.
- Messaging & Orchestration: Kinesis, MSK, SQS, Step Functions, MWAA (Airflow).
Legacy Stack & General Skills:
- Legacy Systems: Deep expertise in MS SQL Server, SSIS, SSRS, Crystal Reports, Power BI, Tableau, and Hyperion.
- Languages: Advanced Python and SQL (T-SQL and SparkSQL).
- DevOps: Git-based CI/CD pipelines (Jenkins, GitLab, or AWS CodePipeline).
Data Formats: Deep understanding of Parquet, Avro, and Delta Lake.
Regards,
Arjun Pandit | Client Partner
Centraprise Corp | 33 S Wood Ave, Ste 600, Iselin, NJ 08830
Email: arjun@centraprise.com
(E-Verify)
Please note - Centraprise is an equal opportunity employer. Applicants must be authorized to work in the U.S.
U.S. Citizens and Green Card holders are strongly encouraged to apply.
We respect your online privacy. If you would like to be removed from our mailing list, please reply with "Remove" in the subject and we will comply immediately. We apologize for any inconvenience caused. Please let us know if you have more than one domain. The material in this e-mail is intended only for the use of the individual to whom it is addressed and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended recipient, be advised that the unauthorized use, disclosure, copying, distribution, or the taking of any action in reliance on this information is strictly prohibited. We are an equal opportunity employer with a diverse workforce.
