Snowflake Architect (Datastage, DBT, ETL, SSIS) - R01562351

Sorry, this job was removed at 08:10 p.m. (UTC) on Thursday, Mar 26, 2026
Hiring Remotely in Edison, NJ, USA
In-Office or Remote
150K-160K Annually
Information Technology
The Role
About Brillio:

Brillio is one of the fastest growing digital technology service providers and a partner of choice for many Fortune 1000 companies seeking to turn disruption into a competitive advantage through innovative digital adoption. Brillio, renowned for its world-class professionals, referred to as "Brillians", distinguishes itself through their capacity to seamlessly integrate cutting-edge digital and design thinking skills with an unwavering dedication to client satisfaction.
Brillio takes pride in its status as an employer of choice, consistently attracting the most exceptional and talented individuals due to its unwavering emphasis on contemporary, groundbreaking technologies, and exclusive digital projects. Brillio's relentless commitment to providing an exceptional experience to its Brillians and nurturing their full potential consistently garners them the Great Place to Work® certification year after year.

Principal Architect

Primary Skills

  • ETL Fundamentals, Zero Copy Cloning, SQL, SnowSight, SQL (Basic + Advanced), Python, Data Warehousing, Snowflake Data Exchange, Time Travel and Fail Safe, Snowpipe, SnowSQL, Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures

Specialization

  • Snowflake Data Architecture: Data Architect

Job requirements

  • Architect

    Role Purpose

    Lead the design and execution of enterprise data platform modernization, migrating legacy systems (Informatica, DataStage, SSIS, Oracle, SQL Server) to a scalable, secure Snowflake ecosystem.

     

    REQUIREMENTS:

    • Minimum 12–15+ years of experience in data architecture, data engineering, or solution architecture, with focus on enterprise data platforms and migrations
    • Proven experience in customer-facing roles (solution engineering / consulting / architecture) working with large enterprise or global accounts
    • Strong expertise in legacy-to-cloud migration, specifically:
      • Informatica / DataStage / SSIS
      • Oracle / SQL Server / legacy data warehouses → Snowflake
      • Deep competency in modern data stack:
        • ETL/ELT, Data Warehouse / Lakehouse architectures
        • Snowflake platform (architecture, performance tuning, cost optimization)
        • Strong hands-on expertise with SQL (advanced) and working knowledge of Python
        • Experience designing and implementing data models (Star schema, Data Vault, or similar)
        • Solid understanding of cloud platforms (AWS preferred) and integration patterns
        • Experience with workflow orchestration tools (e.g., Airflow) and modern ELT frameworks (e.g., dbt)
        • Strong understanding of data governance, security, and enterprise compliance frameworks
        • Ability to present effectively to both:
          • Executive stakeholders (CIO/CTO/CDO level)
          • Deep technical audiences (engineering teams)
          • Experience working within enterprise ecosystems, GSIs, or Global Capability Centers
          • Strong communication skills with ability to articulate business value and technical solutions clearly
          • Industry experience in BFSI, Healthcare, Manufacturing, or Technology domains
          •  

            ADDED BONUS FOR:

            • Experience with Snowflake advanced features (Streams, Tasks, Snowpipe, UDFs)
            • Familiarity with migration automation tools (e.g., SnowConvert, Informatica Cloud)
            • Exposure to AI/ML or advanced analytics workloads on Snowflake
            • Experience with BI and visualization tools (Tableau, Power BI, etc.)
            • Multi-cloud experience (AWS / Azure / GCP)
            • Relevant certifications:
              • Snowflake (SnowPro Core / Advanced)
              • AWS Solutions Architect
              • Experience building enterprise data architecture frameworks or accelerators

 
Know what it’s like to work and grow at Brillio: Click here

Brillio Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Brillio and has not been reviewed or approved by Brillio.

  • Healthcare Strength Healthcare is considered comprehensive, including medical coverage for employees and dependents alongside life, disability, and accidental death protections. Feedback suggests these protections are a core strength of the package.
  • Leave & Time Off Breadth Time-off options include paid leave and parental leave, with flexible or ‘flexible PTO’ approaches cited in some contexts. Feedback suggests this breadth helps support work-life balance when team norms permit usage.
  • Wellbeing & Lifestyle Benefits Wellbeing offerings span counseling, financial-management sessions, fitness programs, and travel insurance, plus region-specific extras like discounted IT hardware and work-from-home essentials. Feedback suggests these add-ons enhance perceived value beyond core insurance.

Brillio Insights

Similar Jobs

GRAIL Logo GRAIL

Health System Partnerships Associate Director # 4931 (Western U.S.)

Artificial Intelligence • Big Data • Healthtech • Machine Learning • Software • Biotech
Remote or Hybrid
United States
918 Employees
146K-194K Annually

GRAIL Logo GRAIL

Health System Partnerships Associate Director # 4932 (Eastern U.S.)

Artificial Intelligence • Big Data • Healthtech • Machine Learning • Software • Biotech
Remote or Hybrid
United States
918 Employees
146K-194K Annually

Inato Logo Inato

Head Of Marketing

Artificial Intelligence • Greentech • Healthtech • Social Impact • Software • Biotech • Pharmaceutical
In-Office or Remote
13 Locations
63 Employees
230K-250K Annually

Coinbase Logo Coinbase

Strategic Intelligence Manager, Protective Intelligence

Artificial Intelligence • Blockchain • Fintech • Financial Services • Cryptocurrency • NFT • Web3
Easy Apply
Remote
USA
4700 Employees
166K-196K Annually
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Santa Clara, CA
2,676 Employees
Year Founded: 2014

What We Do

Brillio is the leader in global digital business transformation, applying technology with a human touch. We help businesses define internal and external transformation objectives, and translate those objectives into actionable market strategies using proprietary technologies. With 2600+ experts and 13 offices worldwide, Brillio is the ideal partner for enterprises that want to quickly increase their core business productivity, and achieve a competitive edge, with the latest digital solutions.

Similar Companies Hiring

Standard Template Labs Thumbnail
Artificial Intelligence • Information Technology • Software
New York, NY
25 Employees
NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity
Sydney, AU
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account