Junior Data Analyst
- Lavaltrie, QC, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Experience
- 1 to 3 years of relevant work experience in data analytics or BI (an asset)
- Posting language
- English
- Posted
Original job description
Do you want to join the ranks of a company that has the well-being of its employees at heart and who continually invests in realizing the potential of its team? Vetoquinol is the employer of choice with whom you want to collaborate and innovate. Vetoquinol is a pharmaceutical company dedicated to the manufacturing, distribution and marketing of animal health products. We are looking for a Junior Data Analyst to join our team.
The Junior Data Analyst, Quality and BI Support is responsible for the smooth daily functioning of business intelligence environments. He or she ensures the execution of recurring tasks, the maintenance of reference data, the monitoring of data processing and refreshes as well as the support of users of the various business intelligence tools and reports. He works closely with the business intelligence team to ensure the continuity of operations, the quality of data and the continuous improvement of existing practices and processes.
MAIN ACTIVITIES :
Monitoring and Operation
- Monitor pipelines, SQL Server jobs, and Power BI dataset refreshes.
- Troubleshoot first-level processing failures, restart jobs when required, and escalate more complex issues to the Business Intelligence team.
- Performs scheduled or one-time tasks related to data loads, extractions, and period closes.
Maintenance and Data Quality
- Update master data, including product and customer hierarchies, mapping tables, and other reference data.
- Perform data quality checks to identify discrepancies, duplicates, missing values, or other anomalies.
- Document anomalies and follow up with the appropriate stakeholders.
User Support
- Respond to requests and incidents related to Power BI reports and connected Excel files.
- Assist users in the effective use of existing reports and BI tools.
Documentation and Continuous Improvement
- Document and maintain operating procedures, business processes, data flows, and the incident log.
- Identify and 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.
- 1 to 3 years of relevant work experience in data analytics or BI (an asset)
- Basic knowledge of SQL (SELECT queries, joins, filters).
- Proficiency with Excel, including PivotTables, XLOOKUP and VLOOKUP.
- Knowledge of Power BI Service.
- Interest in Microsoft Fabric and the Microsoft data ecosystem.
- Rigor, organizational skills and ability to perform recurring tasks with precision.
- Strong communication skills and a customer service-oriented mindset.
- Ability to communicate technical information clearly to both technical and non-technical audiences.
- Bilingualism (French and English), both spoken and written.
By joining our team, in addition to having a rewarding human experience, you will have access to a comprehensive range of benefits, including:
- Modular group insurance coverage starting on your first day
- Health and well-being allowance
- Employee assistance programme
- Telemedicine platform
- Flexible working hours
- Work-life balance
- Annual holidays recognised according to experience
- Paid personal days
- Access to ongoing training
SPECIFIC CONDITIONS FOR THE EXERCISE OF THE FUNCTION:
- Hybrid work arrangement: three (3) days per week in the office and two (2) days per week working remotely.
- This role requires ongoing communication and collaboration with Francophones and Anglophones across Canada and/or internationally. In order to fully meet language requirements and ensure effective management of interactions, fluency in French and English is essential.
More about this job
Responsibilities
Monitor data pipelines, SQL Server jobs, and Power BI refreshes; troubleshoot routine failures and perform scheduled data tasks. Maintain reference data and data quality, support BI users, document operational processes, and identify opportunities to automate recurring work.
Requirements
A college diploma or bachelor's degree in computer science, information systems, or a related field is requested, along with basic SQL knowledge and proficiency in Excel. The role seeks familiarity with Power BI Service and interest in Microsoft Fabric, as well as strong organization and communication skills; one to three years of relevant experience is an asset, and fluency in French and English is essential.
Skills
- SQL
- Excel
- PivotTables
- XLOOKUP
- VLOOKUP
- Power BI Service
- Microsoft Fabric
- Data Quality Checks
- Data Monitoring
- Troubleshooting
- Master Data Maintenance
- Business Intelligence Support
- Documentation
- Communication
- Organization
- Customer Service
Benefits
- Modular Group Insurance Coverage Starting on the First Day
- Health and Well-Being Allowance
- Employee Assistance Program
- Telemedicine Platform
- Flexible Working Hours
- Work-Life Balance
- Annual Vacation Based on Experience
- Paid Personal Days
- Ongoing Training
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Customer Service & Support
- Healthcare
Keywords
- Business Intelligence
- Data Analytics
- SQL
- SQL Server
- Power BI
- Power BI Service
- Microsoft Fabric
- Microsoft Data Ecosystem
- Excel
- PivotTables
- XLOOKUP
- VLOOKUP
- Data Pipelines
- Dataset Refreshes
- Data Loads
- Data Extractions
- Master Data
- Product Hierarchies
- Customer Hierarchies
- Mapping Tables
- Reference Data
- Data Quality
- Data Processing
- Incident Management
- Process Documentation
- Automation
- Pharmaceuticals
- Animal Health
- French
- English