Primary Skills
- DataStream, ETL Fundamentals, SQL, SQL (Basic + Advanced), Python, Data Warehousing, Time Travel and Fail Safe, Snowpipe, SnowSQL, Modern Data Platform Fundamentals, PLSQL, T-SQL, Stored Procedures
Specialization
- Snowflake Engineering: Data Engineer
Job requirements
- Job Summary
We are seeking a Senior Data Engineer with strong expertise in DBT, Python, and SQL to design, develop, and optimize scalable data pipelines and ETL processes. The ideal candidate will have hands-on experience working with modern data stacks, particularly Snowflake, and will play a key role in building reliable analytics and reporting solutions on cloud platforms.
This role demands strong problem-solving skills, deep understanding of data warehousing concepts, and the ability to collaborate closely with business stakeholders to translate requirements into robust technical solutions.
Key Responsibilities - Design, develop, and maintain DBT models, transformations, tests, and optimized SQL code for analytics and reporting use cases.
- Build and enhance scalable ETL/ELT pipelines using DBT and complementary data engineering tools.
- Write complex, high-performance SQL queries to process, analyze, and transform large datasets.
- Develop clean, efficient, and scalable code in Python, with strong hands-on experience using Pandas and NumPy.
- Optimize data pipelines for performance, scalability, and cost efficiency, especially in cloud-based data warehouses.
- Troubleshoot and resolve ETL failures, performance bottlenecks, and data quality issues.
- Develop and maintain scripts using Unix Shell scripting, Python, and related tools for data extraction, transformation, and loading.
- Write, tune, and support Snowflake SQL and contribute to Snowflake implementation and optimization initiatives.
- Work with workflow orchestration tools such as Apache Airflow (or similar platforms) to manage and monitor data pipelines.
- Integrate data solutions with user-facing applications where required.
- Collaborate with business, analytics, and technical stakeholders to gather requirements and deliver reliable, interpretable data solutions.
- Implement data validation, testing, and quality checks within DBT workflows to ensure accuracy and reliability. Required Skills & Qualifications
- 6+ years of overall IT experience, with strong focus on data engineering.
- Proven hands-on experience with DBT (Data Build Tool) including model development, transformations, and testing.
- Strong programming expertise in Python (mandatory).
- Advanced proficiency in SQL, including writing and optimizing complex queries on large datasets.
- Hands-on experience designing, building, and maintaining ETL/ELT pipelines.
- Experience with Unix/Linux shell scripting.
- Solid understanding of data warehousing concepts, dimensional modeling, and best practices. Preferred / Good-to-Have Skills
- Experience with Snowflake implementation, performance tuning, and cost optimization.
- Knowledge or hands-on exposure to Salesforce CDP.
- Experience using Airflow or other orchestration frameworks.
- Exposure to cloud platforms such as AWS, GCP, or Azure.
- Experience working with cloud storage solutions like Amazon S3, Google Cloud Storage (GCS), or Azure Blob Storage. Ideal Candidate Profile
- Strong analytical and problem-solving skills
- Comfortable working in fast-paced, data-driven environments
- Ability to own data pipelines end-to-end
- Strong collaboration and communication skills
Skills Required
- 6+ years of overall IT experience
- Hands-on experience with DBT including model development
- Strong programming expertise in Python
- Advanced proficiency in SQL
- Experience in designing and maintaining ETL pipelines
- Experience in Unix Shell scripting
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
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.
