AWS Data Architect

Trianz; Lebanon (NJ); Hybrid; USD 150,000 - 170,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

401(k)

Job summary

Trianz is seeking an experienced AWS Data Architect to lead the design, implementation, and governance of enterprise-scale data platforms on AWS. You will drive architecture decisions, guide teams, and contribute hands-on development across data engineering, analytics, and governance.

The ideal candidate will be a player-coach, defining architecture, building solutions, and ensuring best practices in batch and real-time processing. This role is hybrid with 3 days in the office.

Qualifications

• 12+ years of overall experience with 5–7+ years in AWS data architecture.
• Strong ownership and ability to lead end-to-end data platforms on AWS.
• Experience with data governance, security, and cataloging.

Responsibilities

• Define and own end-to-end data architecture on AWS.
• Design scalable data platforms (lakehouse / modern data stack).
• Build and optimize ETL/ELT pipelines using PySpark, SQL, and Python.
• Lead technical discussions and design reviews; mentor engineers.
• Migrate legacy data platforms to AWS; modernize data platforms.

Skills

AWS Data Architecture

Architectural Ownership

PySpark

SQL

Spark

Lambda

Glue

Redshift

Kinesis

Data Modeling

Data Lake / Lakehouse

Security & IAM

Education

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

Tools

AWS Glue

Amazon Redshift

EMR

QuickSight

Tableau

Power BI

dbt

Airflow

Snowflake

Job description

Work Type: Hybrid - 3 days in a week from office

Company Overview

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.

Role Overview

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. 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 Responsibilities

• 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
• 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
• 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
• Work closely with business, analytics, and engineering teams
• Lead technical discussions and design reviews
• Mentor data engineers and enforce engineering best practices
• Act as the primary owner of data architecture decisions

Migration & Modernization

• 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., to QuickSight)
• Create 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 Reporting

• Design, 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 Profile

Overall 12+ years of experience, including 5 to 7+ years in AWS Data Architecture.

Core AWS Expertise

• Deep experience with:
• AWS Glue (ETL, catalog)
• Amazon Redshift (data warehouse design & optimization)
• Lambda, Step Functions (orchestration)
• IAM, Lake Formation (security)
• Strong hands-on experience with:
• PySpark / Spark (EMR or Glue)
• SQL (advanced level)
• Experience with streaming (Kinesis / Kafka) is a plus
• Data lake / lakehouse architectures
• Data modeling (dimensional + normalized)
• Metadata and cataloging strategies

Modern Data Stack (Preferred)

• Exposure to:
• dbt, Airflow, Snowflake (optional but valuable)
• 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
• Workflow Automation & Business Process Optimization

Soft Skills

• Strong ownership mindset and ability to drive architecture end-to-end
• Excellent communication with both technical and business stakeholders
• Ability to work in fast-paced, ambiguous environments
• Proven leadership and mentoring experience

Nice-to-Have

• AWS Certifications (Solutions Architect, Data Analytics Specialty)
• Experience with data governance frameworks / regulatory compliance
• Background in large enterprise transformations

Education:

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

Why 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 execution.

Compensation & Benefits for Fulltime hiring.

Trianz compensation reflects the cost of labor across several US geographic markets. The base pay ranges between USD $150000 to $170,000. Pay is based on several factors including market location and may vary depending on job-related knowledge, skills, and experience. The actual wage offered may be lower or higher depending on budget and candidate experience, knowledge, skills, qualifications, and premium geographic location. 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). We comply with all state and federal laws and regulations protecting employees and applicants against illegal discrimination, retaliation, and harassment. Our policy is available upon request. We consider qualified applicants with criminal histories, consistent with applicable federal, state, and local law. Trianz participates in the E-Verify program in certain locations, as required by 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 [e-mail] with your request and contact information.

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 https://www.trianz.com/privacy-policy for more.