Job Description
This a Full Remote job, the offer is available from: New Jersey (USA)
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.
Lead Data Engineer
- Primary Skills
- DataStream, ETL Fundamentals, SQL, SQL (Basic + Advanced), Python, Data Warehousing, Time Travel and Fail Safe, Snowpipe, SnowSQL, Modern Data Platform Fundamentals, PLSQL, T-SQL, Stored Procedures
- Specialization
- Snowflake Engineering: Data Engineer
- Job requirements
- Snowflake Developer (Senior / Lead Data Engineer)
- REQUIREMENTS:
- Minimum 8–12+ years of experience in data engineering, ETL/ELT development, and data platform implementations
- Strong hands-on experience with legacy ETL tools:
- Informatica / DataStage / SSIS
- Proven experience working with:
- Oracle / SQL Server and migrating to Snowflake
- 3–5+ years of hands-on Snowflake experience (development, optimization, data loading)
- Strong competency in modern data stack:
- ELT frameworks (dbt preferred)
- Data warehouse / Lakehouse architectures
- Advanced expertise in SQL (complex queries, performance tuning, optimization)
- Hands-on experience with:
- Snowflake stored procedures, UDFs, Streams, Tasks, Snowpipe
- Proficiency in Python for data processing, automation, and API integrations
- Experience integrating Snowflake with:
- External systems via APIs / scripting
- Familiarity with cloud platforms (AWS preferred):
- S3, Lambda, and related services
- Experience with workflow orchestration tools (e.g., Airflow)
- Strong understanding of data validation, reconciliation, and data quality frameworks
- Experience working in enterprise-scale migration or transformation programs
- Ability to communicate effectively with both technical and non-technical stakeholders
- ADDED BONUS FOR:
- Experience with real-time / streaming ingestion frameworks
- Familiarity with CI/CD and DataOps practices
- Exposure to BI and visualization tools (Tableau, Power BI, etc.)
- Understanding of data modeling techniques (Star schema, Data Vault)
- Experience with performance tuning and cost optimization in Snowflake
- Multi-cloud exposure (AWS / Azure / GCP)
- Relevant certifications:
- Snowflake SnowPro
- Cloud certifications (AWS/Azure)
Know what it’s like to work and grow at Brillio: Click here
This offer from "Brillio" has been enriched by Jobgether.com and got a 73% flex score.
Apply tot his job
Apply To this Job