The Role
The Senior Data Engineer will design and maintain ELT/ETL data pipelines for Snowflake, optimize SQL queries, and create data models for analytics.
Summary Generated by Built In
Senior 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
Job requirements
- Design, develop, and maintain robust ELT/ETL data pipelines to load structured and semi-structured data into Snowflake. Implement data ingestion workflows using tools like Azure Data Factory, Informatica, DBT, or custom Python/SQL scripts.
- Write and optimize complex SQL queries, stored procedures, views, and UDFs within Snowflake.
- Use Snowpipe for continuous data ingestion and manage tasks, streams, and file formats for near real-time processing Optimize query performance using techniques like clustering keys, result caching, materialized views, and pruning strategies. Monitor and tune warehouse sizing and usage to balance cost and performance.
- Design and implement data models (star, snowflake, normalized, or denormalized) suitable for analytical workloads.
- Create logical and physical data models for reporting and analytics use cases.
Top Skills
Azure Data Factory
Data Warehousing
Datastream
Dbt
ETL
Informatica
Python
Snowflake
SQL
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
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.
