Senior ETL Developer

We are looking for a highly experienced Senior ETL Developer to design, develop, and optimize enterprise-grade data and application solutions. This role requires deep expertise in ETL development, cloud platforms (Azure & AWS), and web application engineering. The successful candidate will act as a technical expert, driving best practices, and ensuring the reliability and scalability of our systems.

Key Responsibilities

• Design and Architect scalable ETL pipelines using SSIS and Azure Data Factory, ensuring high performance and fault tolerance.
• Define and implement incremental loading strategies for large-scale data processing.
• Oversee and optimize MS SQL Server databases, ensuring data security, high availability, and query performance tuning.
• Move AWS Elastic Beanstalk applications and EC2 instances to Azure infrastructure.
• Provide technical leadership in building and maintaining C# .NET Core web applications integrated with cloud infrastructure.
• Drive DevOps strategy across the services organization using Azure & AWS
• Manage Azure Blob Storage for enterprise-grade storage solutions with cost optimization and data governance.
• Collaborate with stakeholders to understand business needs and translate them into technical solutions.
• Conduct code reviews and establish engineering best practices.
• Proactively troubleshoot and resolve complex issues across data, application, and cloud environments.
  
  

Required Skills & Experience

• 7+ years of hands-on experience in ETL development, data integration, and database management.
• Proven expertise in SSIS and Azure Data Factory, with strong understanding of data transformation and incremental load techniques.
• Advanced knowledge of MS SQL Server (T-SQL, query optimization, indexing, stored procedures).
• Strong experience with AWS services (Elastic Beanstalk, EC2, IAM, CloudWatch).
• Hands-on expertise in developing and deploying C# .NET Core web applications.
• Deep knowledge of Azure Blob Storage and Azure DevOps pipelines.
• Proficiency in AWS DevOps practices (monitoring, and automation).
• Strong problem-solving skills and ability to design solutions for complex, high-volume environments.
• Excellent leadership, communication, and collaboration skills.
  
  

Preferred Qualifications

• Experience with containerization (Docker, Kubernetes) for application and ETL workloads.
• Knowledge of hybrid cloud data strategies and enterprise architecture patterns.
• Strong understanding of cloud security frameworks for Azure and AWS
  
  

Benefits

• Paid Parental Leave
• Flexible PTO
• Certification(s) reimbursement
• Summer Fridays
• Extended Medical, Dental, Paid Sick Days, Vision, Life Insurance, and Disability Leave Coverage
• RRSP & Employer match
  
  

Equal Employment Opportunity: CARET is an Equal Opportunity, Affirmative Action Employer. The compensation information below is provided in compliance with job posting disclosure requirements.

Pay range: $110,000 - $113,000. Actual base pay will depend on varying circumstances, including the position, location, individual qualifications, market finances, and other operations business needs.

Depending on the position, compensation may also include commission, bonuses, etc. Potential for bonuses is based on company performance and potential for merit increases is based on performance.