Junior Data Analyst
Role Overview
Supports the daily operation of business intelligence environments, recurring tasks, reference data, data processing and refreshes, and BI tool users.
Works with the BI team to maintain operational continuity, data quality, and improvement of existing practices and processes.
Key Skills for This Role
Full Job Posting
Role overview
Supports the daily operation of business intelligence environments, recurring tasks, reference data, data processing and refreshes, and BI tool users.
Works with the BI team to maintain operational continuity, data quality, and improvement of existing practices and processes.
Monitoring and operations
- Monitor pipelines, SQL Server jobs, and Power BI dataset refreshes.
- Troubleshoot first-level processing failures, restart jobs when needed, and escalate complex issues to the BI team.
- Perform scheduled or one-time data loads, extractions, and period-close tasks.
Data quality and user support
- Maintain product and customer hierarchies, mapping tables, and other reference data.
- Check for data discrepancies, duplicates, missing values, and other anomalies; document findings and follow up with stakeholders.
- Respond to Power BI report and connected Excel incidents and requests, and help users use BI tools and reports.
Documentation and improvement
- Maintain operating procedures, business processes, data flows, and the incident log.
- Recommend automation opportunities to reduce manual tasks and improve operational efficiency.
Profile
- College diploma or bachelor's degree in computer science, information systems, or a related field.
- One to three years of relevant data analytics or BI experience is an asset.
- Basic SQL knowledge, including SELECT queries, joins, and filters.
- Proficiency with Excel, including PivotTables, XLOOKUP, and VLOOKUP; knowledge of Power BI Service.
- Interest in Microsoft Fabric and the Microsoft data ecosystem.
- Rigor, organization, precision, strong communication, and a customer-service-oriented mindset.
- Ability to communicate technical information to technical and non-technical audiences.
- Fluency in spoken and written French and English is essential.
Work arrangement
- Hybrid arrangement: three days per week in the office and two days working remotely.
- The role involves ongoing collaboration with French- and English-speaking colleagues across Canada and/or internationally.
Benefits
- Benefits include modular group insurance from the first day, a health and well-being allowance, an employee assistance programme, and telemedicine.
- Other offerings include flexible hours, work-life balance, annual holidays based on experience, paid personal days, and ongoing training.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career