Maarut logo

RQ10756 - Business Analyst - Senior

Maarut
1 month ago
Contract
On-site
Toronto, Toronto, Canada

Scope:<\/b>
<\/p>

  • The Office of the Public Guardian and Trustee (OPGT) requires a Business Intelligence Specialist to help build a new data warehouse\/lakehouse and deliver the reporting MVP (minimum viable product).
    <\/li> <\/ul>

     
    <\/p>

    Assignment Deliverables:<\/b>
    <\/p>

    As a member of the OPGT modernization data analytics and reporting team, you will be responsible to build and deliver modernized reports from the new data warehouse\/lakehouse. A high\-level list of deliverables follows:
    <\/p>

    • Lead and conduct business and system analysis in respect to building the golden layer of the data lakehouse and modernized reports in PowerBI..
      <\/li>
    • Lead the effort into defining the reporting MVP; document legacy reports in scope of MVP; conduct gap analysis and provide recommendations.
      <\/li>
    • Document report requirements in user stories in DevOps. Conduct analysis at varying levels of detail, appropriate to the project and phases of project, aligning with OPS standards.
      <\/li>
    • Liaise between Business Areas and the data migration and reporting team, to clarify business requirements and translate them into system and reporting requirements.
      <\/li>
    • Conduct business modeling; use case modeling; conceptual and logical data modeling; process and data flow modeling; use case surveys; business rules definition and non\-functional requirements definitions for assigned projects, including report requirements, screen specifications, business rules, data migration requirements, etc.  
      <\/li>
    • Produce\/update documentation which will allow future support of the implemented solutions.
      <\/li>
    • Assist with identifying and resolving data quality issues, defining test cases, performing data reconciliation, and addressing any issues or discrepancies that arise during the testing phase; developing KPIs to report on the progress, completeness and quality of the reporting and data migration effort.
      <\/li>
    • Ongoing Support: provide post\-migration support, analyze and address data\-related issues or questions; help with optimizing data management processes in the new environment.
      <\/li>
    • Other duties as assigned.
      <\/li> <\/ul>

      <\/div><\/span>

      Requirements<\/h3>

      Experience and Skill Set Requirements:<\/span><\/u><\/b>
      <\/p>

      Must have:<\/span><\/u><\/b>
      <\/p>

      • 10+ years of experience leading and conducting business and system analysis to assess client’s business problems\/opportunities and document the business\/system requirements in such a way that I&IT solutions can be designed. 
        <\/span><\/li>
      • Proven experience in both agile and waterfall project management methodologies.
        <\/span><\/li>
      • Proven experience in conducting business and system analysis in respect to building data marts\/data warehouses\/data lakehouse or Business Intelligence\/Data Analytics and Reporting solutions.
        <\/span><\/li>
      • Demonstrated experience working as a business analyst in large\/complex data migration projects.
        <\/span><\/li>
      • Demonstrated experience with writing user stories and using tools such as DevOps.
        <\/span><\/li> <\/ul>

         
        <\/p>

        Skill Set Requirements:<\/span><\/u><\/b>
        <\/p>

        Desired Skills and Experience:<\/b>
        <\/p>

        • 10+ years of experience leading and conducting business and system analysis to assess client’s business problems\/opportunities and document the business\/system requirements in such a way that I&IT solutions can be designed. 
          <\/li>
        • Experience conducting analyses at varying levels of detail, appropriate to the project and phases of project, aligning with OPS standards.
          <\/li>
        • Experience conducting business modeling; use case modeling; conceptual and logical data modeling; process and data flow modeling; use case surveys; business rules definition and non\-functional requirements definitions for assigned projects, including screen specifications, business rules, data migration requirements, etc.  
          <\/li>
        • Proven experience in both agile and waterfall project management methodologies.
          <\/li>
        • Proven experience in conducting business and system analysis in respect to building data marts\/data warehouses\/data lakehouse or Business Intelligence\/Data Analytics and Reporting solutions
          <\/li>
        • Demonstrated experience working as a business analyst in large\/complex data migration projects.
          <\/li>
        • Familiarity with BI\/reporting tools such as PowerBI
          <\/li>
        • Basic knowledge of SQL language; ability to execute SQL queries.
          <\/li>
        • Understanding of concepts around ETL, data quality, data cleaning, data issues’ handling.
          <\/li>
        • Experience in conducting business and system analysis for a Dynamics 365 CE and\/or F&O solution or other CRM\/ERP solutions.
          <\/li>
        • Experience creating use cases, test plans, test cases, test scripts ideally around reporting and\/or data migration.
          <\/li>
        • Experience with defect management processes, defect identification, logging, tracking, and resolution.
          <\/li>
        • Familiarity with industry\-standard quality assurance practices, such as ISO standards, CMMI, or Agile methodologies
          <\/li>
        • Experience consulting and coordinating between Business Areas and the IT Development and Testing teams to clarify business requirements and translating them into system requirements.
          <\/li>
        • Critical thinking, analytical and problem\-solving skills; proven gap analysis experience
          <\/li>
        • Excellent verbal and written communication skills
          <\/li>
        • Proven ability to engage with stakeholders and build strong working relationships.
          <\/li>
        • Demonstrated experience with writing user stories and using tools such as DevOps.
          <\/li> <\/ul>

           
          <\/p>

          Business Analysis Experience:<\/b>
          <\/p>

          • 10+ years of experience leading and conducting business and system analysis to assess client’s business problems\/opportunities and document the business\/system requirements in such a way that I&IT solutions can be designed.
            <\/span><\/li>
          • Experience conducting analyses at varying levels of detail, appropriate to the project and phases of project, aligning with OPS standards.
            <\/span><\/li>
          • Experience conducting business modeling; use case modeling; conceptual and logical data modeling; process and data flow modeling; use case surveys; business rules definition and non\-functional requirements definitions for assigned projects, including screen specifications, business rules, data migration requirements, etc. 
            <\/span><\/li>
          • Proven experience in both agile and waterfall project management methodologies, with emphasis on agile.
            <\/span><\/li> <\/ul>

             
            <\/p>

            Dynamics 365 CE \/ F&O Experience:<\/b>
            <\/p>

            • Proven experience in conducting business and system analysis in respect to building data marts\/data warehouses\/data lakehouse or Business Intelligence\/Data Analytics and Reporting solutions built against Dynamics 365 CE and F&O data
              <\/span><\/li>
            • Demonstrated experience working as a business analyst in large\/complex data migration projects.
              <\/span><\/li>
            • Familiarity with BI\/reporting tools such as PowerBI
              <\/span><\/li>
            • Basic knowledge of SQL language; ability to execute SQL queries.
              <\/span><\/li>
            • Understanding of concepts around ETL, data quality, data cleaning, data issues’ handling.
              <\/span><\/li>
            • Experience in conducting business and system analysis for a Dynamics 365 CE and\/or F&O solution or other CRM\/ERP solutions
              <\/span><\/li> <\/ul>

               
              <\/p>

              SQL \/ DB:<\/b>
              <\/p>

              • Demonstrated experience with data manipulation languages (T\-SQL, PL\/SQL), data definition languages,
                <\/span><\/li>
              • Demonstrated experience with SQL Server, Oracle, Azure SQL Databases
                <\/span><\/li> <\/ul>

                 
                <\/p>

                ETL\/Azure Platform:<\/b>
                <\/p>

                • Experience with Azure Synapse Workspaces and\/or Azure Data Factory
                  <\/span><\/li> <\/ul>

                   
                  <\/p>

                  DevOps and Agile:<\/b>
                  <\/p>

                  • Demonstrated experience with writing user stories and using tools such as DevOps.
                    <\/span><\/li> <\/ul>

                    <\/div><\/span>
                    <\/body> <\/html>"}}],"isMobile":false,"iframe":"true","jobType":"Contract","applyName":"Apply Now","zsoid":"653862245","FontFamily":"PuviRegular","jobOtherDetails":[{"fieldLabel":"Term","uitype":1,"value":"32 days"},{"fieldLabel":"Assigned Recruiter(s)","uitype":80,"value":"Ashwini Dhobale"},{"fieldLabel":"Job Opening ID","uitype":111,"value":"10429"},{"fieldLabel":"Industry","uitype":2,"value":"Technology"},{"fieldLabel":"Number of Positions","uitype":32,"value":"1"},{"fieldLabel":"Work Experience","uitype":2,"value":"7\-10 Years"},{"fieldLabel":"City","uitype":1,"value":"Toronto"},{"fieldLabel":"State\/Province","uitype":1,"value":"Ontario"},{"fieldLabel":"Zip\/Postal Code","uitype":1,"value":"M4C"}],"headerName":"RQ10756 \- Business Analyst \- Senior","widgetId":"383123000000072311","isJobBoard":"false","userId":"383123000000184003","attachArr":[{"fileName":"RQ10756 \- Business Analyst \- Senior.docx","linkDocs":0,"isView":"false","fileDigest":"6fbn5breIzBNwVUMiggIrrrx0edFyW5zCOpb2fk9bEcxMRg6XEThv5lCXNyVX5as7NjckCVuqqZgnO8auPH8lg\-\-","fileType":"docx"}],"customTemplate":"4","isCandidateLoginEnabled":true,"jobId":"383123000204462411","FontSize":"15","googleIndexUrl":"https:\/\/maarutinc.zohorecruit.com\/recruit\/ViewJob.na?digest=6fbn5breIzBNwVUMiggIrhB5XQrOx9gQ85ysQb2LXXc\-&embedsource=Google","location":"Toronto","embedsource":"CareerSite","indeedCallBackUrl":"https:\/\/recruit.zoho.com\/recruit\/JBApplyAuth.do"}