Data Specialist

----------------------------------------

Key Responsibilities

* Design, build, and maintain scalable ETL/ELT data pipelines using DBT, SQL, and Python.
* Develop and optimize Snowflake-based data warehouse solutions for enterprise analytics and reporting.
* Create robust data models and transformation frameworks to support business requirements.
* Implement data ingestion, cleansing, transformation, and validation processes.
* Develop and maintain stored procedures, views, and database objects within cloud data platforms.
* Optimize SQL queries, data models, and pipelines for performance and scalability.
* Work closely with business stakeholders, analysts, and engineering teams to translate requirements into technical solutions.
* Monitor data quality and troubleshoot data-related issues across platforms.
* Leverage Snowflake features such as Snowpipe, Time Travel, Zero Copy Cloning, and Fail Safe.
* Participate in code reviews, testing, deployment, and documentation activities.
* Support data governance, security, and best practices across the data ecosystem.

----------------------------------------

Required Skills

Snowflake

* Strong hands-on experience with Snowflake Data Warehouse.
* Experience with:
* Snowpipe
* Zero Copy Cloning
* Time Travel
* Fail Safe
* SnowSQL
* Data Sharing/Data Exchange
* Performance tuning and optimization of Snowflake workloads.

DBT

* Strong expertise in DBT (Data Build Tool).
* Experience developing reusable transformation models.
* Understanding of DBT testing, documentation, and deployment practices.

SQL

* Advanced SQL skills with experience handling large-scale datasets.
* Expertise in query optimization, joins, analytical functions, and performance tuning.
* Experience with stored procedures and database development.

Python

* Strong Python programming skills for data processing and automation.
* Experience with data engineering frameworks and scripting.

Data Engineering

* Strong understanding of ETL/ELT concepts and modern data architectures.
* Experience in data warehousing and dimensional modeling.
* Knowledge of data governance, data quality, and metadata management.

----------------------------------------

Preferred Skills

* Experience with orchestration tools such as Airflow.
* Exposure to cloud platforms such as AWS, Azure, or GCP.
* Knowledge of CI/CD practices and Git-based version control.
* Experience with reporting and visualization tools such as Power BI, Tableau, or Looker.
* Exposure to AI/GenAI capabilities within data engineering solutions.

----------------------------------------

Educational Qualifications

* Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.

----------------------------------------

Preferred Certifications

* Snowflake SnowPro Certification
* DBT Certification
* AWS/Azure/GCP Data Engineering Certifications
* Databricks or Cloud Data Platform Certifications

----------------------------------------

Primary Skills

Snowflake, DBT, SQL, Python

Secondary Skills

Data Modeling, ETL/ELT, Airflow, AWS/Azure/GCP, Power BI/Tableau, Data Warehousing