Associate Architect - Data (AWS + AtScale)

About the role

While technology is the heart of our business, a global and diverse culture is the heart of our success. We love our people and we take pride in catering them to a culture built on transparency, diversity, integrity, learning and growth. If working in an environment that encourages you to innovate and excel, not just in professional but personal life, interests you- you would enjoy your career with Quantiphi! Role : Associate Architect - Data (AWS + AtScale) Experience : 5 - 13 Years Location : Mumbai/Bangalore/Trivandrum 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. Strong understanding of semantic modeling, including logical data models, virtual cubes, and centralized metric definitions (single source of truth). Experience optimizing performance using query pushdown, caching, and aggregate awareness over platforms like Redshift and Athena. Ability to integrate semantic layers with BI tools (QuickSight, Tableau, Power BI) and enforce row/column-level security aligned with governance frameworks. Strong programming capability in Python and PySpark for large-scale data processing. Proficiency in writing complex SQL queries, analytical functions, and performance tuning for large datasets. Familiarity with NoSQL databases such as Amazon DynamoDB, MongoDB, or DocumentDB. Strong understanding of partitioning, indexing, scaling approaches, and query optimization techniques. Proven experience in architecting and implementing data pipelines using native AWS services in a modular and resilient manner. Solid understanding of data modeling concepts, including dimensional, normalized, and lakehouse patterns. Solution Architect- Associate or Data Engineer- Associate Certification. Good to have skills: Experience of working for customers/workloads in one of FSI,Retail,CPG domain. Exposure to IaC tools like Terraform and to CI/CD tools Familiarity with data virtualization (e.g., Amazon QuickSight,PowerBI, Tableau) and data governance tools (e.g., Collibra). Managing security, monitoring, and compliance with AWS IAM, Secrets Manager, CloudWatch, CloudTrail, and KMS. Experience with AI-assisted development tools such as GitHub Copilot, Amazon Kiro (or similar GenAI IDEs) for improving developer productivity, code generation, and pipeline acceleration Exposure to Data Mesh architecture,Data Governance frameworks If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us !