Senior Analyst

ALOIS Solutions; Canada; Remote; CAD 80,000 - 100,000; Full time

Job summary

An established industry player is seeking a Senior Analyst to join their dynamic team. This remote position offers an exciting opportunity to bridge the gap between business stakeholders and technical implementation. The ideal candidate will possess advanced SQL skills and a strong background in data quality management, along with expertise in ETL processes. You will be responsible for designing reporting solutions, monitoring data integration, and ensuring data quality for sales attribution processes. If you are passionate about data and eager to make a significant impact in a collaborative environment, this role is perfect for you.

Qualifications

• Intermediate to advanced SQL skills and data quality management experience required.
• Proficiency in Excel and understanding of ETL processes is essential.

Responsibilities

• Design and implement reporting solutions for sales attribution.
• Monitor ETL processes and develop data transformation rules.

Skills

SQL

Data Quality Management

Excel

Data Modeling Concepts

ETL Processes

Troubleshooting ETL Failures

Data Reconciliation

Performance Optimization

Job description

Direct message the job poster from ALOIS Solutions

Analytics Enthusiast # Hiring for Full Time & Contract roles all across USA & Canada

Job title: Senior Analyst

Location: Remote

Duration: Full-time/Permanent role

Position Overview

The Analyst will bridge the gap between business stakeholders and technical implementation for the Sales Crediting System. This role will translate business requirements, analyze data patterns, design reporting solutions, and support strategic decision-making for sales attribution processes.

Technical Skills

Must-Have:

1. Intermediate to advanced SQL skills (complex queries, stored procedures)
2. Experience with data quality management
3. Proficiency with Excel
4. Understanding of data modeling concepts
5. Comprehensive ETL process knowledge and experience, including:
1. Understanding of data extraction methods from various source systems (CRM, transaction systems, etc.)
2. Experience designing and implementing data transformations for sales crediting rules
3. Knowledge of data loading best practices and validation procedures
4. Ability to monitor ETL workflows and troubleshoot failures
5. Experience documenting ETL processes for business and technical audiences
6. Understanding of incremental load strategies vs. full replacement loads
7. Experience with data reconciliation between source and target systems
8. Ability to optimize ETL processes for performance

Key Responsibilities

1. Design and implement reporting solutions for sales attribution
2. Design and monitor ETL processes for sales data integration
3. Develop data transformation rules for complex sales attribution scenarios
4. Lead root cause analysis for data discrepancies and system issues
5. Develop and maintain documentation for sales crediting processes
6. Create and maintain data quality monitoring procedures
7. Execute routine data quality checks and monitoring
8. Support ad-hoc reporting requests related to sales crediting
9. Assist with testing of system enhancements

Seniority level

Mid-Senior level

Employment type

Full-time

Job function

Business Development and Sales

Industries

IT Services and IT Consulting