Lead Software Engineer
- Toronto, ON, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Posting language
- English
- Posted
Original job description
SSIS Development & Data Integration
Design, develop, deploy, and maintain SSIS packages for ETL processes.
Create and optimize data integration workflows between multiple source and target systems.
Develop complex SQL queries, stored procedures, views, and database objects.
Troubleshoot and resolve ETL failures, data quality issues, and performance bottlenecks.
Implement automated data loading, validation, and reconciliation processes.
Data Validation & Data Quality
Perform source-to-target data validation and reconciliation.
Analyze data discrepancies and coordinate corrective actions.
Create validation frameworks and exception reporting processes.
Ensure data integrity, accuracy, and completeness across reporting environments.
Production Support
Provide L2/L3 support for SQL Server databases, ETL processes, and reporting systems.
Monitor daily ETL jobs and resolve production incidents within SLA timelines.
Perform root cause analysis (RCA) and implement preventive measures.
Support deployment activities and post-production validation.
New Project Development
Participate in new data warehouse, reporting, and integration projects.
Design scalable ETL solutions according to business and technical requirements.
Perform testing and collaborate with business teams during project execution.
Translate business requirements into technical specifications and development tasks.
SQL Server DBA Responsibilities
Monitor SQL Server performance, availability, and capacity.
Manage SQL Agent jobs, database backups, recovery, and maintenance plans.
Perform database security management, user access provisioning, and permissions administration.
Identify and resolve blocking, deadlocks, and performance issues.
Implement indexing, query tuning, and database optimization strategies.
Azure & Power BI Support
Assist with Azure-based data integration and cloud migration initiatives.
Support Azure SQL Database, Azure Data Factory, and related Azure services.
Develop and maintain Power BI reports and dashboards.
Collaborate with reporting teams to ensure data accuracy and reporting efficiency.
Required Skills
Technical Skills
Strong experience in Microsoft SQL Server (2016/2019/2022).
Expertise in SSIS (SQL Server Integration Services).
Advanced SQL programming, query optimization, and performance tuning.
Design, develop, deploy, and maintain SSIS packages for ETL processes.
Create and optimize data integration workflows between multiple source and target systems.
Develop complex SQL queries, stored procedures, views, and database objects.
Troubleshoot and resolve ETL failures, data quality issues, and performance bottlenecks.
Implement automated data loading, validation, and reconciliation processes.
Data Validation & Data Quality
Perform source-to-target data validation and reconciliation.
Analyze data discrepancies and coordinate corrective actions.
Create validation frameworks and exception reporting processes.
Ensure data integrity, accuracy, and completeness across reporting environments.
Production Support
Provide L2/L3 support for SQL Server databases, ETL processes, and reporting systems.
Monitor daily ETL jobs and resolve production incidents within SLA timelines.
Perform root cause analysis (RCA) and implement preventive measures.
Support deployment activities and post-production validation.
New Project Development
Participate in new data warehouse, reporting, and integration projects.
Design scalable ETL solutions according to business and technical requirements.
Perform testing and collaborate with business teams during project execution.
Translate business requirements into technical specifications and development tasks.
SQL Server DBA Responsibilities
Monitor SQL Server performance, availability, and capacity.
Manage SQL Agent jobs, database backups, recovery, and maintenance plans.
Perform database security management, user access provisioning, and permissions administration.
Identify and resolve blocking, deadlocks, and performance issues.
Implement indexing, query tuning, and database optimization strategies.
Azure & Power BI Support
Assist with Azure-based data integration and cloud migration initiatives.
Support Azure SQL Database, Azure Data Factory, and related Azure services.
Develop and maintain Power BI reports and dashboards.
Collaborate with reporting teams to ensure data accuracy and reporting efficiency.
Required Skills
Technical Skills
Strong experience in Microsoft SQL Server (2016/2019/2022).
Expertise in SSIS (SQL Server Integration Services).
Advanced SQL programming, query optimization, and performance tuning.
More about this job
Responsibilities
Design, develop, and support SSIS-based ETL and data integration solutions, including SQL development, data validation, production troubleshooting, and new data warehouse projects. Administer and optimize SQL Server databases, support Azure data services, and develop Power BI reports and dashboards.
Requirements
The posting requires strong experience with Microsoft SQL Server 2016, 2019, or 2022, expertise in SSIS, and advanced SQL programming. It also emphasizes query optimization and performance tuning; no education requirement is stated.
Skills
- Microsoft SQL Server
- SSIS
- SQL Programming
- ETL Development
- Data Integration
- Query Optimization
- Performance Tuning
- Data Validation
- Data Quality
- Azure SQL Database
- Azure Data Factory
- Power BI
- Production Support
- Root Cause Analysis
Visa sponsorship
Not detected in the job text
Categories
- Software
- Technology
- Data & Analytics
Keywords
- Microsoft SQL Server
- SQL Server 2016
- SQL Server 2019
- SQL Server 2022
- SSIS
- ETL
- Data Integration
- SQL
- Stored Procedures
- Database Views
- Data Validation
- Data Quality
- Data Reconciliation
- Exception Reporting
- Production Support
- Root Cause Analysis
- Data Warehousing
- SQL Server Agent
- Database Backups
- Database Recovery
- Database Security
- Indexing
- Query Tuning
- Azure
- Azure SQL Database
- Azure Data Factory
- Cloud Migration
- Power BI
- Reporting Systems