Senior Data Engineer - Data Build Tool/Snowflake DB

Description : We are looking for a skilled and experienced DBT-Snowflake Developer to join our team! As part of the team, you will be involved in the implementation of the ongoing and new initiatives for our company. If you love learning, thinking strategically, innovating, and helping others, this job is for you!

Primary Skills : Snowflake, DBT

Role Description : We are looking for a Senior Data Engineer to lead the design, development, and management of scalable data platforms and pipelines. This role demands a strong technical foundation in data architecture, big data technologies, and database systems (both SQL and NoSQL), along with the ability to work across functional teams to deliver robust, secure, and high-performing data solutions.

Role Responsibility :

- Design, develop, and maintain end-to-end data pipelines and infrastructure.

- Translate business and functional requirements into scalable, well-documented technical solutions.

- Build and manage data flows across structured and unstructured data sources, including streaming and batch integrations.

- Ensure data integrity and quality through automated validations, unit testing, and robust documentation.

- Optimize data processing performance and manage large datasets efficiently.

- Monitor and optimize ETL workflows to ensure performance, scalability, and reliability.

- Collaborate closely with stakeholders and project teams to align data solutions with business objectives.

- Implement and maintain security and privacy protocols to ensure safe data handling.

- Lead development environment setup and configuration of tools and services.

- Mentor junior data engineers and contribute to continuous improvement and automation initiatives.

- Coordinate with QA and UAT teams during testing and release phases.

Role Requirement :

- Strong proficiency in SQL (including procedures, performance tuning, and analytical functions).

- Solid understanding of data warehousing concepts, including dimensional modeling and SCDs.

- Hands-on experience with scripting languages (Shell / PowerShell).

- Familiarity with Cloud and Big data technologies.

- Experience working with relational, non-relational databases, and data streaming systems.

- Proficiency in data profiling, validation, and testing practices.

- Excellent problem-solving, communication (written and verbal), and documentation skills.

- Exposure to Agile methodologies and CI/CD practices.

- Self-motivated, adaptable, and capable of working in a fast-paced environment.

Additional Requirement :

- Design, develop, and maintain scalable data models and transformations using DBT in conjunction with Snowflake, ensuring the effective transformation and loading of data from diverse sources into the data warehouse or data lake.

- Implement and manage data models in DBT, guarantee accurate data transformation and alignment with business needs.

- Utilize DBT to convert raw, unstructured data into structured datasets, enabling efficient analysis and reporting.

- Write and optimize SQL queries within DBT to enhance data transformation processes and improve overall performance.

- Establish best DBT processes to improve performance, scalability, and reliability.

- Expertise in SQL and a strong understanding of Data Warehouse concepts and Modern Data Architectures.

- Familiarity with cloud-based platforms (e.g., AWS, Azure, GCP).

- Migrate legacy transformation code into modular DBT data models