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

Brillio 2

Edison, New Jersey, United States Remote permanent

Posted: March 11, 2026

Required Skills

Job Description

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

Why Apply Through MisuJob?

AI-Powered Job Matching: MisuJob uses advanced artificial intelligence to analyze your skills, experience, and career goals. Our matching algorithm compares your profile against thousands of job requirements to find positions where you have the highest chance of success. This saves you hours of manual job searching and ensures you only see relevant opportunities.

One-Click Applications: Once you create your profile, applying to jobs is effortless. Your resume and cover letter are automatically tailored to highlight the most relevant experience for each position. You can apply to multiple jobs in minutes, not hours.

Career Intelligence: Beyond job matching, MisuJob provides valuable career insights. See how your skills compare to market demands, identify skill gaps to address, and understand salary benchmarks for your experience level. Make data-driven decisions about your career path.

Frequently Asked Questions

How do I apply for this position?

Click the "Register to Apply" button above to create a free MisuJob account. Once registered, you can apply with one click and track your application status in your dashboard.

Is MisuJob free for job seekers?

Yes, MisuJob is completely free for job seekers. Create your profile, get matched with jobs, and apply without any cost. We help you find your dream job without any hidden fees.

How does AI matching work?

Our AI analyzes your resume, skills, and experience to understand your professional profile. It then compares this against job requirements using natural language processing to calculate a match percentage. Higher matches mean better fit for the role.

Can I apply to jobs in other countries?

Absolutely. MisuJob features jobs from companies worldwide, including remote positions. Filter by location or look for remote opportunities to find jobs that match your preferences.

Ready to Apply?

Join thousands of job seekers using MisuJob's AI to find and apply to their dream jobs automatically.