2 months ago
Bengaluru, IndiaStaff+
Responsibilities
- Develop, maintain, and optimize dbt models, macros, tests, and scalable ETL/ELT data pipelines.
- Design and maintain dbt models across Bronze, Silver, and Gold medallion layers.
- Administer Snowflake warehouses, databases, schemas, roles, and security configurations.
- Optimize complex SQL queries, warehouse performance, processing times, and storage utilization.
- Manage AWS services including S3, Lambda, Secret Manager, IAM, and CloudWatch for cloud data infrastructure.
- Implement and maintain deployment and release automation pipelines for data solutions.
- Configure data quality checks, alerting, and performance monitoring.
- Troubleshoot production and pipeline issues, perform root cause analysis, and participate in on-call support.
- Collaborate with analytics, business intelligence, engineering, and data governance teams.
- Support downstream analytics platform consumers, including dashboards and data products.
- Document data lineage, model logic, and technical decisions.
- Maintain and develop APIs.
Requirements
- 8–10 years of experience in data engineering.
- Advanced proficiency in SQL.
- Expertise developing and managing dbt models, macros, and tests.
- Hands-on Snowflake data warehousing experience, including Time Travel and Fail Safe.
- Strong understanding of ETL/ELT fundamentals and best practices.
- Proficiency in Python for data engineering and automation.
- Experience administering Snowflake warehouses, databases, schemas, and role-based security.
- Experience managing AWS S3, Lambda, Secret Manager, IAM, and CloudWatch.
- Experience implementing and maintaining CI/CD pipelines for data deployments.
- Experience configuring monitoring, alerting, and data quality checks in cloud data platforms.
- Preferred experience with modern data platform architecture and large-scale pipeline optimization.
- Preferred familiarity with data governance, compliance, infrastructure-as-code, and advanced Snowflake features such as data sharing and secure data exchange.
- Bachelor’s or Master’s degree in Computer Science, Information Technology, Engineering, or a related field is a desired qualification.
- AWS, Snowflake, or dbt industry certifications are highly desirable.
About Brillio
Brillio is a privately held digital engineering and enterprise AI services firm that helps Fortune 1000 companies modernize products, data, and infrastructure. It combines consulting and managed services with an accelerator platform (ADAM) across cloud, AI, data engineering, customer experience, and infrastructure workstreams. Founded in 2014 and headquartered in Dallas, it operates delivery centers across North America, Europe, and Asia, with focus areas that include healthcare and life sciences.