Senior Microsoft Data Developer

CG Consulting Group; Toronto; Hybrid; CAD 80,000 - 120,000; Full time

Job summary

An innovative IT consulting boutique in Toronto is seeking a Senior Microsoft Developer to enhance their data integration and database development capabilities. This role offers a hybrid work environment, allowing you to balance home and office work while engaging in impactful projects within the financial services and fintech sectors. You'll leverage your extensive experience in ETL development, particularly with SSIS and T-SQL, to drive the successful delivery of custom database solutions. Join a team of experts dedicated to providing strategic, mission-critical solutions and take your career to the next level in a collaborative and dynamic setting.

Qualifications

• 8+ years in system design and development for ETL and BI projects.
• Experience in automated testing and release processes.

Responsibilities

• Translate business requirements into technical designs and automate processes.
• Design and deploy SSIS-based ETL jobs and develop dashboards using Power BI.

Skills

ETL Development

SSIS

T-SQL

Microsoft SQL Server

Power BI

Agile Methodologies

Data Integration

Problem-solving

Education

Bachelor's degree in Computer Science

Tools

GCP

Confluence

Jira

Job description

Senior Microsoft Developer

Client is a Toronto-based IT consulting boutique that strives for excellence in customer service and delivery in financial services and fintech industry.
They focus on technology advisory services, application development, cloud computing, integration solutions, and enterprise big data and analytics.
With a team of highly knowledgeable business and technical experts, we provide strategic, mission critical solutions to our clients.
Looking for a senior Data Engineer who has hands-on experience in data integration and database development in hybrid environment and who will contribute to successfully deliver hybrid data integration or custom database development projects in the Greater Toronto Area.

Company location: Downtown Toronto,
Hybrid work environment - mix of home, office and client site
Perm / FTE role: Salary: Market rate + benefits and performance bonus

RESPONSIBILITIES
• Translate business requirements into detailed technical designs.
• Analyze current manual processes and implement automated solutions through detailed design and testing.
• Design, build, run, and deploy SSIS-based ETL jobs for data movement and data mart population.
• Schedule and orchestrate ETL jobs using Windows Agent and SQL Agent.
• Develop dashboards and reports using Power BI.
• Design and execute migration paths for moving on-premises MS SQL-based data and SSIS solutions to cloud-based platforms.
• Apply agile approach for development and delivery.
• Produce estimates for analysis, design, development, and testing.
• Support testing activities and troubleshoot integration or functional issues.
• Ensure compliance with business, data, and technical requirements.
• Ensure compliance with coding standards, client policies, business, data, and technical requirements on client engagements.

REQUIREMENTS
• Bachelor’s degree in Computer Science or Engineering.
• Minimum 8 years of experience in system design and development for ETL and business intelligence projects.
• At least 5 years of experience in ETL development using SSIS and T-SQL-based solutions.
• Strong working knowledge in Microsoft SQL Server or Azure SQL databases (standalone or managed instances) and Power BI report/dashboard development.
• Experience with GCP is preferred.
• Experience in automated unit testing, integration testing, and end-to-end testing.
• Experience with release processes and deployments to higher environments such as QA, UAT, and Production.
• Working knowledge in agile software methodologies and development tools (e.g., Confluence and Jira).
• Good overall business knowledge within the financial industry (in one or more of retail banking, commercial banking, capital markets, wealth management, insurance, pension fund, and fintech).
• Excellent communication, diagnostic, and problem-solving skills.
• Ability to work independently and excel in a collaborative team environment.