Senior Data Analyst

Ontario, Canada
Remote
Posted Nov 10, 2026
1 position

$80,000–$110,000 / year

Opens LinkedIn

Employment type: Full-time
Experience level: Senior
Minimum education: Bachelor’s degree
Posting language: English
Location requirements: Country, Ontario, Canada
Application method: Apply on LinkedIn (LinkedIn sign-in required)

Job summary

Build and maintain the full BI stack, including data pipelines, ERP data integration, warehousing, modeling, reporting, and visualization, to deliver actionable business insights. Collaborate with stakeholders, manage concurrent projects, mentor junior analysts, and document and support implemented solutions.

Job details

The Senior Data Analyst will play a key role in developing and maintaining the organization's Business Intelligence (BI) infrastructure, transforming complex data from multiple ERP systems into meaningful insights that support business decisions. This position offers end-to-end ownership of the BI stack, including data integration, pipeline development, data modelling, warehousing, reporting and visualization. The ideal candidate is a technically strong data professional with hands-on experience building scalable ETL/ELT pipelines, advanced SQL capabilities and experience working across multiple ERP platforms. This individual will thrive in a fast-paced environment, demonstrate strong problem-solving skills and enjoy collaborating with stakeholders while providing technical guidance and mentorship to junior analysts. What We Offer: Salary: $80,000–$110,000 CAD + 10–15% annual bonus Job Type: Full-time, permanent Work Arrangement: Fully remote Environment: Opportunity to take ownership of the full Business Intelligence stack and work with multiple ERP platforms in a dynamic, collaborative environment. Career Development: Opportunity to mentor junior analysts, work with modern data technologies and contribute to ongoing technology and process improvements. What You'll Do: Design, build and maintain scalable ETL/ELT data pipelines to extract, transform and integrate information across multiple ERP systems and source platforms. Own the full Business Intelligence stack, including data ingestion, warehousing, data modelling, pipeline orchestration, reporting and visualization. Extract, consolidate and analyze data from multiple ERP systems to deliver meaningful business insights. Develop and maintain interactive dashboards, reports, diagrams and visualizations using tools such as Power BI and Tableau. Build and maintain applications and automated processes to streamline data file consumption, processing and integration. Perform complex data extraction, storage, manipulation and analysis using advanced SQL and other data technologies. Develop and maintain robust databases and data systems, ensuring data accuracy, integrity and quality. Utilize Python and Microsoft technologies to develop solutions, automate processes and improve data management. Leverage Microsoft Power Apps and Power Automate to support business automation and workflow improvements. Collaborate with cross-functional stakeholders to understand business requirements and translate them into technical specifications and effective data solutions. Provide technical recommendations and solutions based on the organization's existing IT portfolio and business requirements. Manage stakeholder expectations throughout project implementation, clearly communicating timelines, deliverables and potential challenges. Manage multiple concurrent projects and adapt quickly to changing business priorities. Mentor and provide technical guidance to junior analysts, reviewing work and supporting their development in data pipelines, analytics and BI tools. Document completed solutions, coordinate knowledge transfer and provide training to relevant stakeholders and support teams. Stay current with emerging technologies, ERP platforms, data integration methodologies and modern BI practices. What We're Looking For: Bachelor's degree in Computer Science, Business Analysis, Data Science, Data Analytics or a related discipline. Minimum of four years of relevant data analytics experience, including hands-on experience designing and developing data pipelines. Experience working with ERP systems such as NetSuite, Yardi, Jonas, Sage or similar enterprise platforms. Strong understanding of the full BI stack, including data warehousing, ETL/ELT development, data modelling and visualization. Advanced SQL skills, including joins, CTEs, stored procedures, functions, subqueries, query tracing and performance tuning. Demonstrated experience architecting, developing and maintaining ETL/ELT pipelines, including scheduling, orchestration, monitoring and data quality practices. Programming experience with Python. Experience with Microsoft Power BI, Power Apps and Power Automate. Strong knowledge of Microsoft technologies, including Windows, SQL Server and Microsoft cloud tools. Knowledge of statistics and experience using analytical tools and technologies such as Excel, SQL, SSIS or SAS. Experience working with multiple ERP platforms simultaneously is preferred. Understanding of ERP data structures, system integrations and data migration methodologies is an asset. Experience with application development, cloud-based data platforms and modern data architecture is considered an asset. Demonstrated ability to mentor or guide junior analysts and provide technical direction. Strong analytical, problem-solving and critical-thinking skills. Excellent communication, presentation and stakeholder management capabilities. Ability to manage multiple projects, shifting priorities and competing deadlines in a fast-paced environment. A proactive, adaptable and technically curious individual with a genuine interest in continuous learning and innovation. If you are an experienced data professional looking to take ownership of a full BI environment, work across multiple ERP platforms and turn complex data into actionable business insights, we invite you to apply today! Since 1951, Drake International has been a global leader in integrated human capital solutions, delivering tailored services in recruitment, assessment and upskilling, operational efficiency, healthcare, and workplace wellbeing. We partner directly with employers to offer candidates the best opportunities at no cost, with a human-centered approach. Recruitment decisions are led by our team. We may occasionally pilot AI-supported screening tools to support efficiency, but they are not a fixed part of our selection process. All hiring decisions are made by people, and candidates will be informed if any AI tool is involved in their assessment in accordance with the Employment Standards Act. Drake International is an equal opportunity employer committed to accessibility, inclusivity, and diversity. Accommodation is available throughout the recruitment process. If you require accommodation, please contact your Branch Representative.

What you’ll do

Requirements

Requires a bachelor's degree in a relevant discipline and at least four years of data analytics experience, including hands-on pipeline development and experience with ERP systems. Candidates should have advanced SQL and Python skills, knowledge of Microsoft BI and automation tools, and strong analytical, communication, stakeholder-management, and mentoring abilities.