Talent.com
Business Systems Analyst

Business Systems Analyst

Clarity RecruitmentToronto, ON, Canada
5 days ago
Job type
  • Full-time
Job description

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 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.

    Clarity Recruitment helps start-ups and scale-ups build top-performing finance & accounting teams with a structured recruitment process and better results. Visit findingclarity.ca to learn more!

    JOB ID #16521