Snowflake Data Engineer - R01568220

Reposted 3 Months Ago
Be an Early Applicant
2 Locations
Hybrid
Senior level
Information Technology
The Role
Lead Snowflake data engineering: design scalable pipelines, migrate legacy warehouses to Snowflake, build DBT ELT frameworks, orchestrate Airflow workflows, implement data models and validation, optimize Snowflake objects, provide L3 production support and perform code reviews and runbook creation.
Summary Generated by Built In

As a Data Engineer at Brillio, you will be at the forefront of building robust, scalable data architectures that power complex business intelligence and AI initiatives. You will work closely with cross-functional teams, including AI/ML engineers and product stakeholders, to transform raw data into reliable, high-quality assets. Your day-to-day will involve architecting sophisticated data pipelines, implementing advanced modeling techniques, and ensuring the seamless flow of information across the enterprise, directly influencing the data-driven decision-making capabilities of our clients.

 

Primary Skills

  • Snowflake, Airflow, DBT
  • SQL
  • Python/PySpark
  • ETL
  • CDC

Specialization

  • Snowflake 
  • SnowPro

Job requirements

    Key Responsibilities

    Project Type: L3 Support

    Flexibility to shift working is Mandatory.

    Development Responsibilities

  • Design and develop scalable data pipelines and modern data architectures using Snowflake.
  • Lead migration initiatives from legacy databases to Snowflake.
  • Build and optimize ELT frameworks using DBT.
  • Develop and orchestrate workflows using Apache Airflow.
  • Design and implement data models, including Star Schema and Snowflake Schema.
  • Develop ingestion pipelines for structured and semi-structured data.
  • Create reusable frameworks for data validation, reconciliation, auditing, and monitoring.
  • Optimize Snowflake objects, including:
  • Virtual Warehouses
  • Clustering Keys
  • Materialized Views
  • Streams & Tasks
  • Dynamic Tables
  • Develop technical design documents and migration runbooks.
  • Perform code reviews and enforce engineering best practices.
  • Migration Responsibilities

  • Assess and migrate data from legacy platforms, including:
  • Oracle
  • SQL Server
  • Teradata
  • Netezza
  • DB2
  • SAP HANA
  • On-Prem Data Warehouses
  • Perform source system analysis and database rationalization.
  • Design migration strategies, including:
  • Full Data Loads
  • Incremental Loads
  • CDC (Change Data Capture)
  • Historical Data Migration
  • Conduct data reconciliation and validation during migration.
  • Optimize transformed workloads for Snowflake architecture.
  • Execute cutover planning and post-migration stabilization.

  • Good to have:

    AMS / Production Support Responsibilities

  • Provide L3 support for Snowflake data platforms and pipelines.
  • Monitor and manage production data workloads.
  • Troubleshoot data failures, performance issues, and pipeline disruptions.
  • Perform root cause analysis (RCA) and implement permanent fixes.
  • Support incident, problem, change, and release management activities.
  • Work closely with business users and stakeholders to resolve production issues.
  • Ensure adherence to SLA and operational support commitments.
  • Participate in production releases and deployment activities.

Skills Required

  • Snowflake platform experience
  • Apache Airflow for workflow orchestration
  • DBT for ELT frameworks and transformations
  • Experience migrating data from Oracle, SQL Server, Teradata, Netezza, DB2, SAP HANA
  • Design and develop scalable data pipelines and modern data architectures
  • Data modeling including Star Schema and Snowflake Schema
  • Implement CDC, incremental and full data loads, and historical data migration
  • Develop data validation, reconciliation, auditing, and monitoring frameworks
  • Optimize Snowflake objects (Virtual Warehouses, Clustering Keys, Materialized Views, Streams & Tasks, Dynamic Tables)
  • L3/production support: monitor workloads, troubleshoot failures, perform RCA and fixes
  • Create technical design documents, migration runbooks, perform code reviews, enforce engineering best practices
  • Flexibility to work shift schedules (mandatory)

Brillio Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Brillio and has not been reviewed or approved by Brillio.

  • Healthcare Strength — Healthcare is considered comprehensive, including medical coverage for employees and dependents alongside life, disability, and accidental death protections. Feedback suggests these protections are a core strength of the package.
  • Leave & Time Off Breadth — Time-off options include paid leave and parental leave, with flexible or ‘flexible PTO’ approaches cited in some contexts. Feedback suggests this breadth helps support work-life balance when team norms permit usage.
  • Wellbeing & Lifestyle Benefits — Wellbeing offerings span counseling, financial-management sessions, fitness programs, and travel insurance, plus region-specific extras like discounted IT hardware and work-from-home essentials. Feedback suggests these add-ons enhance perceived value beyond core insurance.

Brillio Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Santa Clara, CA
2,676 Employees
Year Founded: 2014

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.

Similar Jobs

Remote or Hybrid
2 Locations
289097 Employees

Pfizer Logo Pfizer

GSC Quality Management System Lead

Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
In-Office or Remote
9 Locations
121990 Employees
215K-358K Annually

CSC Logo CSC

Accountant

Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
Remote or Hybrid
2 Locations
8500 Employees

The Aerospace Corporation Logo The Aerospace Corporation

Sr Software Eng Manager

Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Remote or Hybrid
2 Locations
4600 Employees

Similar Companies Hiring

NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity • Defense • Defense Technology
Austin, TX
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
567 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account