Snowflake + Python + SQL Developer

Job Description:

We are seeking a skilled Snowflake + Python + SQL Developer with 4-6 years of experience to join our dynamic team. The ideal candidate should possess a strong background in cloud data platforms, Python programming, and SQL database management. Experience with DBT (Data Build Tool) is a plus but not mandatory.

Key Responsibilities:

1. Data Engineering & Management:
   • Design, implement, and manage data pipelines using Snowflake.
   • Develop and optimize complex SQL queries for data extraction, transformation, and reporting.
   • Handle large-scale data processing and integration using Python.
2. Data Modeling & Optimization:
   • Develop and maintain Snowflake data models and warehouse architecture.
   • Optimize data pipelines for performance and scalability.
3. Collaboration:
   • Work closely with cross-functional teams including data analysts, data scientists, and stakeholders to understand data needs and provide efficient solutions.
4. ETL Development:
   • Develop and maintain ETL/ELT processes to support data analytics and reporting.
   • Use Python scripts and Snowflake tools for data transformation and integration.
5. Performance Monitoring & Troubleshooting:
   • Monitor the performance of Snowflake databases, troubleshoot issues, and ensure data integrity.
   • Implement monitoring tools and processes to ensure the reliability of data systems.
6. DBT (Optional but Good to Have):
   • Leverage DBT for transforming data within Snowflake, if applicable.
   • Develop and maintain DBT models for improving the quality of data transformations.

Key Skills and Qualifications:

1. Must-Have:
   • 4-6 years of hands-on experience with Snowflake, Python, and SQL.
   • Strong understanding of SQL databases, relational database management systems (RDBMS), and data modeling concepts.
   • Experience in building scalable data pipelines and ETL/ELT processes using Python and Snowflake.
   • Knowledge of data warehousing best practices, including performance optimization and data governance.
2. Good to Have:
   • Experience with DBT (Data Build Tool) or similar data transformation frameworks.
   • Familiarity with cloud platforms such as AWS, Azure, or GCP.
   • Understanding of version control systems such as Git.