Senior Software Developer ETL

At Proxy Link, we specialize in building meaningful connections between exceptional talent and leading employers across Canada. As a trusted recruitment partner, our mission is to create impactful career matches by combining innovative hiring strategies with a personalized, people-first approach. We’re driven by the belief that investing in people today builds a stronger workforce for tomorrow.

Proxy Link is seeking an experienced  Senior Software Developer – ETL  to join our team and contribute to the development, enhancement, and maintenance of enterprise-level data integration, data warehousing, and business intelligence solutions.

The ideal candidate will have strong hands-on experience with Microsoft Azure data technologies, AWS data services, Databricks, SQL development, and complex ETL processes. You will play a key role in transforming business requirements into reliable, scalable, and high-quality data solutions that support reporting, analytics, and informed decision-making.

This role is well suited to a technically strong developer who enjoys solving complex data challenges, optimizing data pipelines, collaborating with business stakeholders, and delivering dependable software solutions throughout the software development lifecycle.

Key Responsibilities
ETL Development and Data Integration

Design, develop, implement, and maintain robust ETL pipelines to extract, transform, validate, and load data from multiple sources.

Build and enhance both initial and recurring data load processes for structured and semi-structured data, relational databases, and multidimensional data stores.

Develop, maintain, and optimize data integration workflows, scheduling mechanisms, job dependencies, and automated data processing routines.

Implement data cleansing, transformation, validation, and quality assurance processes to ensure data accuracy, consistency, completeness, and reliability.

Investigate data discrepancies, identify issues within existing ETL pipelines, and recommend effective solutions to minimize operational disruptions.

Maintain and enhance existing data pipelines, ensuring they remain scalable, maintainable, secure, and aligned with business needs.

Cloud Data Platforms and Database Development

Leverage Databricks for data processing, transformation, and integration activities.

Develop and support data solutions using AWS services, including Amazon Aurora, AWS Glue, Amazon Open Search, and related database and search technologies.

Design and maintain database structures, data models, data marts, and data warehouses in accordance with established architecture standards.

Write, analyze, and optimize complex SQL queries to improve database performance and support efficient data retrieval.

Apply database development, administration, and performance-tuning best practices to ensure reliable data operations.

Software Development and Quality Assurance

Translate technical specifications and business requirements into functional, tested, and maintainable applications.

Write high-quality, reusable, and well-documented code using appropriate design patterns and development standards.

Design, code, compile, test, debug, and maintain ETL applications and supporting software components.

Conduct unit testing, troubleshoot technical issues, and resolve defects throughout the development and implementation process.

Participate in development, testing, quality assurance, deployment, migration, and post-implementation support activities.

Use Git and established source control practices to manage code changes, collaborate with development teams, and maintain version history.

Contribute to continuous improvement by identifying opportunities to enhance system performance, automation, reliability, and maintainability.

Data Modeling, Documentation, and Reporting

Develop and maintain technical documentation, including ETL source-to-target mappings, data model diagrams, architecture artifacts, technical specifications, and detailed design documents.

Document data flows, transformation rules, scheduling dependencies, business logic, and system processes to support ongoing maintenance and knowledge transfer.

Collaborate with business analysts, data architects, database administrators, developers, and other stakeholders to understand data requirements and deliver effective solutions.

Support the development of dashboards, scheduled reports, ad hoc reports, and key performance indicator (KPI) visualizations using Power BI and related reporting tools.

Ensure data…