Technical jobs in United States

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.