This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
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)
Job Responsibility:
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.
Requirements:
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.
Nice to have:
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.
What we offer:
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.
Welcome to CrawlJobs.com – Your Global Job Discovery Platform
At CrawlJobs.com, we simplify finding your next career opportunity by bringing job listings directly to you from all corners of the web. Using cutting-edge AI and web-crawling technologies, we gather and curate job offers from various sources across the globe, ensuring you have access to the most up-to-date job listings in one place.
We use cookies to enhance your experience, analyze traffic, and serve personalized content. By clicking “Accept”, you agree to the use of cookies.