Developer, Business Intelligence

About Gildan

Gildan is a prominent manufacturer specializing in everyday basic apparel. It boasts a diverse portfolio of strong brands, including Gildan®, Hanes®, Comfort Colors®, American Apparel®, ALLPRO™, GOLDTOE®, Peds®, Bali®, Playtex®, Maidenform®, Bonds®, and holds an exclusive licensing agreement for Champion® in the U.S. and Canadian printwear markets. The company owns vertically integrated, large-scale manufacturing plants located primarily across Central America, the Caribbean, North America, and Asia. Gildan emphasizes adherence to high standards in labor, environmental, and governance practices as part of an extensive ESG program integral to its long-term business plans. Their team is united by the vision of Making Apparel Better®.

Role Overview

The Business Intelligence Developer will be tasked with interpreting organizational data needs, documenting those requirements, and designing, developing, and maintaining analytics and reporting solutions accordingly. Responsibilities include data modeling, integration, and management of reporting processes aligned with business objectives. The role involves independently managing projects from start to finish, ensuring that the solutions delivered are efficient, accurate, and comply with specifications. This position reports to the Developer, Business Intelligence within the IT Department.

Key Duties

• Extract, transform, and load (ETL) data from varied sources into the Snowflake database, also assisting BI Analysts and various departments in data integration activities.
• Interpret and translate well-defined technical requirements into data warehouse, database, and BI system architectures.
• Develop, maintain, test, and review code for queries, scripts, stored procedures, database objects, indexes, triggers, and related components.
• Utilize advanced SQL performance tuning skills to analyze execution plans, detect query inefficiencies, implement enhancements, and document solution performance metrics.
• Develop use cases and actively contribute to User Acceptance Testing (UAT) in cooperation with teammates and stakeholders.
• Identify, document, and address issues throughout development and testing phases promptly and effectively.

Required Qualifications

• A bachelor’s degree in Computer Science, Information Technology, Information Systems, or a closely related discipline.
• At least five years’ experience focused on data warehousing and ETL development, with expertise in Electronic Data Interchange (EDI) processes and Python programming.
• Comprehensive understanding of data modeling concepts, query optimization, data accessibility, and the design and deployment of ETL and data quality mechanisms.
• Familiarity with DevOps tools such as GIT, Jenkins, and Sonar.
• Deep knowledge of database management, including data transfer methods, user and role administration, privileges, schema and object handling, and session supervision.

Benefits and Culture

• Work for a publicly traded company listed on NYSE and TSX with promising growth.
• Engage in a collaborative work environment emphasizing meaningful relationships and teamwork.
• Collaborate with a multicultural workforce operating locally and internationally.
• Access mentorship programs and opportunities for ongoing professional development.
• Enjoy competitive benefits packages.

Additional Information

Applicants are encouraged to highlight their transferable skills and unique experiences in their applications. Only candidates shortlisted for interviews will be contacted. Gildan is committed to fostering an inclusive workplace where everyone feels respected and empowered to succeed. They welcome candidates from all backgrounds to join and shape their careers going forward.