Business Systems Analyst

Clarity Recruitment; Toronto; Remote; CAD 100,000 - 125,000; Full time

Job summary

Une entreprise de recrutement réputée recherche un Analyste des Systèmes d'Affaires pour soutenir la transition de 200 rapports d'un système Microsoft AX vers un nouvel ERP. Le candidat devra posséder une expertise technique en SQL et Power BI pour optimiser les rapports financiers tout en travaillant dans un environnement collaboratif. Si vous êtes passionné par l'optimisation des reporting et que vous aimez résoudre des problèmes techniques, n'hésitez pas à postuler!

Qualifications

• Expérience avec MS Dynamics 365 (ou ERP similaire).
• Compétences avancées en SQL pour la manipulation de données.
• Proficient en Power BI pour la création de jeux de données.

Responsibilities

• Analyser et transférer plus de 200 rapports de Microsoft AX vers Dynamics 365.
• Collaborer avec des architectes techniques et des parties prenantes pour définir les besoins en reporting.
• Développer et optimiser des ensembles de données Power BI.

Skills

SQL

Power BI

Data mapping

Finance systems expertise

Technical problem-solving

Education

Experience with MS Dynamics 365

Experience with data warehousing

Tools

SSRS

Azure

Job description

This range is provided by Clarity Recruitment. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

CA$75.00 / hr - CA$80.00 / hr

The Opportunity

Our client is seeking a Business Systems Analyst to support the transition of over 200 reports and applications from a legacy Microsoft AX system to a new ERP. This role requires a technical analyst with expertise in SQL, Power BI, and finance systems, who can facilitate data mapping, report specifications, and system transition while ensuring business users have access to accurate and actionable reporting tools. This role is mostly remote, with occasional in-office meetings (once every other week). If you're a technical problem-solver with strong finance system expertise and a passion for optimizing business reporting, apply today!

Key Responsibilities

• Analyze and transition 200+ reports from Microsoft AX to Dynamics 365
• Collaborate with technical architects, business analysts, and stakeholders to map data, define reporting needs, and streamline reporting processes
• Develop and optimize Power BI datasets that are business-friendly and enable users to create their own visualizations
• Assess and eliminate redundant reports, ensuring only essential reporting functions are carried over to the new system
• Review source code and report files within SSRS and other reporting tools to understand data structures and reporting logic
• Assist with data extraction, transformation, and load (ETL) processes to ensure seamless integration into the new ERP
• Support the documentation of key reporting processes, mitigating the lack of existing documentation

Core Qualifications

• Experience with MS Dynamics 365 (or similar ERP)
• Strong SQL skills for querying and data manipulation
• Proficiency in Power BI for dataset creation and report development
• Experience with Azure and SSRS in a finance systems environment
• Ability to work in a small, flexible team within a complex and transitioning environment
• Experience with data warehousing and financial reporting structures is ideal
• Familiarity with finance and accounting principles to understand reporting requirements is an asset

Next Steps :

• We here at Clarity Recruitment would like to thank you for your application
• Only those chosen for a phone interview will be contacted via email and text to set up a phone interview

Clarity Recruitment and our client are firmly committed to fostering diversity within our community. Our clients welcome those who would contribute to the further diversification of their staff, including, but not limited to, women, visible minorities, Aboriginal people, persons with disabilities, and persons of any sexual orientation or gender identity. Please note that all qualified candidates are encouraged to apply. Please notify us if you require accommodation in the application process.

JOB ID #16521

Seniority level

Not Applicable

Employment type

Contract

Job function

Analyst, Finance, and Project Management