Sql Database Architect work from Home

Job Description

Role: AWS Data Architect
Work Type: Hybrid – 3 days in a week from office

Employment Type: Fulltime

Trianz is an applied AI solutions company that accelerates customer business transformation through AI powered “Transformation Services as a Software Model” . With 25+ years of transforming enterprises, we’ve evolved to a product-led, platform-driven organization serving global enterprises across Financial Services, Insurance, Healthcare, Hi-Tech, Manufacturing, and other industries.
With global presence across 4 continents, our platform portfolio under the unified Concierto brand delivers end-to-end transformations including solutions for Migrate, Manage, Maximize, Modernize, Insights & Agentic AI, and SecOps – delivered through strategic partnerships with leading hyperscalers.
We’re building the premier innovation-led organization in the digital transformation space through AI-first methodologies and data-driven excellence – RevolutionAIzing Transformations.

We are seeking a highly experienced and hands-on AWS Data Architect to lead the design, implementation, and governance of enterprise-scale data platforms on AWS. The ideal candidate will be a player-coach—capable of defining architecture, building solutions, and ensuring best practices across data engineering, analytics, and governance.

Define and own end-to-end data architecture on AWS (ingestion, storage, transformation, consumption)
Design scalable, secure, and high-performing data platforms (lakehouse / modern data stack)
Establish standards for data modeling, partitioning, metadata, and lifecycle management
Architect solutions for both batch and real-time data processing
Build and implement pipelines using AWS Glue, EMR, Lambda, Step Functions
Design data storage using S3, Redshift, RDS, DynamoDB
Develop and optimize ETL/ELT pipelines using PySpark, SQL, and Python
Implement data transformation frameworks and reusable components
Data Governance & Security
Define and enforce data governance, cataloging, and lineage
Design row-level security, IAM policies, encryption strategies
Work with AWS Lake Formation / Glue Data Catalog
Performance & Optimization
Optimize data pipelines for performance and cost efficiency
Drive SPICE/BI dataset optimization (if QuickSight or similar tools involved)
Improve query performance in Redshift/S3-based architectures
Mentor data engineers and enforce engineering best practices
Act as the primary owner of data architecture decisions
Lead legacy data platform migrations (e.g., on-prem, Tableau, Hadoop) to AWS
Define strategies for data platform modernization and cloud-native adoption
Support large-scale BI/reporting migrations (e.g., Build standardized KPIs, calculated fields, and metric definitions.
Design modular AI agents and workflow templates that can be used across multiple business functions.
Implement parameterized dashboards and reusable visual components.
Quick Suite Development & AI-Powered Reporting
Build and configure Quick Chat agents to enable natural language querying across business data sources.
Design Quick Spaces that group data, applications, and AI agents for specific business functions or teams.
Build high-performance dashboards optimized for large datasets and fast refresh times.
Implement row-level security (RLS) and governance controls for business users and AI agents.
Design and maintain semantic layers and curated datasets for reporting and AI consumption.

Overall 12+ years of experience, including 5 to 7+ years in AWS Data Architecture.
Core AWS Expertise
S3 (data lake design)
AWS Glue (ETL, catalog)
Amazon Redshift (data warehouse design & optimization)
Data Engineering & Processing
SQL (advanced level)
Python for data pipelines
Data Architecture
Data lake / lakehouse architectures
Data modeling (dimensional + normalized)
Metadata and cataloging strategies
Handling large-scale, distributed data systems
Modern Data Stack (Preferred)
BI tools (QuickSight, Tableau, Power BI)
API-based ingestion and microservices-based data flows
Amazon Quick Suite (QuickSight, Quick Chat, Quick Flows, Quick Automate, Quick Research)
SQL & Data Modeling
AWS Analytics Stack
AI Agent Design & Configuration
AWS Certifications (Solutions Architect, Data Analytics Specialty)
Experience with data governance frameworks / regulatory compliance
Background in large enterprise transformations

Bachelor’s degree in Computer Science, Engineering, Information Systems, or equivalent experience

Personal Growth: Startup agility with enterprise impact. Experience rapid innovation cycles while working on Fortune 500 transformations.
AI-First Future: Where humans and AI revolutionize business. Lead the charge in implementing AI-driven transformation at scale.
Shape transformation across continents. Executive Access: Direct impact on Fortune 500 strategies. Ownership & Entrepreneurial Spirit: Your ideas, our platform, global impact. Compensation & Benefits for Fulltime hiring.
Trianz also offers comprehensive benefits including medical, dental, vision, FSA, EAP, 401(k) , flexible PTO, flexible schedule, and professional development assistance.

Trianz is an Equal Opportunity Employer and does not discriminate based on race, color, creed, national or ethnic origin, gender, religion, disability, age, political affiliation or belief, special needs veteran, veteran of the Vietnam Era, or citizenship status (except in those special circumstances permitted or mandated by law). Our policy is available upon request. We consider qualified applicants with criminal histories, consistent with applicable federal, state, and local law. We are committed to providing reasonable accommodation for all qualified individuals with a disability or other reasons protected by applicable laws. If you require assistance or accommodation due to a disability or special needs to search for a job opening or apply, please email usrecruitment@trianz.Trianz respects your privacy and wants to ensure we comply with applicable Data Privacy Regulations as per local regulator laws. Please review our privacy policy at for more.