11 Sep
|
Dawn InfoTek
|
Toronto
11 Sep
Dawn InfoTek
Toronto
Dawn InfoTek Inc. is a professional IT consulting firm that partners with major financial institutions, investment firms, and government organizations. We are committed to delivering cutting-edge IT consulting services and providing highly qualified talent for a wide range of technology positions.
We are currently seeking a Senior Application & Data Migration Developer – Snowflake / Azure to join our dynamic team and work with one of client.
The opportunity The role will focus on repointing existing Risk applications, processes, and dashboards to Snowflake tables while ensuring continuity of business-critical risk processes.
What you’ll do
- Repoint existing Risk Division applications, processes, and reporting assets from Oracle and SQL databases to Snowflake across multiple Risk teams.
- Analyze and update C#, Julia, and Python applications that currently depend on Oracle tables, Oracle SQL, and Oracle stored procedures.
- Convert, rewrite, or replace Oracle SQL and stored procedure logic where required to support Snowflake-based workflows.
- Work with Technology teams to understand Snowflake table structures, data availability, refresh timing, and data quality expectations.
- Support the migration of Power BI dashboards and reports from Oracle-based data sources to Snowflake.
- Validate migrated applications, reports, and processes through testing, reconciliation, troubleshooting, and performance tuning.
- Document migration approach, technical changes, testing results, known issues, and operational handover procedures.
- Communicate progress, risks, dependencies,
and blockers clearly, and participate in planning and delivery discussions with stakeholders across Risk.
- Contribute to Risk Division best practices for application repointing, SQL conversion, dashboard migration, testing, and production readiness.
- Other duties as assigned.
What you’ll need
- Undergraduate or graduate degree in a quantitative or technical discipline such as Engineering, Computer Science, Mathematics, Statistics, Finance, or a related field.
- Minimum 4 years of software development, database development, or data engineering experience.
- Strong hands-on experience with Python, SQL, and C# application development.
- Experience with Julia is a plus
- Experience with Oracle databases, including Oracle SQL, stored procedures, and database-driven applications.
- Experience with Snowflake, including SQL development, connectivity, query optimization, and migration from legacy databases.
- Experience with Power BI dashboard development, migration, or data source repointing.
- Robust analytical, organizational, troubleshooting, and problem-solving skills.
- Ability to work effectively with developers, Technology teams, risk professionals, and business users with varying levels of technical background across different Risk functions.
- Financial industry experience is an asset; capital markets or risk management experience is strongly preferred.
- Excellent communication skills and ability to provide clear updates on work plans, testing results, issues, and delivery status.
📌 Senior Application & Data Migration Developer – Snowflake / Azure (Toronto)
🏢 Dawn InfoTek
📍 Toronto