Direct message the job poster from ALOIS SolutionsAnalytics Enthusiast # Hiring for Full Time & Contract roles all across USA & CanadaJob title: Senior AnalystLocation: RemoteDuration: Full time/Permanent rolePosition OverviewThe 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 SkillsMust-Have:Intermediate to advanced SQL skills (complex queries, stored procedures)Experience with data quality managementProficiency with ExcelUnderstanding of data modeling conceptsComprehensive ETL process knowledge and experience, including:Understanding of data extraction methods from various source systems (CRM, transaction systems,



etc.)Experience designing and implementing data transformations for sales crediting rulesKnowledge of data loading best practices and validation proceduresAbility to monitor ETL workflows and troubleshoot failuresExperience documenting ETL processes for business and technical audiencesUnderstanding of incremental load strategies vs. full replacement loadsExperience with data reconciliation between source and target systemsAbility to optimize ETL processes for performanceKey ResponsibilitiesDesign and implement reporting solutions for sales attributionDesign and monitor ETL processes for sales data integrationDevelop data transformation rules for complex sales attribution scenariosLead root cause analysis for data discrepancies and system issuesDevelop and maintain documentation for sales crediting processesCreate and maintain data quality monitoring proceduresExecute routine data quality checks and monitoringSupport ad-hoc reporting requests related to sales creditingAssist with testing of system enhancementsSeniority levelMid-Senior levelEmployment typeFull-timeJob functionBusiness Development and SalesIndustriesIT Services and IT Consulting

📌 Senior Analyst (Mississauga)
🏢 ALOIS Solutions
📍 Mississauga