Snowflake Architect (Datastage, DBT, ETL, SSIS) R
Share
Job Location:
Edison, NJ - USA
Monthly Salary:
Not Disclosed
Posted on:
3 days ago
Vacancies:
1 Vacancy
Job Summary
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 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. Brillios 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 1215 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
$150000 - $160000 a year
Know what its like to work and grow at Brillio: Click here
We may use artificial intelligence (AI) tools to support parts of the hiring process such as reviewing applications analyzing resumes or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed please contact us.
Required Experience:
Staff IC
Key Skills
About Company
Brillio is a global leader in Enterprise Digital Transformation Solutions, providing strategic consulting services and solutions using emerging technologies.
