Associate Architect - Data (AWS + AtScale)

Must have Skills

• 5+ years of experience in designing and implementing data warehouses and data lakes/lakehouse on AWS.
• Hands-on experience with AtScale or similar semantic layer tools to enable governed, business-friendly data access across BI platforms.
• Proven success working with globally distributed teams in collaborative delivery environments.
• Deep working knowledge across key AWS Data & Analytics services, including: Building large-scale data lake architectures on Amazon S3 and open table formats Implementing governance and cataloging through AWS Lake Formation. Developing ETL and metadata frameworks using AWS Glue. Leveraging AWS Lambda for serverless data processing. Running distributed data workloads on Amazon EMR. Enabling real-time data pipelines with AWS Kinesis (Data Streams and Firehose). Orchestrating pipelines using AWS Step Functions/Amazon MWAA/similar services. Designing and optimizing schemas and query performance on Amazon Redshift, including Spectrum and Serverless features. Querying large datasets interactively using Amazon Athena. Managing operational databases using Amazon RDS across engines such as PostgreSQL, MySQL, and Aurora. Integrating and migrating data using AWS DMS, Glue Connectors, EventBridge, SNS, and SQS.
• Building large-scale data lake architectures on Amazon S3 and open table formats
• Implementing governance and cataloging through AWS Lake Formation.
• Developing ETL and metadata frameworks using AWS Glue.
• Leveraging AWS Lambda for serverless data processing.
• Running distributed data workloads on Amazon EMR.
• Enabling real-time data pipelines with AWS Kinesis (Data Streams and Firehose).
• Orchestrating pipelines using AWS Step Functions/Amazon MWAA/similar services.
• Designing and optimizing schemas and query performance on Amazon Redshift, including Spectrum and Serverless features.
• Querying large datasets interactively using Amazon Athena.
• Managing operational databases using Amazon RDS across engines such as PostgreSQL, MySQL, and Aurora.
• Integrating and migrating data using AWS DMS, Glue Connectors, EventBridge, SNS, and SQS.
• Strong understanding of semantic modeling, including logical data models, virtual cubes, and centralized metric definitions (single source of truth).