Associate Architect - Data (AWS + AtScale)

Quantiphi, Inc.; Mumbai; On-site; INR 1,500,000 - 2,500,000; Full time

Benefits offered by this job

Diverse work culture

Learning and growth opportunities

Hybrid work model

Job summary

A leading data solutions firm is seeking an Associate Architect to design and implement data warehouses and lakes on AWS. The role requires 5+ years of experience and comprehensive knowledge of tools like AtScale, along with programming skills in Python and SQL. This position will involve architecting large-scale data solutions and optimizing query performance, making contributions in a dynamic team environment. An exciting opportunity for those passionate about data and its applications in business.

Qualifications

• 5+ years of experience in designing and implementing data warehouses and data lakes on AWS.
• Hands-on experience with AtScale or similar tools for business-friendly data access across BI platforms.
• Strong programming capability in Python and PySpark for large-scale data processing.

Responsibilities

• Designing and implementing data lake architectures on Amazon S3.
• Developing ETL frameworks using AWS Glue.
• Running distributed data workloads on Amazon EMR.

Skills

Data warehouse design

AWS services knowledge

Python programming

SQL query optimization

AtScale or semantic layer tools

Education

Solution Architect- Associate or Data Engineer- Associate Certification

Tools

AWS Lambda

AWS Glue

Amazon Redshift

Job description

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**!*Thank you for your interest in Quantiphi! We are a team that dreams together and collaborates to ensure success. We are currently looking for exceptional individuals who can join us and contribute to a fun, diverse and hybrid work culture. As a part of the Quantiphi family, you will get ample opportunities to learn, grow and interact with colleagues from varied experience and backgrounds around the globe. If this excites you, explore our current openings and apply to any job roles that suit and interest you.