Sr Software Engineer - Snowflake & API Management

About This Role

Senior Software Engineer – Snowflake & API Management

10 months renewable contract

Job Purpose

To design, build, and maintain scalable cloud-based data platforms and API integrations that enable enterprise-wide analytics, data sharing, and system interoperability. The role is responsible for developing Snowflake-based data solutions and managing secure, reliable APIs to ensure seamless data exchange across internal and external systems. The position works closely with architects, data engineers, and business stakeholders to deliver robust, high‑performance data services that support reporting, analytics, and operational decision-making.

Key Responsibilities

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.

Qualifications

Education

• Bachelor’s Degree in Computer Science, Computer Applications, Engineering , or a related field.

Industry Experience

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

Required Skills & Experience

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