Analytics Data Specialist

Home Hardware Stores; St. Jacobs; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A retail organization in St. Jacobs is seeking an Analytics Data Specialist to design and build scalable data models and automate data processes. The ideal candidate will have a Bachelor's degree in Computer Science and over 10 years of experience in ETL development, along with strong skills in SQL Server and data warehousing. This position offers a competitive salary, comprehensive benefits, and a hybrid work model.

Benefits

Competitive salary

Annual incentive/bonus program

Comprehensive health benefits

Defined contribution pension plan

Discounts at retail stores

Three weeks of vacation

Qualifications

• 10+ years' experience in ETL development is required.
• Strong experience in database technologies is essential.
• Proven track record of meeting deadlines in projects.

Responsibilities

• Design and build scalable data models.
• Automate data throughput from source to report.
• Ensure data integrity used for analysis.

Skills

Data modeling

SQL Server

ETL development

PowerShell scripting

Python

R

Education

Bachelor's degree in Computer Science

Tools

Azure DB

SSIS

Job description

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 organization.
• Support Analytics interaction with third parties and services related to data-driven activities and tools.
• Identify backup and archive strategies.
• Ensure operational activities are completed daily, weekly, and monthly, and troubleshoot when required.

What we’re looking for :

• Bachelor’s degree in Computer Science, with 10+ years’ experience in ETL development.
• Strong experience in database technologies (SQL Server, Azure DB); data warehousing; PowerShell scripting; ETL/ELT (SSIS) development and deployment; cloud platform-as-a-service; and programming languages such as Python and R.
• Experience working on small to large business and system projects, focusing on Data Analytics, with a proven track record of meeting deadlines.
• Excellent written and verbal communication skills, with the ability to work collaboratively within a team.
• Understanding of IT concepts, standards, procedures, and policies, including 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 a fast-paced, technical environment, capable of handling multiple demands and priorities.
• Ability to work onsite three days a week at our corporate office in St. Jacobs, supporting our hybrid work model.

What Home offers :

• Competitive salary.
• Annual incentive/bonus program.
• Comprehensive benefits including health, dental, vision, paramedical, disability coverage, out-of-country travel insurance, life insurance, and employee assistance programs.
• Defined contribution pension plan with company match and flexible contribution levels.
• Group RRSP.
• Discounts at our retail stores.
• WorkPerks discounts by Venngo.
• Home & Auto Insurance discounts.
• Starting with three weeks of vacation.
• Personal and sick time.

Home Hardware values diversity and encourages applicants from all communities in Canada. If you need accommodations during the recruitment process, please let us know.

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