Data Platform Engineer — Snowflake / FastAPI 12-month contract · Hybrid, downtown Toronto (3 days onsite) · T4

About the Role

We're looking for a Data Platform Engineer to design, build, and maintain a financial analytics data application platform at a major fintech. You'll work across the full stack to deliver reliable, performant, and secure data products, partnering with internal stakeholders to translate business and analytical requirements into well-defined backend features.

Responsibilities

• Collaborate with internal stakeholders to translate business and analytical requirements into well-defined backend features and data products
• Design and deploy scalable microservices within the FastAPI ecosystem, establishing clear service boundaries and loose coupling through well-defined API contracts
• Design and develop Snowflake-native applications including Snowpark (Python), stored procedures, Tasks, Streams, and Dynamic Tables to support day-end and processing engines that run natively within the Snowflake compute layer
• Design and implement RESTful API endpoints using FastAPI, ensuring data contracts are clearly defined, versioned, and documented via OpenAPI/Swagger
• Write and optimize SQL queries against Snowflake and PostgreSQL for reporting, aggregation, and analytical use cases
• Own end-to-end feature delivery: from requirements gathering and API contract definition through implementation, testing, and deployment
• Ensure platform security by applying best practices around authentication, authorization (RBAC), input validation, and safe error handling, aligned with OWASP Top 10

Technical Skills

• Experience designing and implementing microservices architectures — service discovery, inter-service communication, API versioning, and distributed tracing/logging for observability
• Proficiency in Python for backend development, including FastAPI, async patterns, and Pydantic-based data validation
• Hands-on experience with SQL and analytical databases for optimized queries, aggregations, and data transformations
• Experience developing Snowflake-native applications: stored procedures (JavaScript/Python), Tasks, Streams, Dynamic Tables, and Snowpark for building backend processing engines
• Understanding of REST API design, OpenAPI specifications, and API integration patterns in frontend applications
• Knowledge of authentication and authorization patterns including JWT, OAuth2, and role-based access control
• Experience with Docker and Docker Compose for local development and containerized deployments
• Familiarity with CI/CD pipelines for automated testing and deployment
• Experience with version control using Git, including branching strategies and code review workflows
• Ability to work with cloud platforms (AWS, Azure, or GCP) for data storage, compute, and deployment

Qualifications

• Bachelor's degree (Master's preferred) in Computer Science, Software Engineering, Information Systems, or a related discipline
• 5–7 years of professional full stack development experience, with demonstrated delivery of production-grade web applications
• Experience in the Payments or Fintech industry is a strong asset
• Proven ability to work independently, manage multiple concurrent workstreams, and deliver with minimal oversight
• Excellent communication and interpersonal skills, able to engage technical and non-technical audiences
• Unquestionable personal and business ethics and integrity

Technical Environment

• Data Platform: Snowflake (Snowpark, stored procedures, Tasks, Streams, Dynamic Tables)
• Backend: Python, FastAPI, async, Pydantic
• Databases: Snowflake, PostgreSQL
• APIs: REST, OpenAPI/Swagger
• Auth: JWT, OAuth2, RBAC (OWASP Top 10)
• Infrastructure: Docker / Docker Compose, CI/CD, Git; cloud (AWS / Azure / GCP)

What You'll Work On

• Snowflake-native day-end and processing engines running inside the Snowflake compute layer
• FastAPI microservices and versioned REST APIs powering a financial analytics platform
• Optimized SQL for reporting, aggregation, and analytical use cases across Snowflake and PostgreSQL
• Secure, well-documented data products delivered end to end from requirements through deployment