Role Overview:
We are seeking a skilled SQL + Python Developer to join our dynamic team. This role involves a mix of database development, administration, and data engineering tasks. The ideal candidate will have a strong background in SQL, PL/SQL, and Python scripting, with a keen eye for query optimization and performance tuning. You will play a crucial role in maintaining our data warehouse, developing efficient ETL processes, and managing both inbound and outbound data flows.
Key Responsibilities:
- Develop and administer databases to support business applications.
- Maintain and optimize data warehouse performance.
- Design and implement ETL processes for data integration and workflow management.
- Write complex SQL queries and optimize their performance.
- Develop and maintain stored procedures, indexes, and scripts for database efficiency.
- Utilize Python for scripting and automation of database-related tasks.
- Independently manage projects from conception to completion, ensuring timely delivery.
- Collaborate effectively with both technical and non-technical team members.
Required Skills and Qualifications:
- Minimum of 2 years of experience with SQL and PL/SQL.
- Proven expertise in SQL query tuning and database performance optimization.
- Strong experience in writing complex SQL queries and developing stored procedures.
- Proficient in Python scripting, with a focus on database applications.
- Ability to work both independently and collaboratively in a team environment.
- Demonstrated project ownership and management skills.
- Strong analytical and problem-solving abilities.
Preferred Skills (Not Mandatory):
- Experience with Snowflake Data Warehouse is highly desirable.
- In-depth understanding of Snowflake architecture and processing mechanisms.
- Hands-on experience in Snowflake Cloud Development and Administration.
- Familiarity with data ingestion tools and techniques for Snowflake, such as Snowpipe.