Data Platform Engineer | 5+ Year
Skills
About the role
Data Platform Engineer
Experience - 5-8 Years
Location - Toronto, Canada
Job Overview
The primary focus of this role is to design, build, and maintain the EMFI Data Application Platform, a financial analytics application. The successful candidate will work across the full technology stack to deliver reliable, high-performing, and secure data products.
Key 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 ensuring loose coupling through well-defined API contracts.
Develop Snowflake-native applications using Snowpark (Python), Stored Procedures, Tasks, Streams, and Dynamic Tables to support day-end processing engines running within the Snowflake compute layer.
Design and implement RESTful APIs using FastAPI, ensuring data contracts are clearly defined, versioned, and documented through OpenAPI/Swagger.
Write, optimize, and maintain SQL queries in Snowflake and PostgreSQL for reporting, aggregation, and analytical workloads.
Own the end-to-end delivery lifecycle, from requirements gathering and API design through implementation, testing, and deployment.
Ensure platform security by applying best practices around authentication, authorization (RBAC), input validation, and secure error handling aligned with OWASP Top 10 standards.
Technical Skills
Strong experience designing and implementing microservices architectures, including service discovery, inter-service communication, API versioning, and observability through distributed tracing and logging.
Proficiency in Python backend development, including FastAPI asynchronous programming and Pydantic-based data validation.
Hands-on expertise with SQL and analytical databases, including query optimization, aggregations, and data transformations.
Experience developing Snowflake-native solutions using Stored Procedures (Python/JavaScript), Tasks, Streams, Dynamic Tables, and Snowpark.
Strong understanding of REST API design principles, OpenAPI specifications, and frontend integration patterns.
Knowledge of authentication and authorization mechanisms such as JWT, OAuth2, and Role-Based Access Control (RBAC).
Experience with Docker and Docker Compose for containerized development and deployment.
Familiarity with CI/CD pipelines for automated testing and release management.
Proficiency with Git, including branching strategies, pull requests, and code review processes.
Experience working with cloud platforms such as AWS, Azure, or GCP for compute, storage, and application deployment.
Qualifications
Bachelor's degree in Computer Science, Software Engineering, Information Systems, or a related field (Master's degree preferred).
5–8 years of professional full-stack development experience with a proven track record of delivering production-grade applications.
Prior experience in the Payments or Fintech industry is highly desirable.
Demonstrated ability to work independently, manage multiple priorities, and deliver results with minimal supervision.
Excellent communication and interpersonal skills, with the ability to engage effectively with both technical and non-technical stakeholders.
Strong personal and professional ethics with a commitment to integrity and accountability.
Our Commitment to Environment:
Actively contribute to Apexon's commitment to environmental responsibility by following sustainable practices and supporting ESG initiatives.
Our Perks and Benefits:
Our benefits and rewards program has been thoughtfully designed to recognize your skills and contributions, elevate your learning/upskilling experience and provide care and support for you and your loved ones. As an Apexon Associate, you get continuous skill-based development, opportunities for career advancement, and access to comprehensive health and well-being benefits and assistance.
We also offer:
Term Insurance and Accident Insurance
Group Health Insurance covering family of 4
Paid Holidays & Earned Leaves
Paid Parental Leave
Learning & Career Development
Employee Wellness
Visit- www.apexon.com
Questions about this role
Want AI Applyd to auto-apply to roles like this?
We tailor your resume per posting, fill the forms, and track replies for you.