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