Software Developer (Python) – API & Data Engine Integration - 85886

Line of Business: Corporate Treasury

Duration: 9-12 months (Possibility of Extension)

Location: Downtown Toronto [fully remote but must be able to come into the office if needed]

About the Role

We’re looking for a Software Developer to design and implement web-based APIs that integrate seamlessly with a SQL-based analytics engine. You’ll ensure accurate, secure, and scalable data flows between APIs and the analytics layer, deploying solutions in a hybrid on-prem and cloud environment.

Responsibilities:

• Develop APIs: Build and maintain RESTful APIs using Python frameworks (FastAPI or Flask) for end-user access and API-to-API integration.

• Integrate with SQL Engine: Design workflows to send requests to the SQL analytics engine, retrieve calculated results, and return them to calling APIs.

• Database & Analytics: Optimize Microsoft SQL Server for complex calculations.

• Deployment: Deploy and manage solutions in hybrid on-prem and cloud (AWS or similar cloud) environments.

• Security & Compliance: Implement OAuth2/JWT authentication integrated with Microsoft AD, secure coding practices, and encryption for data in transit and at rest.

• Containerization & CI/CD: Package applications with Docker, orchestrate with Kubernetes, and build automated pipelines for deployment and testing.

• Collaboration: Work with cross-functional teams to integrate APIs into enterprise ecosystems.

• Performance & Scalability: Ensure high availability, low latency, and robust security across all components.

Must Have Skills:

• Python Expertise: Advanced proficiency in Python for backend development and automation using FastAPI/Flask and RESTful API design.

• API Development: 3 years of experience building and deploying web-based APIs.

• SQL & Analytics: 3 years with Microsoft SQL Server and other DBMSs

• Cloud Platforms: Hands-on experience with Azure, AWS or similar, familiar with Infrastructure as Code (CloudFormation or AWS CDK).

• Security & Containers: Familiarity with OAuth2/JWT, file level and column level encryption/decryption (PGP, CMK), Docker, and Kubernetes for secure, containerized deployments.

• CI/CD: Experience with automated pipelines (Azure DevOps, GitHub Actions) for build, test, and deployment.

Nice to Have Skills:

• Background in banking or financial services.

• Certifications in cloud, data engineering, or API technologies.