Data Base Engineer

Job Summary:

We are seeking a skilled Data Engineer with 7-12 years of experience to design, build, and maintain robust data pipelines and analytics solutions. The ideal candidate will have hands-on expertise in Snowflake, DBT, SQL, and be well-versed in modern data engineering practices including GitHub, CI/CD, and Agile methodologies.

Key Responsibilities:

· Develop and maintain scalable data pipelines using Snowflake and DBT.

· Design and implement ETL/ELT processes for structured and semi-structured data.

· Collaborate with data analysts, scientists, and business stakeholders to understand data needs.

· Ensure data quality, integrity, and security across all data assets.

· Participate in Agile ceremonies and contribute to sprint planning and retrospectives.

· Use GitHub for version control, code reviews, and CI/CD deployments.

· Document data workflows, architecture, and business logic clearly.

Must-Have Skills:

Snowflake

· Develop and manage Snowflake objects: tables, views, functions, stored procedures, stages, and file formats.

· Implement advanced features: CDC, Streams, Snowpipe, Time Travel, and Cloning.

· Write dynamic SQL and utilize Python/JavaScript within Snowflake for data processing.

· Work with semi-structured data (JSON/XML), APIs, and tools like Postman for integration and validation.

· Build Dynamic Tables, Materialized Views, and Tasks for scalable workflows.

· Strong experience in performance tuning, access control, and data governance.

DBT (Data Build Tool)

· Build modular SQL models across staging, intermediate, and mart layers.

· Hands-on with incremental models, DBT tests, and Jinja templating/macros.

· Exposure to DBT documentation, lineage graphs, and environment configuration.

· Integrate DBT with GitHub and deploy via CI/CD pipelines.

Python

· Scripting for data transformation, automation, and API integrations.

· Familiarity with libraries like Pandas, NumPy, and SQLAlchemy.

Nice-to-Have Skills:

· SnapLogic – Experience in building and managing integrations using SnapLogic pipelines.

· Power BI – Ability to create dashboards and visualizations for business insights.