Python/SQL Developer - Consultant
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Experience
- Minimum 4 years of experience in software development, application development, database development, or related technical consulting.
- Posting language
- English
- Posted
Original job description
Position: Python/SQL Developer - Consultant
Duration: 6 month assignment (contract)
Client Location: Toronto, Ontario(Hybrid Engagement: 4 days onsite per week)
Engagement Model: Professional Services Engagement – B2B (Incorporated Entities Only)
Note: Client is seeking a hands-on Python Developer focused on coding, application development, and database queries, rather than data engineering or data modeling.
About the Engagement
Akkodis is seeking the services of an experienced Python/SQL Developer Consultant to support a large-scale application and data platform migration initiative within a leading Canadian financial services organization. The engagement focuses on transitioning existing risk applications, reporting assets, and data dependencies from Oracle-based environments to Snowflake and Azure Cloud platforms. The successful consultant will work closely with business stakeholders and technology teams to repoint applications, convert database logic, support reporting migrations, and ensure continuity of critical business processes.
Services to be Provided
- Repoint existing applications, processes, and reporting assets from Oracle and traditional SQL databases to Snowflake.
- Analyze, maintain, and enhance Python and C# applications that depend on Oracle databases, SQL queries, and stored procedures.
- Convert, rewrite, and optimize Oracle SQL and stored procedure logic to support Snowflake-based solutions.
- Collaborate with technology teams to understand Snowflake data structures, availability schedules, and data quality requirements.
- Support migration of Power BI reports and dashboards from Oracle-based data sources to Snowflake.
- Perform testing, reconciliation, troubleshooting, and performance tuning of migrated applications and reporting solutions.
- Document migration approaches, technical changes, test results, operational procedures, and known issues.
- Communicate project status, risks, dependencies, and blockers to stakeholders and project teams.
- Contribute to best practices related to application migration, SQL conversion, dashboard transitions, testing, and production readiness.
Expertise Required
- Undergraduate or graduate degree in Computer Science, Engineering, Mathematics, Statistics, Finance, or a related technical discipline.
- Minimum 4 years of experience in software development, application development, database development, or related technical consulting.
- Strong hands-on development experience with Python and SQL.
- Experience developing and maintaining C# applications.
- Strong experience working with Oracle databases, including Oracle SQL, stored procedures, and database-driven applications.
- Experience with Snowflake, including SQL development, connectivity, query optimization, and database migration activities.
- Experience supporting Power BI dashboard development, migrations, and data source repointing.
- Strong analytical, troubleshooting, organizational, and problem-solving skills.
- Ability to collaborate effectively with technical and non-technical stakeholders across multiple business functions.
- Excellent verbal and written communication skills.
Nice to Have
- Experience with Julia programming language.
- Financial services industry experience.
- Capital markets, investment risk, or risk management domain knowledge.
- Experience supporting Azure Cloud-based environments and migration initiatives.
- Exposure to large-scale enterprise application modernization projects.
Important
This is a business-to-business engagement. Candidates must represent an incorporated entity, hold a valid business number, maintain appropriate insurance, and invoice for services rendered.
How to Apply
Submit your resume in confidence to your Akkodis recruitment contact or via the Akkodis Canada website.
Accessibility
At Akkodis, part of The Adecco Group, our purpose is simple: to make the future work for everyone. We live our values of Passion, Collaboration, Inclusion, Courage, and Customers at Heart by fostering a workplace where diversity is celebrated and every voice matters. We encourage applications from individuals of all backgrounds and identities. Together, we’re making the future work for everyone
More about this job
Responsibilities
Migrate applications, reporting assets, and database logic from Oracle-based environments to Snowflake and Azure, including maintaining Python and C# applications and converting SQL and stored procedures. Support Power BI migrations, test and troubleshoot migrated solutions, document technical changes, and communicate project status and risks to stakeholders.
Requirements
Requires a technical undergraduate or graduate degree and at least four years of relevant software, application, database development, or consulting experience. Candidates need hands-on Python and SQL skills, C# application experience, strong Oracle and Snowflake experience, and experience supporting Power BI; financial services, risk domain, Julia, and Azure experience are advantageous.
Skills
- Python
- SQL
- C#
- Oracle
- Snowflake
- Power BI
- Azure Cloud
- Stored Procedures
- Application Development
- Database Migration
- SQL Conversion
- Query Optimization
- Dashboard Migration
- Testing
- Troubleshooting
- Financial Services
Visa sponsorship
Not detected in the job text
Categories
- Software
- Technology
- Data & Analytics
- Consulting
- Finance & Accounting
Keywords
- Python
- SQL
- C#
- Oracle
- Snowflake
- Azure Cloud
- Power BI
- Stored Procedures
- Application Development
- Database Development
- Database Migration
- Application Modernization
- SQL Conversion
- Query Optimization
- Data Migration
- Dashboard Migration
- Testing
- Reconciliation
- Troubleshooting
- Performance Tuning
- Production Readiness
- Financial Services
- Capital Markets
- Investment Risk
- Risk Management
- Julia
- Professional Services
- Business-to-Business Engagement