Etl Developer

HOLT RENFREW; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

A luxury retail company in Toronto is seeking an experienced ETL Developer. You will design and implement data pipelines, troubleshoot software issues, and maintain relationships with business units. The ideal candidate has 5+ years of experience with SAP HANA, SQL development, and ETL solutions. This position offers competitive compensation and a commitment to diversity and inclusion.

Benefits

Competitive total compensation

Generous employee discount

Health & dental benefits

Tuition assistance

Continuous learning and development

Qualifications

• Bachelor's Degree in technical field or Business Administration.
• Minimum 5 years experience in ETL solutions.
• Experience designing and implementing data warehouses.

Responsibilities

• Translate technical specifications into working applications.
• Troubleshoot technical problems with software packages.
• Assess health and performance of software applications.

Skills

ETL Solutions Design

SAP HANA

SQL Development

SAP ABAP

Data Warehousing

Agile Methodologies

Programming Internet-ready applications

Education

Bachelor's Degree in a technical related field

Tools

SAP HANA

SQL Server

MSSQL

Power BI

Azure Data Factory

JIRA

Jenkins

Confluence

Job description

Holt Renfrew offers you an inspiring, fashion-driven environment with opportunities to learn and grow. From our incredible partnerships with iconic luxury brands, to our commitments to corporate social responsibility, you will be inspired every day.

A job at Holt Renfrew offers a competitive total compensation, a generous employee discount, pension, and health & dental benefits, tuition assistance, and continuous learning and development.

Reporting to the Manager, Information Management Systems, the ETL Developer will utilize their skills to Design, implement, maintain and continuously expand data pipelines by performing extraction, transformation, and loading activities.

Specific responsibilities include (but are not limited to) the following:

• Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.
• Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.
• Assesses the health and performance of software applications and databases.
• Establishes, participates, and maintains relationships with business units, customers and subject matter experts in order to remain apprised of direction, project status, architectural and technology trends, risks, and functional/integration issues.
• Preform ad-hoc loading activities required by business users (e.g. Lease Vendor Rate table, planning hierarchy)
• Assist with system update activities

The ideal candidate:

• Bachelor's Degree in technical related field (Sciences, Information Systems, Technology, Engineering) or Business Administration
• Minimum of 5 years experience in the following:
• Demonstrates experience designing, documenting, developing, and implementing ETL solutions
• Proficient in SAP HANA, SQL development - eg - Stored Procedures, calculation views
• Experience with SAP ABAP development - eg Standard extractor, process chain
• Experience in designing data warehouses and data marts for databases such as SAP HANA, SQL Server
• Experience with Integration frameworks (e.g., Mule, Camel) desirable
• Experience with performing unit testing, System Integration Testing and User Acceptance Testing
• Sound knowledge of SAP SLT, ECC and CAR
• Sound knowledge of MSSQL, Microstrategy, Azure Data Factory, and Power BI
• Knowledge and experience with programming Internet-ready application.
• Experience with Scrum and other Agile processes
• Knowledge of JIRA, Jenkins, Confluence

The measures of success:

• Contribution to financial objectives
• Individual objectives linked to the achievement of department goals
• Feedback from internal and external clients

Holt Renfrew is an equal opportunity employer committed to fostering a diverse and inclusive workplace. Our future success depends on the perspectives and contributions of all our employees -- their diverse backgrounds, abilities and experiences make our business stronger. If you are contacted for a job opportunity and require accommodation, please email [e-mail] and let us know so we can ensure you have an accessible candidate experience throughout the recruitment process. All requests are confidential and used only to meet candidate needs.