Senior Data Analyst

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.