Source Code
RQ10948 - 2 x Sr. Business Analyst (Dynamics 3654 CE & F&O)
The Senior Business Analyst will lead data migration and reporting initiatives for the Office of the Public Guardian and Trustee, focusing on Dynamics 365 solutions and data lakehouse development. The role involves documenting requirements, creating user stories in DevOps, and bridging communication between business stakeholders and technical teams.
- Compensation
- CA$67–CA$101 / hr
- Location
- Toronto, ON, Canada
- Work setup
- Not specified
- Seniority
- Senior
- Employment
- Contract
- Experience
- 10+ years
- Category
- Business analysis
- Posted
Skills
Must have
- 10+ years of experience in business and system analysis
- Experience with agile and waterfall methodologies
- Experience writing user stories in DevOps
- Experience with data marts, data warehouses, data lakehouse, or BI/analytics solutions
- Experience with Dynamics 365 CE and/or F&O
- Familiarity with PowerBI
Nice to have
- Basic knowledge of SQL
- Understanding of ETL, data quality, and data cleaning
Full description
RQ10948 - 2 x Sr. Business Analyst2 openings - 2 submissions10+ month contract (206 business days) - 2 possible extensionsONSITE 5 days - 21 College StreetSecurity Level: CRJMC + Credit CheckMust-haves:
- 10+ years of experience leading and conducting business and system analysis to assess clients' business problems/opportunities and document the business/system requirements in such a way that I&IT solutions can be designed.
- Proven experience in both agile and waterfall project management methodologies; demonstrated experience with writing user stories and using tools such as DevOps.
- 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.
- Proven experience in conducting business and system analysis for a Dynamics 365 CE and/or F&O solution.
- Familiarity with BI/reporting tools such as PowerBI
Nice-to-have:
- Basic knowledge of SQL language; ability to execute SQL queries.
- Understanding of concepts around ETL, data quality, data cleaning, data issues' handling.
Scope:
- The Office of the Public Guardian and Trustee (OPGT) requires a Senior Business Analysts to assist with report development for the data warehouse/lakehouse and associated data migration activities.
Assignment Deliverables
As a member of the PGTIMS Support and Data Migration team, you will be responsible to lead and conduct business and systems analyst related to data migration activities.
A high-level list of deliverables follows:
- Lead and conduct business and system analysis in respect to building the golden layer of the data lakehouse and modernized reports in PowerBI.
- Lead the effort into defining the reporting MVP; document legacy reports in scope of MVP; conduct gap analysis and provide recommendations.
- 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.
- Liaise between Business Areas and the data migration and reporting team, to clarify business requirements and translate them into system and reporting requirements.
- 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.
- Produce/update documentation which will allow future support of the implemented solutions.