Senior ETL Developer

Position: Senior ETL Developer

Role Overview

We are seeking a Senior ETL Developer to design, develop, and maintain data warehouse and business intelligence solutions. The successful candidate will be responsible for building scalable ETL applications, developing high-quality code, managing data integrations, and supporting enterprise data platforms across cloud technologies.

This position requires full-time onsite attendance, five days per week.

Key Responsibilities

• Design, implement, and expand data pipelines through extraction, transformation, and loading (ETL) activities.
  
  


• Translate technical system specifications into working, tested applications.
  
  


• Develop detailed programming specifications and application code.
  
  


• Compile, maintain, test, and debug data-driven programs.
  
  


• Troubleshoot technical issues related to software implementation, conversion, and migration activities.
  
  


• Design, develop, and maintain database backend and ETL applications for Data Warehouse and Business Intelligence environments.
  
  


• Build and enhance application functionality using ETL development techniques and coding best practices.
  
  


• Ensure solutions are scalable, maintainable, and aligned with development standards.
  
  


• Create and maintain technical documentation.
  
  


• Collaborate with development teams and business stakeholders to deliver high-quality solutions.
  
  


• Investigate ETL pipeline issues and recommend corrective actions.
  
  


• Support data integration, data quality, and analytics initiatives.
  
  

Mandatory Qualifications

• Experience with Microsoft technologies including:
  
  




• Azure Data Factory
  
  


• Azure SQL Database
  
  


• Azure Data Lake
  
  


• Power BI
  
  




• Experience with Databricks.
  
  


• Experience with AWS technologies including:
  
  




• Amazon Aurora
  
  


• Amazon Relational Database Service (RDS)
  
  


• AWS Glue
  
  


• OpenSearch
  
  




• Experience developing ETL solutions across structured and semi-structured data repositories.
  
  


• Experience implementing and maintaining ETL scheduling and dependency logic.
  
  


• Experience with:
  
  




• Data integration
  
  


• Data cleansing
  
  


• Data analytics
  
  




• Experience with data modeling and data warehouse design principles.
  
  


• Experience with database administration and management.
  
  


• Strong SQL development and performance tuning experience.
  
  


• Experience using Git and source control strategies.
  
  


• Experience creating technical documentation including:
  
  




• Source-to-target mappings
  
  


• Data models
  
  


• Architecture diagrams
  
  


• Detailed design documents
  
  




• Experience gathering, documenting, and validating business requirements.
  
  


• Experience working across the Software Development Lifecycle (SDLC), including development, testing, QA, and deployment.
  
  


• Strong verbal and written communication skills.
  
  

Nice-to-Have Qualifications

• Knowledge of Accessibility for Ontarians with Disabilities Act (AODA) standards and regulations.
  
  


• Experience designing dashboards, KPIs, and operational reporting solutions.
  
  


• Experience with C# development, APIs, and application functions.
  
  


• Experience with PowerShell and other scripting languages.
  
  


• Knowledge of rapid application development methodologies.
  
  


• Experience supporting production implementations and post-deployment activities.
  
  

About Symbiotic Digital.

Symbiotic Digital provides the IT Experts you need that solve problems and get things done. See what the top 2% in their field can do for you. (Symbiotic Digital is a division of Symbiotic Group Inc.)

We serve customers in two ways, we provide:

1. Digital Experts: IT Consulting expertise. Bright Minds That Produce Proven Results
   
   


2. Recruitment: Find The Right People You Need
   
   

Serving IT & Business leaders, Symbiotic Digital provides a business system that enable us to provide the Expert Technical staff needed to solve challenging business and IT problems. IT leaders in the most reputable organizations in Canada have relied on Symbiotic Digital to help them staff difficult assignments with proven Experts uniquely evaluated by our proven QMS- Quality Management System Staff Development Model. We are a 100% Indigenous owned company.

Learn more online at https://www.symbioticgroup.com/home-sd/.

Please submit your most recent resume to: [email protected]

View All Jobs online at: https://www.symbioticgroup.com/view-jobs/