Business Analyst
Duration: 9 Months
Location: Toronto, ON (Hybrid 2-3 days onsite)


Must Haves: 

• In-depth knowledge of database management systems (e.g., SQL Server, Oracle, MySQL, Data Bricks). 
• Ability to write complex queries, joins, subqueries, and use SQL functions 
• Experience with Agile project methodology leveraging Azure DevOps 
• Experience transposing requirements into coherent user stories 
• In-depth knowledge of delta tables, ETL pipelines, change data capture and databricks 

?

General Skills - 50% 

• 5–8 years of experience as a Business Analyst, with at least 3 years focused on data-centric projects 
• Experience in large-scale system integrations, data migrations, or legacy system replacements 
• Experience with agile practices, including sprints, user stories, and iterative development, especially when working in an agile data environment 
• Experience grooming and assembling requirements into coherent user stories and use cases and managing the Product Backlog Items, refining them and communicate changes to project manager/Team Lead 
• Lead and conduct business analysis in order to assess client’s business problems/opportunities at varying levels of detail appropriate to the project 
• Analyze current and future data needs, data flows, and data governance practices to support enterprise data strategies 
• Translate business requirements into data requirements (e.g., data sourcing, transformation logic, reporting needs, and data quality rules) 
• Lead data discovery efforts and participate in the design of data models and data integration solutions 
• Support data migration, data warehousing, and business intelligence initiatives by ensuring clarity and accuracy of requirements 
• Ability to write clear and comprehensive documentation: business requirements documents (BRD), data dictionaries, mapping documents, and use cases. 
• Conduct gap analyses between current and desired states of data assets or data processes 
• Ensure data requirements align with privacy, security, and OPS regulatory standards  
• 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 
• Experience in the use of Computer Aided Software Engineering (CASE) tools to document conceptual requirements and scope 
• Apply re-engineering concepts to promote business improvements through alternative and cost effective service delivery approaches 

 


Technical and Project Management Expertise - 50% 

• Expert Knowledge of data warehouse design methodologies, delta lake, Medallion Architecture  
• Experience working with relational databases (e.g., SQL Server, Oracle), Azure Databricks SQL Warehouse, Azure Data Lake 
• Strong skills in SQL query, manipulate, and retrieve data from relational databases. 
• Experience how to create and interpret Entity-Relationship Diagrams to represent the relationships between different data entities 
• Strong knowledge of data analysis techniques, data modeling, data warehousing, and of Extract/Transform/Load processes (ETL) processes 
• Solid understanding of data governance, data quality, metadata, and master data management (MDM) 
• Ability to analyze data patterns, structures, and business requirements to define an optimal data model 
• Ability to translate business requirements into effective data models that align with organizational goals 
• Documenting definitions, structures, and rules for data elements 
• Familiarity with reporting tools (e.g., Power BI) and how data is structured  
• Experience in defect fixing, testing support and development activities for ETL tool 
• Experience in the development and maintaining a plan to address contract deliverables, through the identification of significant milestones and expected results with weekly status reporting. 
• Good communication skills to explain complex data modeling concepts to non-technical business users and ensure alignment with their needs 
• A team player with a track record for meeting deadlines 

  

 


At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $520.00/hr.