We’re looking for a Software Developer who can design and implement web-based APIs that interact seamlessly with a robust SQL-based analytics engine. In this role, you’ll ensure that the SQL database and its analytics layer serve as the backbone for all calculations, delivering accurate results back to APIs for end-user consumption and integration with other systems. We are hiring on behalf of Deloitte
What You’ll Do
• Develop and maintain web-based APIs for direct end-user access and API-to-API integration.
• Design workflows to send requests to the SQL analytics engine, retrieve calculated results, and return them to calling APIs.
• Build and optimize Microsoft SQL database structures and analytics layers to support complex calculations.
• Deploy and manage solutions in cloud environments (Azure preferred).
• Collaborate with cross-functional teams to integrate APIs into broader application ecosystems.
• Ensure high performance, scalability, and security across all components.
What We’re Looking For
• Highly skilled in Python for both backend and frontend development and automation
• At least 3 years of work experience in web-based API development.
• At least 3 years of work experience with Microsoft SQL database and analytics layer development. Extensive experience with SQL Server Analysis Services (SSAS) and BI/Semantic Layer Practices, or similar tools.
• Extensive experience with cloud platforms (Azure or similar).
• Development of robust ETL pipelines to extract, transform, and load data from IBM Netezza/Hadoop, ensuring efficient handling of large datasets.
• Experience with star/snowflake schemas, fact/dimension modeling, and slowly changing dimensions.
• Familiarity with Microsoft Fabric and AI Foundry
• Experience with Power BI, DAX, and M Code for dashboarding.
• Experience in banking or financial services.
• Up-to-date industry certifications in cloud, data, or API technologies.
Job Type: Fixed term contract
Contract length: 9 months
Pay: Up to $90.00 per hour
Expected hours: 37.5 per week
Experience:
• banking: 1 year (required)
• Python: 2 years (required)
• APIs: 1 year (preferred)
Work Location: Hybrid remote in Toronto, ON
