J&M Group's logo

Business Analyst-Azure data/ datawarehouse at J&M Group

  • Full-time
  • On-site, Toronto, ON, Canada

Business Analyst-Azure data/ datawarehouse

Responsibilities:

  • Strong communication, interpersonal, collaboration, and negotiation skills to work seamlessly in an agile cross-functional team, with clients, vendor(s) and other stakeholders.
  • Creative, innovative, and can think outside the box to visualize solutions that meet business needs.
  • Strong experience in data analysis, profiling, clean-up, data wrangling and validation. Hands-on experience building data quality checks and writing complex SQL queries.
  • Experience working in large scale Enterprise Data Lake ingestion and extraction projects.
  • Experience working with Jira, Confluence, Bitbucket.
  • Experience with Data Lake, Azure Data Factory, DataBricks, python, Synapse/SQL Server, Analytics Zone, Azure Scheduler, Tableau, Power BI.
  • Demonstrable experience with conceptual, logical and physical data modeling techniques.
  • Solid knowledge of metadata management principles, metadata modeling and writing metadata definitions.
  • Good understanding of data Security Classifications, Risk Assessment (TRMIS) guidelines.
  • Strong analytical, organizational, and technical skills to analyze, model and interpret data.
  • Knowledge with Solutions Development Life Cycle (SDLC) and structured methodologies including agile, waterfall and iterative.
  • Work Experience in investigating, analyzing, estimating system applications in a large integrated solution environment.
  • Proven experience with all stages of automated system implementation in complex solutions, with online and batch processing of transactions.
  • Proven experience with sprint facilitation, interpretation of business needs to technical requirements, facilitation of project meetings for reviews.
  • Able to prioritize requirements, change requests for Business and work with Project team/Scrum Master in determining how best to address them.
  • Experience with supporting legacy applications such as Mainframe, other on-prem applications and Migration of legacy solutions using COTS products.
  • Experience in current state analysis through reverse engineering, identify source & downstream systems.
  • Experience in conducting feasibility analysis, project scoping and providing project work estimates.
  • Experience with requirements development involving requirements elicitation, analysis, specification and validation.
  • Experience with documenting user stories, planning and managing product backlog, planning and managing sprints, and implementing in an iterative manner.
  • Hand-on experience in capturing Data Lineage and Data Mapping between Source and Target systems.
  • Demonstrated experience in the facilitation of project meetings for reviews.
  • Experience in reporting progress of assignment(s) on a regular basis to Project Management and raise any issues / concerns and propose mitigation strategies.
  • Experience with Production Support

Skills:

  • 6-8 years of BSA experience in data analytics/data warehouse/data integration through agile environment.
  • Strong experience in data analysis, profiling, clean-up, data wrangling and validation. Hands-on experience building data quality checks and writing complex SQL queries.
  • Experience working in large scale Enterprise Data Lake ingestion and extraction projects.
  • Experience working with Jira, Confluence, Bitbucket.
  • Experience with Data Lake, Azure Data Factory, DataBricks, python, Synapse/SQL Server, Analytics Zone, Azure Scheduler, Tableau, Power BI.
  • Demonstrable experience with conceptual, logical and physical data modeling techniques.
  • Solid knowledge of metadata management principles, metadata modeling and writing metadata definitions.
  • Good understanding of data Security Classifications, Risk Assessment (TRMIS) guidelines.
  • Strong analytical, organizational, and technical skills to analyze, model and interpret data.
  • Knowledge with Solutions Development Life Cycle (SDLC) and structured methodologies including agile, waterfall and iterative.
  • Work Experience in investigating, analyzing, estimating system applications in a large integrated solution environment.
  • Proven experience with all stages of automated system implementation in complex solutions, with online and batch processing of transactions.
  • Proven experience with sprint facilitation, interpretation of business needs to technical requirements, facilitation of project meetings for reviews.
  • Able to prioritize requirements, change requests for Business and work with Project team/Scrum Master in determining how best to address them.
  • Experience with supporting legacy applications such as Mainframe, other on-prem applications and Migration of legacy solutions using COTS products.
  • Experience in current state analysis through reverse engineering, identify source & downstream systems.
  • Experience in conducting feasibility analysis, project scoping and providing project work estimates.
  • Experience with requirements development involving requirements elicitation, analysis, specification and validation.
  • Experience with documenting user stories, planning and managing product backlog, planning and managing sprints, and implementing in an iterative manner.
  • Hand-on experience in capturing Data Lineage and Data Mapping between Source and Target systems.
  • Demonstrated experience in the facilitation of project meetings for reviews.
  • Experience in reporting progress of assignment(s) on a regular basis to Project Management and raise any issues / concerns and propose mitigation strategies.
  • Experience with Production Support

Benefits:

  • 💼 Competitive salary
  • 💻 Full-time position

Qualifications:

  • 6-8 years of BSA experience in data analytics/data warehouse/data integration through agile environment.
  • Strong communication, interpersonal, collaboration, and negotiation skills to work seamlessly in an agile cross-functional team, with clients, vendor(s) and other stakeholders.
  • Creative, innovative, and can think outside the box to visualize solutions that meet business needs.
  • Strong experience in data analysis, profiling, clean-up, data wrangling and validation. Hands-on experience building data quality checks and writing complex SQL queries.
  • Experience working in large scale Enterprise Data Lake ingestion and extraction projects.
  • Experience working with Jira, Confluence, Bitbucket.
  • Experience with Data Lake, Azure Data Factory, DataBricks, python, Synapse/SQL Server, Analytics Zone, Azure Scheduler, Tableau, Power BI.
  • Demonstrable experience with conceptual, logical and physical data modeling techniques.
  • Solid knowledge of metadata management principles, metadata modeling and writing metadata definitions.
  • Good understanding of data Security Classifications, Risk Assessment (TRMIS) guidelines.
  • Strong analytical, organizational, and technical skills to analyze, model and interpret data.
  • Knowledge with Solutions Development Life Cycle (SDLC) and structured methodologies including agile, waterfall and iterative.
  • Work Experience in investigating, analyzing, estimating system applications in a large integrated solution environment.
  • Proven experience with all stages of automated system implementation in complex solutions, with online and batch processing of transactions.
  • Proven experience with sprint facilitation, interpretation of business needs to technical requirements, facilitation of project meetings for reviews.
  • Able to prioritize requirements, change requests for Business and work with Project team/Scrum Master in determining how best to address them.
  • Experience with supporting legacy applications such as Mainframe, other on-prem applications and Migration of legacy solutions using COTS products.
  • Experience in current state analysis through reverse engineering, identify source & downstream systems.
  • Experience in conducting feasibility analysis, project scoping and providing project work estimates.
  • Experience with requirements development involving requirements elicitation, analysis, specification and validation.
  • Experience with documenting user stories, planning and managing product backlog, planning and managing sprints, and implementing in an iterative manner.
  • Hand-on experience in capturing Data Lineage and Data Mapping between Source and Target systems.
  • Demonstrated experience in the facilitation of project meetings for reviews.
  • Experience in reporting progress of assignment(s) on a regular basis to Project Management and raise any issues / concerns and propose mitigation strategies.
  • Experience with Production Support

Published 3 days ago • Expires August 11, 2025 06:03