Analytics Data Specialist

Home Hardware has an exciting opportunity available for an Analytics Data Specialist to join our Strategy and Management team. Reporting to the Manager, Analytics, you will be responsible for championing the development of best practice data acquisition, data movement and data modeling, with the goal of providing valuable business insights through an enterprise Analytics centre-of-excellence.

If you are a strong collaborator with solid data warehousing knowledge and experience, we’d love to hear from you!

What you’ll do:

• Design and build scalable, high performing business centric data models.
• Design processes to automate the throughput of data from source to report.
• Extend the company’s cloud data warehouse with internal and third-party sources of information when needed.
• Process, cleanse, and verify the integrity of data used for analysis.
• Assist in design and data maintenance of the Data Warehouse (DW), Data Marts (DM), and other Data Stores.
• Support Analytics change management across the corporation.
• Support Analytics interaction with 3rd parties and services as it relates to data driven activities and related tools.
• Identify backup/archive strategies.
• Ensure daily/weekly/monthly operational activities are completed and troubleshoot when required.

What we’re looking for:

• Bachelors’ degree in Computer Science, with 10 + years’ experience in ETL development.
• Strong experience in database technologies (SQL Server, Azure DB); data warehousing; PowerShell scripting, and ETL/ELT (SSIS) development and deployment; PowerShell scripting, cloud platform-as-a-service, and various programming languages (Python, R).
• Experience working on small, medium to large business and system projects, with a focus on Data Analytics and a proven track record of meeting strict time and project deadlines.
• Excellent written and verbal communication skills, with the ability to work collaboratively within a team.
• Understanding of Information Technology concepts, standards, procedures, and policies including in-depth knowledge of requirement analysis and modeling tools and techniques.
• Creative thinker with the ability to see the big picture.
• Results oriented with a focus on quality.
• Excellent analytical, problem-solving, organizational, and attention to detail skills.
• Adaptable and flexible in working in a fast-paced and technical environment, with the ability to handle multiple demands and competing priorities.
• Ability to be onsite three days a week at our corporate office in St. Jacobs, to accommodate our hybrid working model.

What Home offers:

• Competitive Salary.
• Annual Incentive/Bonus Program.
• Comprehensive Benefits Program including:Health, Dental, Vision, Paramedical, Disability Coverage, Out of Country Travel Insurance, Life Insurance, Employee Family Assistance Program.
• Defined Contribution Pension Plan with Company Match, and choice of contribution level.
• Group RRSP.
• Discount from our corporate retail stores.
• WorkPerks© by Venngo discounts.
• Home & Auto Insurance discounts.
• 3-weeks’ vacation to start.
• Personal and sick time.

Home Hardware recognizes the value of a diverse team. We believe that different perspectives, backgrounds, and experiences make us stronger as an organization. Applicants representing the full diversity of communities in Canada are encouraged to apply with confidence. Please let us know if you require accommodation during the recruitment process.

We thank all applicants for their interest, however only those applicants selected for an interview will be contacted.

#HP