Note: The job is a remote job and is open to candidates in USA. Gala Solutions is seeking an experienced Senior Data Engineer to join its Enterprise Data Hub team. The role is responsible for designing, developing, supporting, and enhancing enterprise-scale data pipelines and platforms using AWS, Snowflake, DBT, and PySpark, while collaborating with engineering and DevOps teams on architecture, deployment, monitoring, and data quality.
Responsibilities
- Design, develop, and support enterprise data pipelines using AWS, Snowflake, and DBT
- Develop and enhance metadata-driven data ingestion and transformation frameworks
- Work with AWS services to build scalable data ingestion solutions
- Implement enterprise-scale solutions using Snowflake, including database design, data loading, data transformation, security, performance optimization, and operational support
- Build dimensional models, star schema, snowflake schema, fact and dimension tables, and data structures optimized for analytics and reporting
- Develop DBT models, macros, tests, and deployment configurations
- Troubleshoot and debug data pipeline issues across AWS, Snowflake, dbt, and PySpark, perform root cause analysis, and implement solutions
- Support EDH production deployments, monitoring, and issue resolution
- Collaborate with offshore engineering teams and provide technical guidance and code reviews
- Participate in architecture discussions and recommend improvements to platform design
- Work with DevOps teams on CI/CD processes, Git-based development, deployment automation, and release management
- Implement data quality checks, validation frameworks, logging, and operational monitoring
Skills
- 10+ years of data engineering experience
- Strong hands-on experience building enterprise-scale data platforms, working with AWS, Snowflake cloud-based data engineering solutions, and supporting complex data integration and transformation processes
- Comfortable working independently, collaborating with offshore teams, and providing technical guidance
- Strong hands-on data engineering experience with AWS data services
- Strong hands-on experience with Snowflake architecture, development
- Designing data warehouse solutions using Snowflake
- Strong hands-on experience with DBT development
- Experience developing PySpark applications for data ingestion and cleansing
- Experience with deployment automation, release management, and
- Environment promotion processes
- Experience designing dimensional data models (Facts, Dimensions)
- Transformation, and optimization in cloud-based data platforms
- Strong SQL skills including complex queries, performance tuning, and optimization
Company Overview