Snowflake Solutions Architect

HCLTech is looking for a highly talented and self- motivated Snowflake Solutions Architect to join it in advancing the technological world through innovation and creativity.

Job Title: Snowflake Solutions Architect

Job ID: 118659

Position Type: Full Time/contract

Location: onsite (Union Beach, New Jersey)

Job Description

Snowflake Solutions Architect – AWS Data & Analytics | Power BI | Amazon Bedrock

Role Summary

We are seeking a hands-on Snowflake Solutions Architect to design and lead modern, scalable data platforms on Snowflake + AWS Analytics services, enable governed analytics through Power BI semantic models, and accelerate GenAI use cases using Amazon Bedrock (Agents/Knowledge Bases/Guardrails). The role will partner with business and engineering teams to define architecture, guide implementation, and ensure security, performance, and cost-efficiency across the data and AI landscape.

Key Responsibilities

1) Solution Architecture (Snowflake + AWS Analytics)

• Own end-to-end architecture for cloud data platforms leveraging Snowflake and AWS-native analytics services (e.g., S3, Glue, Lake Formation, Athena, Redshift, EMR/Kinesis/MSK as applicable).
• Define target-state patterns for historical + incremental loads, batch/real-time ingestion, and scalable transformations using tools like dbt and orchestration frameworks (e.g., Airflow).
• Design Lakehouse / Medallion style architectures and integration approaches between AWS data lake and Snowflake analytics marts, including modern table formats (e.g., Iceberg where applicable).
• Lead architecture reviews, trade-off decisions (performance/cost/security), and ensure solutions meet non-functional requirements.

2) Data Engineering Enablement & Integration

• Guide teams on building robust ELT/ETL pipelines, metadata management, and data quality controls (audit, reconciliation, balance/control frameworks).
• Establish best practices for Snowflake performance tuning, query optimization, and workload management.
• Define ingestion patterns from enterprise sources (e.g., SAP and other systems) into AWS/Snowflake using standard integration approaches.

3) Analytics & BI (Power BI)

• Architect and govern Power BI semantic models/datasets, ensuring consistent metrics (“single version of truth”), strong performance, and reusability.
• Implement enterprise-grade security for BI (e.g., Row-Level Security (RLS), access controls, dataset governance) aligned with data platform security design.
• Partner with BI developers and stakeholders to deliver scalable reporting patterns and lifecycle governance (certification, promotion, workspace standards).

4) GenAI Architecture (Amazon Bedrock)

• Design GenAI solution patterns using Amazon Bedrock, including Agents, Knowledge Bases (RAG), and safe deployment controls using Guardrails.
• Define agent tool/action patterns (action groups), retrieval grounding strategy, and observability/tracing for production readiness.

5) Security, Governance & Compliance

• Implement fine-grained access control across the lake/warehouse ecosystem and enforce governance controls for data access and auditability.
• Define governance integration approaches beyond native capabilities when needed (catalog/lineage tools, stewardship workflows).

6) Stakeholder Leadership & Delivery

• Lead technical discovery, translate business needs into architecture, and produce design artifacts (HLD/LLD, roadmaps, standards).
• Mentor engineers, enforce engineering standards, and collaborate across product, platform, security, and operations teams.

Required Qualifications (Must Have)

Experience

• 10+ years in data platform / analytics architecture (or equivalent depth in engineering + architecture).
• Proven architecture experience with Snowflake (warehouse design, data modeling, performance tuning, governance/security).
• Strong hands-on AWS analytics/data services experience, especially integrating lake + warehouse and enabling governed access.

Core Technical Skills

• Snowflake: architecture patterns, security/governance, optimization, and operational best practices.
• AWS Data Analytics Services: working knowledge of how services integrate for governed access (Lake Formation with Athena/Glue/Redshift/EMR).
• Power BI: semantic model/dataset design and governance; ability to align BI layer with enterprise BI architecture principles.
• Amazon Bedrock: ability to solution GenAI workloads using Agents/Knowledge Bases and implement guardrails for safety.
• Strong SQL and data modeling (dimensional modeling, marts, analytical patterns).

Soft Skills

• Strong communication with both engineering teams and executive stakeholders; ability to explain architectural trade-offs clearly.

Pay and Benefits

Pay Range Minimum: $109000 per year

Pay Range Maximum: $161000 per year

HCLTech is an equal opportunity employer, committed to providing equal employment opportunities to all applicants and employees regardless of race, religion, sex, color, age, national origin, pregnancy, sexual orientation, physical disability or genetic information, military or veteran status, or any other protected classification, in accordance with federal, state, and/or local law. Should any applicant have concerns about discrimination in the hiring process, they should provide a detailed report of those concerns to [email protected] for investigation.

A candidate’s pay within the range will depend on their skills, experience, education, and other factors permitted by law. This role may also be eligible for performance-based bonuses subject to company policies. In addition, this role is eligible for the following benefits subject to company policies: medical, dental, vision, pharmacy, life, accidental death & dismemberment, and disability insurance; employee assistance program; 401(k) retirement plan; 10 days of paid time off per year (some positions are eligible for need-based leave with no designated number of leave days per year); and 10 paid holidays per year

How You’ll Grow

At HCLTech, we offer continuous opportunities for you to find your spark and grow with us. We want you to be happy and satisfied with your role and to really learn what type of work sparks your

brilliance the best. Throughout your time with us, we offer transparent communication with senior-level employees, learning and career development programs at every level, and opportunities to experiment in different roles or even pivot industries. We believe that you should be in control of your career with unlimited opportunities to find the role that fits you best.