Senior ETL Developer

Symbiotic Group; Toronto; On-site; CAD 110,000 - 150,000; Full time

Job summary

Symbiotic Digital is seeking a Senior ETL Developer in Toronto to design, develop, and maintain data warehouse and BI solutions. The role involves building scalable ETL applications, managing data integrations, and supporting enterprise data platforms across cloud technologies.

This onsite, full-time position collaborates with stakeholders to deliver high-quality data-driven solutions. Key responsibilities include designing data pipelines, translating specifications into tested code, and

Qualifications

• Experience with Microsoft technologies including Power BI.
• ],
• Experience with Databricks and AWS services (Aurora, RDS, Glue).
• ,
• Experience with OpenSearch and data warehousing concepts.

Responsibilities

• Design, implement, and expand data pipelines through 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 BI 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.

Skills

Data integration

Data cleansing

Data analytics

SQL development

Tools

Power BI

Databricks

AWS

OpenSearch

Job description

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:
  
• 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
  
• 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:

• Digital Experts: IT Consulting expertise. Bright Minds That Produce Proven Results
  
• 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.