Job Title: Software Developer – ETL (Senior)

Work Arrangement

Onsite (5 days per week)

---

Role Summary

The Senior ETL Software Developer is responsible for designing, developing, and maintaining scalable data pipelines and analytics solutions across cloud-based and enterprise data platforms. The role focuses on ETL development, data integration, data modeling, and performance optimization to support data warehouse, data lake, and business intelligence solutions.

---

Key Responsibilities

• Design, develop, and maintain ETL pipelines for structured and semi-structured data sources

• Perform data extraction, transformation, and loading for both initial and incremental loads

• Translate technical and business requirements into working, tested ETL solutions

• Develop detailed programming specifications and write high-quality, reusable code

• Build and maintain scheduling and dependency logic for ETL workflows

• Conduct unit testing, debugging, and performance tuning of ETL processes

• Investigate data issues, identify root causes, and propose corrective solutions

• Ensure data architecture is scalable, maintainable, and aligned with best practices

• Create and maintain technical documentation (ETL mappings, data models, architecture diagrams)

• Collaborate with business and technical stakeholders throughout the SDLC

• Provide post-implementation support, including troubleshooting and enhancements

---

Mandatory Technical Skills

• Strong experience with Microsoft Azure data technologies, including:

  • Azure Data Factory

  • Azure SQL Database

  • Azure Data Lake

  • Power BI

• Hands-on experience with the Databricks platform

• Experience with AWS data services, including:

  • Amazon Aurora

  • Amazon Relational Database Service

  • AWS Glue

  • OpenSearch

• Strong experience developing ETL solutions across multiple data repositories

• Expertise in data integration, data cleansing, and data analytics

• Strong knowledge of data modeling and design principles for data marts and data warehouses

• Experience designing modern analytics architectures (data warehouses, data lakes, lakehouses)

• Advanced SQL skills, including complex queries and performance tuning

• Experience with database management and administration

• Experience using Git and source control strategies

• Strong understanding of the full Software Development Life Cycle (SDLC)

---

General Development & Analysis Skills

• Experience in application design, coding, testing, debugging, and documentation

• Familiarity with structured development methodologies

• Ability to elicit, document, and validate business requirements

• Experience collaborating with cross-functional IT and business teams

• Strong analytical, problem-solving, and decision-making skills

• Proven ability to meet deadlines and work independently or as part of a team

---

Nice-to-Have Skills

• Experience designing dashboards and reports (scheduled and ad-hoc) highlighting KPIs and trends

• Programming experience with C#, APIs, or cloud-based functions

• Scripting experience using PowerShell or other scripting languages

• Experience with middleware, gateways, or integration platforms

• Knowledge of AODA and accessibility standards

• Experience conducting design walkthroughs and providing user/system documentation