Job Description
Open Position: Senior Data Engineer – Snowflake & Dbt
Company: Bilight Solutions LLP
Location: Chennai
Employment Type: Full-Time | Permanent
Experience: 5+ Years
Work Mode: Work from Office
Shift: Australian Shift (Sydney/Melbourne Time Zone)
Compensation: Based on interview performance
About Bilight Solutions
Bilight Solutions is a fast-growing Business Intelligence and Data Analytics company specializing in transforming raw data into actionable business insights through AI-driven data solutions. We deliver innovative BI, analytics, and data engineering solutions that empower organizations to make informed business decisions.
We are looking for an experienced Senior Data Engineer – Snowflake & dbt to join our growing Data Engineering team. The ideal candidate will have strong expertise in Snowflake, dbt, SQL, and Azure data services, with hands-on experience in enterprise data warehouse development, migration, and consolidation initiatives.
Key Responsibilities
- Design, build, and maintain ELT pipelines to ingest data into Snowflake from Azure Synapse, on-premises SQL Server, and enterprise applications.
- Develop and maintain dbt models across staging, intermediate, and mart layers.
- Apply dimensional modeling practices and establish consistent business definitions across integrated data sources.
- Support the migration and consolidation of existing Azure Synapse and SQL Server workloads into Snowflake.
- Refactor transformation logic, reconcile outputs, and validate data against legacy reports.
- Build and manage data orchestration workflows using Azure Data Factory, dbt scheduling, and Snowflake-native capabilities.
- Deliver curated, well-documented datasets and semantic models to support Power BI reporting.
- Prepare trusted, AI-ready datasets to support enterprise AI initiatives.
- Implement data quality tests, documentation, and lineage using dbt.
- Contribute to data governance, role-based access control, and Snowflake performance and cost optimization.
- Follow Git-based version control, code review, and CI/CD practices.
- Collaborate with data, analytics, and architecture teams and maintain clear technical documentation.
Required Skills
- Strong hands-on experience with Snowflake, including warehouse design, RBAC, performance tuning, and cost optimization.
- Experience with dbt Core and/or dbt Cloud.
- Strong knowledge of dimensional modeling, preferably Kimball methodology.
- Advanced SQL skills, including T-SQL and Snowflake SQL.
- Experience with Azure Synapse Analytics.
- Hands-on experience with Azure Data Factory and data orchestration.
- Understanding of Microsoft Azure services, including storage, networking, and security fundamentals.
- Experience working with Power BI datasets and semantic models.
- Proficiency in Git, CI/CD, and version control practices.
- Understanding of data quality frameworks, data lineage, and access controls.
- Strong analytical, troubleshooting, and problem-solving skills.
Experience & Eligibility
- Minimum 5+ years of experience in Data Engineering.
- At least 2 years of hands-on experience delivering production workloads using Snowflake and dbt.
- Demonstrated experience migrating data warehouse workloads from Azure Synapse and/or SQL Server to Snowflake.
- Experience building enterprise data models integrating multiple source systems.
- Exposure to healthcare, aged care, financial services, or other regulated industries is an added advantage.
- Strong written and verbal communication skills.
- Ability to work independently and collaborate with international stakeholders.
Preferred Skills
- Python programming experience.
- Exposure to Azure OpenAI or enterprise AI-ready data solutions.
- Experience working with Australian stakeholders.
- Knowledge of data privacy, security, and responsible data management practices.
Preferred Certifications
- Snowflake SnowPro Core Certification.
- Snowflake SnowPro Advanced: Data Engineer.
- Dbt Analytics Engineering Certification.
- Microsoft Certified: Fabric Data Engineer Associate (DP-700).
- Microsoft Certified: Azure Data Engineer Associate (DP-203).
- Microsoft Certified: Power BI Data Analyst Associate (PL-300).
Benefits
- Health Insurance
- Provident Fund (PF)
- Paid Sick Leave
- Professional Growth and Learning Opportunities
- Exposure to Enterprise-Level Data Engineering Projects
- Collaborative and Employee-Friendly Work Environment
Interested candidates can share their updated resumes at:
Email: talentacquisition@bilightsolutions.com
Work Location: Chennai (Work from Office)
Work Location: In person
