About
We are seeking a highly experienced Senior Software Developer - ETL to design, develop, and maintain the database back end and ETL applications for Data Warehouse and Business Intelligence solutions. The successful candidate will focus on designing and continuously expanding robust data pipelines (Extract, Transform, Load) using the Microsoft Azure technology stack. This role requires expertise in building scalable, maintainable data architecture, proficiency in complex SQL queries and performance tuning, and adherence to best practices throughout the full Software Development Lifecycle (SDLC). This is a fully Onsite position based in Toronto, ON.
Duration: 12 months (with potential for extension)
Advantages
- Azure Expertise: Direct, mandatory experience with the modern Microsoft Azure ETL and Data Lake stack.
- Data Specialization: Role focuses entirely on deep expertise in complex data warehousing, modeling, and SQL performance tuning.
- Long-Term Engagement: Secure a 12-month contract with the potential for extension.
- Onsite Collaboration: Work fully onsite in Toronto, fostering strong team dynamics and collaboration.
...
Responsibilities
The Senior Software Developer - ETL will be responsible for:
- ETL Design and Implementation: Designing, implementing, and continuously expanding data pipelines by performing extraction, transformation, and loading activities, with a focus on daily and initial load programs.
- Technology Stack: Utilizing the Microsoft suite of technology, including Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI.
- Coding & Quality: Translating technical systems specifications into working, tested applications by writing high-quality code. This includes writing and/or generating code, compiling data-driven programs, and conducting unit tests.
- Data Expertise: Applying expertise in data integration, data cleansing, and data analytics. Designing and implementing data modeling and design principles for data marts and data warehouses.
- Database Optimization: Constructing complex SQL queries and performing performance tuning. Possessing experience in database management and administration.
- SDLC & Documentation: Collaborating with IT Professionals throughout the SDLC, ensuring applications remain scalable while complying with standards. Creating comprehensive technical documentation including ETL source-to-target mappings, data model diagrams, and detailed design documents.
- Troubleshooting & Support: Resolving and troubleshooting technical problems within ETL pipelines, notifying end-users of issues, and proposing adequate solutions.
Qualifications
Must-Have Core Technical Skills:
- Experience with the Microsoft suite of technology, including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI.
- Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semi-structured files, relational and multi-dimensional data stores).
- Experience with developing, implementing, and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts.
- Experience with data integration, data cleansing, and data analytics.
- Experience with data modeling and design principles for data marts and data warehouses.
- Experience in database management and administration.
- Experience in constructing complex SQL queries and performance tuning.
- Experience with Git and knowledge of source control strategies.
- Experience creating technical documentation including ETL source-to-target mappings, data model diagrams, architecture artifacts, detailed design documents, etc.
Desirable Skills (Assets):
- Experience designing visual dashboards to highlight trends and Key Performance Indicators (KPIs), and developing canned reports (scheduled and ad-hoc).
- Experience with programming languages such as C#, developing application code such as APIs, Functions, etc.
- Experience writing scripts with PowerShell and other scripting languages.
- Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards.
- Experience in implementation of SaaS solution.
Summary
If you're interested in the Senior Software Developer - ETL role based in Toronto, ON, we encourage you to apply online at www.randstad.ca. Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more
Sign In 
Canada
Mexico
United States
Argentina
Brazil
Peru
Japan
South Korea
United Arab Emirates
France
Germany
Italy
Portugal
Spain
Sweden
Switzerland
United Kingdom
Australia
