Snowflake Developer

About the role

Brillio 2 is hiring a Snowflake Lead Developer to manage complex data migrations and maintain high-performance data pipelines. This role focuses on building modern architectures while providing L3 support for production environments.

Key facts

What you'll do

• Architect and build scalable data pipelines within the Snowflake ecosystem.
• Execute end-to-end migrations from legacy databases to Snowflake.
• Create and refine ELT processes using DBT.
• Manage workflow orchestration through Apache Airflow.
• Construct data models using Star and Snowflake schemas.
• Build ingestion pipelines for both structured and semi-structured information.
• Develop standardized frameworks for data monitoring, auditing, reconciliation, and validation.
• Tune Snowflake performance by managing virtual warehouses, clustering keys, materialized views, streams, tasks, and dynamic tables.
• Produce migration runbooks and technical design documentation.
• Conduct peer code reviews to maintain engineering standards.
• Perform source system analysis and database rationalization for platforms including Oracle, SQL Server, Teradata, Netezza, DB2, SAP HANA, and on-prem warehouses.
• Design migration strategies covering full loads, incremental updates, CDC, and historical data movement.
• Handle cutover planning and stabilize systems after migration.

Requirements

• Flexibility to work in shifts is mandatory.
• Experience with L3 support for data platforms and pipelines.
• Capability to monitor production workloads and resolve performance bottlenecks.
• Ability to perform root cause analysis and implement long-term technical fixes.
• Experience managing incident, change, release, and problem management lifecycles.
• Proficiency in communicating with business stakeholders to address production needs.
• Commitment to meeting SLA and operational support targets.
• Experience participating in production deployment activities.

Skills & tools

• Snowflake
• Airflow
• DBT