Sr Software Engineer - Snowflake & API Management

Overview

Job Purpose

Data Platform & Snowflake Engineering

• Design, develop, and optimize
• Snowflake data warehouse solutions
• for enterprise-scale analytics and reporting.
• Implement data ingestion, transformation, and loading (ELT) pipelines into Snowflake from diverse source systems (databases, applications, APIs, and streaming platforms).
• Develop and maintain
• Snowflake schemas, views, secure data shares, and data models
• (fact/dimension tables).
• Optimize Snowflake performance using clustering, caching strategies, warehouse sizing, and query tuning.
• Implement data governance, security, and access control using Snowflake roles, policies, masking, and row-level security.

Api Management & Integration

• Design, develop, and maintain
• RESTful and event-driven APIs
• to enable system-to-system and data integrations.
• Implement
• API management solutions
• (e.g., Apigee, Kong, Azure API Management, AWS API Gateway, MuleSoft) for security, throttling, monitoring, and lifecycle management.
• Ensure APIs follow best practices for versioning, authentication/authorization (OAuth2, JWT), and documentation (OpenAPI/Swagger).
• Integrate APIs with Snowflake and downstream analytics/reporting platforms.

Orchestration, Automation & Reliability

• Build and manage
• automated data workflows
• using orchestration tools (e.g., Airflow, Managed Cloud Orchestration tools).
• Implement CI/CD pipelines for data and API deployments.
• Monitor data pipelines, APIs, and platform health; proactively resolve performance and reliability issues.
• Ensure high availability, scalability, and disaster recovery for data and integration services.

Collaboration & Delivery

• Work closely with business stakeholders, data analysts, and BI teams to understand requirements and translate them into technical solutions.
• Provide technical leadership, conduct design reviews, and mentor junior engineers.
• Communicate progress, risks, and dependencies clearly to project managers and leadership.

Education

• Bachelor’s Degree in

Computer Science, Computer Applications, Engineering

Industry Experience

• Software and Data Engineering
• Enterprise Data Platforms, Analytics, or Integration Domains
• Aviation, Airport, Transportation, or other large-scale regulated industries (preferred)

Core Technical Skills

• Strong hands-on experience with

Snowflake

• (architecture, performance tuning, security).
• Advanced SQL skills for analytical data processing and transformations.
• Experience designing and managing
• APIs and API management platforms
• .
• Data warehousing concepts, dimensional modeling, and cloud data architecture.
• Experience with cloud platforms (AWS, Azure, or GCP).

Tools & Technologies

• **Snowflake**
• , SQL
• API Management platforms (Apigee, Kong, Azure API Management, AWS API Gateway, MuleSoft)
• Data orchestration tools (Apache Airflow or cloud-managed equivalents)
• Streaming and integration tools (Kafka or cloud equivalents – nice to have)
• BI & reporting tools (Tableau or similar – desirable)
• CI/CD tools and Git-based version control

Soft Skills

• Strong problem-solving and analytical skills
• Excellent communication and stakeholder management abilities
• Ability to lead technical discussions and mentor team members
• Experience working in agile delivery models