itjobs.ca Logo
Envision Technology Solutions logo

Data Engineer

Toronto, Ontario, Canada
Senior Level
Full-Time

About the role

Title: Data Platform Engineer Location: Toronto, Canada (5 Days Onsite) Duration: Full Time

Technical Skills Experience designing and implementing microservices architectures, including 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 writing 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.

Responsibilities and Duties

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 for domain-specific and ensuring 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.

Qualifications and Skills

Bachelor's degree (Master's preferred) in Computer Science, Software Engineering, Information Systems, or a related discipline. 7-8 years of professional Data Platform Engineering experience, with demonstrated delivery of production-grade web applications. Experience in the Payments or Fintech industry would be a strong asset. Proficiency in Python for backend development, including FastAPI, async patterns, and Pydantic-based data validation. 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.

About Envision Technology Solutions

IT Services and IT Consulting