ETL Developer

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 careers@holtrenfrew.com 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. #J-18808-Ljbffr