AWS Data Architect

AWS Data ArchitectLocation: [Location(s) / Remote] – Hybrid – Clinton, NJ – 3 days in a week from officeEmployment Type: [Full-time / Contract] – ContractDuration: 6 monthsCompany OverviewTrianz 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.Role OverviewWe 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. This role requires deep technical expertise, strong architectural ownership, and the ability to actively contribute to development while guiding teams.The ideal candidate will be a player-coach—capable of defining architecture, building solutions, and ensuring best practices across data engineering, analytics, and governance.Key ResponsibilitiesArchitecture & DesignDefine 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 managementArchitect solutions for both batch and real-time data processingHands-On EngineeringBuild and implement pipelines using AWS Glue, EMR, Lambda, Step FunctionsDesign data storage using S3, Redshift, RDS, DynamoDBDevelop and optimize ETL/ELT pipelines using PySpark, SQL, and PythonImplement data transformation frameworks and reusable componentsData Governance & SecurityDefine and enforce data governance, cataloging, and lineageDesign row-level security, IAM policies, encryption strategiesWork with AWS Lake Formation / Glue Data CatalogPerformance & OptimizationOptimize data pipelines for performance and cost efficiencyDrive SPICE/BI dataset optimization (if QuickSight or similar tools involved)Improve query performance in Redshift/S3-based architecturesCollaboration & LeadershipWork closely with business, analytics, and engineering teamsLead technical discussions and design reviewsMentor data engineers and enforce engineering best practicesAct as the primary owner of data architecture decisionsMigration & ModernizationLead legacy data platform migrations (e.g., on-prem, Tableau, Hadoop) to AWSDefine strategies for data platform modernization and cloud-native adoptionSupport large-scale BI/reporting migrations (e.g., to QuickSight)Reporting Frameworks & Reusable ComponentsCreate reusable reporting templates, dataset templates, and QuickSight themes.Build standardized KPIs, calculated fields, and metric definitions.Design modular AI agents and workflow templates that can be used across multiple business functions.Design modular reporting components that can be used across multiple dashboards.Implement parameterized dashboards and reusable visual components.Quick Suite Development & AI-Powered ReportingDesign, develop, and maintain interactive dashboards, datasets, and visualizations in Amazon QuickSight (now part of Quick Suite).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.Create standardized QuickSight templates and dashboard frameworks that can be reused across teams.Design and maintain semantic layers and curated datasets for reporting and AI consumption.Ideal Candidate ProfileOverall 15+ years of experience, including 5 to 7 years in AWS Data Architecture.Core AWS ExpertiseDeep experience with: S3 (data lake design)AWS Glue (ETL, catalog)Amazon Redshift (data warehouse design & optimization)Lambda, Step Functions (orchestration)IAM, Lake Formation (security)Data Engineering & ProcessingStrong hands-on experience with: PySpark / Spark (EMR or Glue)SQL (advanced level)Python for data pipelinesExperience with streaming (Kinesis / Kafka) is a plusData ArchitectureExpertise in: Data lake / lakehouse architecturesData modeling (dimensional + normalized)Metadata and cataloging strategiesHandling large-scale, distributed data systemsModern Data Stack (Preferred)Exposure to: dbt, Airflow, Snowflake (optional but valuable)BI tools (QuickSight, Tableau, Power BI)API-based ingestion and microservices-based data flowsAmazon Quick Suite (QuickSight, Quick Chat, Quick Flows, Quick Automate, Quick Research)SQL & Data ModelingAWS Analytics StackDashboard DesignAI Agent Design & ConfigurationWorkflow Automation & Business Process OptimizationSoft SkillsStrong ownership mindset and ability to drive architecture end-to-endExcellent communication with both technical and business stakeholdersAbility to work in fast-paced, ambiguous environmentsProven leadership and mentoring experienceNice-to-HaveAWS Certifications (Solutions Architect, Data Analytics Specialty)Experience with data governance frameworks / regulatory complianceBackground in large enterprise transformationsEducation:Bachelor's degree in Computer Science, Engineering, Information Systems, or equivalent experienceWhy choose Trianz?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.Global Impact: Shape transformation across continents. Work with diverse teams and clients spanning Americas, Europe, Asia, and beyond.Executive Access: Direct impact on Fortune 500 strategies. Work alongside C-suite leaders and influence major business decisions.Ownership & Entrepreneurial Spirit: Your ideas, our platform, global impact. Zero bureaucracy culture with decision-making autonomy and rapid