Data Architect

Intellectt Inc

Union Beach (NJ)

On-site

USD 120,000 - 150,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Intellectt Inc is seeking a seasoned data architect to own the architecture for cloud data platforms, focusing on Snowflake and AWS analytics services. The role requires over 10 years of expertise in data architecture and a strong background in ETL/ELT pipelines.

The successful candidate will design and govern data solutions, ensuring performance and security compliance while leading architecture reviews and mentoring teams. This role is essential for driving innovative data strategies in the organization.

Qualifications

  • 10+ years in data platform/analytics architecture or equivalent.
  • Proven Snowflake architecture experience.
  • Hands-on AWS analytics/data services expertise.

Responsibilities

  • Own end-to-end architecture for cloud data platforms.
  • Design Lakehouse/Medallion architectures and integration.
  • Lead architecture reviews and ensure non-functional requirements are met.

Skills

Data platform architecture
Snowflake expertise
AWS analytics services
ETL pipelines

Tools

Snowflake
AWS
Power BI

Job description

  • 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.
  • 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.
  • 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).
  • 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.
  • 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).
  • 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)
  • 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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Architect (AWS, Snowflake)
Data Architect (AWS, Snowflake)

DigiEx Group • United States

Remote
USD 120,000 - 180,000
Data Solutions Lead
Data Solutions Lead

Adactin Software • United States

Remote
USD 140,000 - 210,000
Data Architect (Advanced)
Data Architect (Advanced)

SGS Technologie • Tallahassee (FL)

On-site
USD 110,000 - 150,000
Enterprise Data Architect
Enterprise Data Architect

Paladin Consulting • Dallas (TX)

On-site
USD 180,000 - 240,000
Data Architect
Data Architect

Capital Technology Alliance • Tallahassee (FL)

On-site
USD 130,000 - 160,000
Health insurance
401(k) retirement plan
Flexible working hours
Snowflake Architect
Snowflake Architect

Cognizant Technology Solutions Corporation • Missouri

On-site
USD 140,000 - 200,000
Snowflake developer and Data Architect
Snowflake developer and Data Architect

Prophecy Technologies Corp • New York (NY)

Hybrid
USD 140,000 - 190,000
Aws Data Architect
Aws Data Architect

Neshent Technologies • Atlanta (GA)

On-site
USD 140,000 - 190,000
Senior Data Architect Snowflake & Cloud Data Platforms
Senior Data Architect Snowflake & Cloud Data Platforms

Tranzeal, Inc. • Sacramento (CA)

On-site
USD 170,000 - 230,000
Snowflake Architect - 2nd Stage
Snowflake Architect - 2nd Stage

5 Star Recruitment • Dallas (TX)

On-site
USD 130,000 - 160,000