Business Analyst at Teckhorizon Inc — NeverHard

Our Client is seeking a Senior Business Analyst to support a major modernization initiative involving data migration, data lakehouse development, analytics, and reporting. The consultant will work closely with business stakeholders, data migration specialists, developers, and testing teams to define reporting requirements and deliver modernized Power BI reports. Key Responsibilities Lead business and systems analysis for the development of the golden layer within a data lakehouse. Define the reporting MVP, document legacy reports, conduct gap analysis, and recommend modernization priorities. Gather, analyze, and translate business needs into system, data, migration, and reporting requirements. Create user stories, acceptance criteria, and supporting documentation within Azure DevOps. Develop business models, use cases, conceptual and logical data models, process flows, and data-flow models. Define business rules, non-functional requirements, report specifications, screen requirements, and data migration requirements. Support the design and delivery of modernized Power BI reports using data warehouse and lakehouse sources. Liaise between business areas and development, migration, reporting, and testing teams. Identify and resolve data quality, data cleaning, reconciliation, and migration-related issues. Develop test plans, test cases, test scripts, and reporting validation scenarios. Manage defects through identification, logging, tracking, troubleshooting, and resolution. Develop KPIs to measure reporting completeness, migration progress, and data quality. Provide post-migration analysis, troubleshooting, process optimization, and production support. Maintain solution documentation and deliver knowledge transfer through Azure DevOps Boards, Wiki, presentations, and team sessions. Mandatory Requirements 10+ years of experience leading business and systems analysis for complex I&IT solutions. Experience assessing business problems and documenting clear business, system, data, and reporting requirements. Strong experience with both Agile and Waterfall delivery methodologies. Experience supporting data marts, data warehouses, data lakehouses, business intelligence, data analytics, or reporting solutions. Business analysis experience on large and complex data migration initiatives. Demonstrated experience creating user stories and managing requirements using Azure DevOps. Technical Experience Power BI reporting and dashboard requirements. Data warehouses, data marts, data lakehouses, and golden-layer design. SQL queries and relational data analysis. ETL, data mapping, data cleansing, data quality, reconciliation, and issue management. Dynamics 365 CE, Dynamics 365 F&O, or comparable CRM/ERP platforms. Conceptual and logical data modelling. Process modelling, data-flow modelling, use-case modelling, and business rules definition. Test planning, test cases, test scripts, defect management, and quality assurance practices. Azure DevOps Boards, Wiki, user stories, acceptance criteria, and Agile delivery. Familiarity with ISO, CMMI, or comparable quality and delivery standards. Preferred Qualifications Experience delivering BI, reporting, warehouse, or lakehouse solutions using Dynamics 365 CE or F&O data. Ontario Public Service or broader public-sector experience. Knowledge of OPS architecture, security, documentation, and I&IT standards. Strong gap analysis, critical thinking, analytical, and problem-solving capabilities. Excellent stakeholder engagement, facilitation, written communication, and presentation skills. Proven ability to coordinate competing priorities and deliver within fixed deadlines.