SQL Developer

Job Title: Advanced SQL Engineer – Python & Snowflake Location: Remote Experience: 10–12 Years Employment Type: Full-Time About the Role: We are seeking a highly experienced Advanced SQL Engineer with strong expertise in Python and Snowflake to design, develop, and optimize scalable data solutions. The ideal candidate will have deep experience in handling large datasets, building efficient ETL pipelines, and driving advanced analytics initiatives to support business decision-making. Key Responsibilities: • Design, develop, and maintain complex SQL queries, stored procedures, and performance-optimized data models. • Build, enhance, and optimize ETL/ELT pipelines leveraging Python and Snowflake. • Architect scalable data warehouse solutions on Snowflake to support reporting and analytics. • Collaborate with cross-functional teams including Data Engineers, Analysts, and Business Stakeholders to define data requirements and deliver actionable insights. • Implement data quality, integrity, and governance best practices. • Work on data migration, integration, and transformation projects involving diverse data sources. • Ensure high performance of SQL queries and pipelines for large-scale, real-time, and batch data processing. • Mentor junior engineers and provide technical guidance to the team. Required Skills & Qualifications: • 10–12 years of experience in advanced SQL development, optimization, and data engineering. • Strong hands-on experience with Snowflake Data Warehouse (architecture, optimization, security, and performance tuning). • Expertise in Python for data engineering, scripting, and automation. • Proven experience in designing and optimizing ETL/ELT pipelines. • Strong understanding of data warehousing concepts, data modeling (star/snowflake schemas), and relational databases. • Hands-on experience with cloud platforms (AWS, Azure, or GCP). • Experience with version control (Git), CI/CD pipelines, and modern DevOps practices for data engineering. • Strong problem-solving and debugging skills. • Excellent communication and leadership skills with the ability to mentor junior team members. Preferred Qualifications: • Experience with Snowpipe, Streams, and Tasks in Snowflake. • Familiarity with orchestration tools (Airflow, dbt, or similar). • Exposure to machine learning workflows using Python is a plus. • Knowledge of BI/reporting tools like Tableau, Power BI, or Looker.