Senior Data Engineer – Snowflake & Dbt

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