Data Analytics Owner: SQL, ETL & DWH Specialist

iTeckSoft Inc.; Canada; On-site; CAD 75,000 - 95,000; Full time

Job summary

A technology company's data team in Canada is looking for a skilled Data Analyst to work on data-driven projects. The ideal candidate should have strong SQL skills, experience in data warehousing, and proficiency with ETL tools. As part of the team, you will analyze data from various sources, ensure data quality, and create insightful dashboards. This is a mid-senior level contract position focused on integrating and cleansing data for impactful reporting.

Qualifications

• Strong proficiency in SQL including joins and window functions.
• Hands-on experience with ETL tools and data warehousing.
• Knowledge of MDM, SCD, and CDC methodologies.

Responsibilities

• Analyze and transform data from multiple sources.
• Perform data profiling and quality checks.
• Develop SQL queries and optimize data processes.
• Create reports and dashboards for stakeholders.
• Implement data governance standards.

Skills

SQL proficiency

ETL tools experience

Data Warehousing concepts

Data cleansing

Deduplication methods

API-based data integration

Data quality frameworks

Analytical skills

Tools

Power BI

Tableau

Job description

A technology company's data team in Canada is looking for a skilled Data Analyst to work on data-driven projects. The ideal candidate should have strong SQL skills, experience in data warehousing, and proficiency with ETL tools. As part of the team, you will analyze data from various sources, ensure data quality, and create insightful dashboards. This is a mid-senior level contract position focused on integrating and cleansing data for impactful reporting.