Brillio

Snowflake Developer - R01568220

Brillio$100K — $130K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 5-7 years of experience in data engineering and pipeline development.
  • Expertise in Snowflake and its optimization techniques.
  • Proficiency with DBT for data transformation tasks.
  • Familiarity with Apache Airflow for workflow orchestration.
  • Experience migrating from legacy databases like Oracle and SQL Server.
  • Ability to design modern data architectures and schemas.
  • Strong problem-solving skills, particularly in data reconciliation and validation.

Responsibilities

  • Design and develop scalable data pipelines using Snowflake.
  • Lead migration from legacy databases to Snowflake.
  • Build and optimize ELT frameworks with DBT.
  • Orchestrate workflows using Apache Airflow.
  • Implement data models including Star and Snowflake Schema.
  • Create reusable frameworks for data validation and monitoring.
  • Provide L3 support for Snowflake platforms and resolve production issues.

Benefits

  • Flexible working hours to accommodate different schedules.
  • Opportunity to work on modern data architectures and technologies.
  • Chance to lead significant migration initiatives from legacy systems.
  • Work in a collaborative environment with business stakeholders.
  • Participation in project management and operational activities.
Full Job Description
Data Specialist
Primary Skills
  • Snowflake, Airflow, DBT
Specialization
  • Snowflake Lead Developer
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.

About Brillio

Brillio is a technology consulting and technology services company focused on the implementation of digital technologies.

Brillio Careers

There has never been a more opportune time to join Brillio—the forefront of innovation and digital transformation.

Opportunities Await

Brillio offers a plethora of job opportunities aimed at harnessing the potential of professionals eager to drive change. With a focus on technology and consulting, Brillio is not just a company; it's a vibrant ecosystem conducive to growth and professional development.

Transform Your Career

Embark on a journey of growth and leadership at Brillio. This is where industry expertise meets digital innovation to transform businesses and industries. Brillio stands out in the marketplace, providing a unique blend of technology solutions and strategic insights.

Join a Diverse and Inclusive Team

Brillio is committed to diversity and inclusion, ensuring a wide range of perspectives that fuel innovation and creative solutions. The team at Brillio, enriched with diverse skills and backgrounds, collaborates to deliver excellence and drive success.

Internship Programs and Employment

Kickstart your career with Brillio's internship programs, designed to offer hands-on experience and a gateway to full-time employment. Brillio is dedicated to nurturing young talent, providing them with the necessary tools and guidance to excel.

Innovate and Lead

At Brillio, every team member is an innovator and leader. The company fosters a culture of continuous learning and improvement, encouraging each individual to push boundaries and contribute to groundbreaking projects.

Networking and Professional Development

Networking at Brillio opens doors to influential connections, mentorship, and collaborative opportunities. Brillio supports career advancement through professional development, offering training in leadership, diversity, and specific job skills.

Benefits and Culture

Brillio is known for its dynamic culture and the comprehensive benefits it offers. Team members enjoy a supportive environment that values their well-being and professional growth.

Explore Job Positions

Brillio is hiring! Explore the various positions available that match your skills and interests. Brillio seeks passionate, curious, and solution-driven professionals ready to make an impact.

Prepare for Your Interview

Brillio helps candidates succeed by providing resources on how to effectively prepare your resume and ace the interview process. Stand out as a prospective employee by demonstrating your knowledge and enthusiasm for Brillio's mission.

Stay Connected with Brillio Careers

Keep up to date with career tips, industry insights, and the latest job openings at Brillio. Personalize your job search and stay informed about new and exciting opportunities within the company.

APPLY TO BRILLIO JOBS

Read Careers Blog

Stay ahead in your career with insights from Brillio's experts. Discover articles and advice tailored to advancing your career and enhancing your professional journey.

Job Alert Emails

Subscribe to receive customized job alerts and the latest news from Brillio. Discover the rewarding career opportunities that await and how Brillio can be the key to your professional future.
Learn more about Brillio
Industry
Founded
2014

Similar Jobs

More Jobs at Brillio

More Information Technology Jobs

Find similar Snowflake Developer - R01568220 jobs: