SE Mentor Solutions
Website:
se-mentor.com
Company:
https://www.linkedin.com/company/se-mentor-solutions-p-ltd.-
Industries: Information Technology & Services
Job details:
Team: Sujan
Location: Bangalore
Work Mode: Hybrid
Interview Mode: L1 & L2 -Virtual
Snowflake Data Engineer
We are seeking a Snowflake Consultant to design and implement scalable data engineering and analytics solutions on the Snowflake Data Cloud. The candidate will leverage Snowpark (Python API) to build efficient data pipelines, transformation logic, and advanced analytics workflows directly within Snowflake. Snowpark enables developers to process and transform data using Python directly inside Snowflake without moving data, making this role critical for modern data platforms.
Key Responsibilities
- Data Engineering & Snowpark Development
- Design and develop data pipelines (ETL/ELT) using Snowflake, SQL, and Python (Snowpark)
- Build data transformation logic using Snowpark DataFrame API
- Develop stored procedures, UDFs, and UDTFs in Python
- Enable data processing and analytics workflows directly within Snowflake
- Data Modeling & Optimization
- Design and maintain data models and schema architecture
- Optimize query performance and cost efficiency
- Implement data governance, security, and RBAC policies
- Advanced Data Processing & Analytics
- Perform large-scale data transformation and processing using Python
- Build data science/ML workflows using Snowpark where applicable
- Support feature engineering, model scoring, and analytics pipelines
- Integration & Automation
- Integrate data from sources such as:
- Cloud storage (AWS S3 / Azure Blob)
- SFTP / APIs / databases
- Automate workflows using tasks, pipelines, and orchestration tools
- Performance Tuning & Troubleshooting
- Monitor and resolve:
- Data quality issues
- Performance bottlenecks
- Pipeline failures
- Optimize warehouse usage and compute scaling
- Collaboration & Delivery
- Work with:
- Data architects
- Business analysts
- Engineering and QA teams
- Translate business requirements into technical solutions
- Participate in Agile ceremonies and deliver end-to-end solutions
Required Skills & Experience
Core Skills
- Strong experience in Snowflake (Data Warehousing, SQL, Performance Tuning)
- Hands-on experience in Python (mandatory)
- Working experience with Snowpark (Python API) for data pipelines
- Expertise in ETL/ELT design and implementation
- Solid understanding of data warehousing concepts
Technical Skills
- SQL:
- Complex queries, stored procedures, optimization
- Python:
- Data processing, automation, scripting
- Snowflake:
- Data modeling, pipelines, security
Cloud & Tools
- Exposure to at least one:
- AWS / Azure / GCP
- Experience with:
- CI/CD tools, Git
- Orchestration tools (Airflow, dbt - optional)
Preferred Qualifications
Soft Skills
- Strong analytical and problem-solving skills
- Ability to work in cross-functional environments
- Good communication for stakeholder interaction
- Agile mindset with focus on delivery and quality
Typical Experience Range
- 4-10 years in Data Engineering / Snowflake ecosystem
- 2+ years working on Python-based data processing or Snowpark
Click on Apply to know more.
