Brillio is one of the fastest growing digital technology service providers and a partner of choice for many Fortune 1000 companies. They are seeking a Senior Lead Data Engineer who will be responsible for designing, migrating, and optimizing ETL pipelines across large-scale enterprise systems.
Responsibilities:
- Extensive ETL/ELT Experience in data engineering with expertise in ETL pipeline design, migration, and optimization across large-scale enterprise systems
- Hands-on experience in migrating workloads to Snowflake, optimizing performance with clustering/partitioning, and working with AWS, Azure, and GCP ecosystems
- Strong SQL proficiency with experience in Snowflake and DB2, building optimized queries, transformations, and data warehouse models
- Migrated legacy ETL processes to IBM DataStage and has practical experience in SSIS (SQL Server Integration Services), aligning well with required tools
- Worked with SAS scripts and statistical models in financial/AML environments, integrating them into Snowflake pipelines to support compliance and analytics needs
Requirements:
- Extensive ETL/ELT Experience in data engineering with expertise in ETL pipeline design, migration, and optimization across large-scale enterprise systems
- Snowflake & Cloud Data Warehousing – Hands-on experience in migrating workloads to Snowflake, optimizing performance with clustering/partitioning, and working with AWS, Azure, and GCP ecosystems
- Strong SQL proficiency with experience in Snowflake and DB2, building optimized queries, transformations, and data warehouse models
- Migrated legacy ETL processes to IBM DataStage and has practical experience in SSIS (SQL Server Integration Services), aligning well with required tools
- Worked with SAS scripts and statistical models in financial/AML environments, integrating them into Snowflake pipelines to support compliance and analytics needs