RQ - Business Intelligence Specialist - Senior

Responsibilities:

• Supports Client’s wide-ranging business information requirements, implementing and supporting business intelligence software solutions
  
• Develops and supports customized query applications which analyze key business data
  
• Develops and supports guided analysis and drill-down functionality, routine scheduling and notification of report generation, and effective implementation of “opportunity” and “key-trend” alerts.
  
• Provides Clients with approach options and tools for managing business-related data in a manner that assists in quantitative analysis of progress and the relationship between operational actions and their effect on business objectives.
  

General Skills:

• Experience with analyzing data in source systems to identify data cleanliness issues (e.g. missing values, duplicate meanings, and invalid data)
  
• Experience with developing feedback processes to fix corrupt data in the source systems
  
• Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide-range of data repositories (relational and multi- dimensional data stores)
  
• Experience with developing, implementing and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts
  
• Experience with developing monitoring and error notification processes to ensure data is updated as designed
  
• Experience with developing automation extraction, cleansing and load scripts
  
• Experience generating research models and reports (scheduled and ad-hoc)
  
• Proven troubleshooting and analytical experience
  
• Experience in process decomposition/mapping and business process re-engineering and complex data models using UML.
  
• Experience in the use of development tools and business re-engineering software
  
• Experience in developing enterprise architecture deliverables (e.g. business, logical, and physical models) based on Enterprise Application Processes and Modeling methodology and guidelines
  

Desirable Skills:

• Knowledge and experience in developing data analysis applications
  
• Knowledge and understanding of Information Management principles, concepts, policies and practices
  
• Ability to provide expert advice in developing and integrating process and information models to enable identifying and eliminating redundant business processes
  
• Experience with developing monitoring and error notification processes to ensure data is updated as designed
  
• Hands on experience working with stakeholders to develop and document interface specifications design between Business Intelligence solutions and external applications
  
• Extensive experience with conceptual, logical and physical data modelling tools like Power Designer, and Visio.
  
• Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards
  
• Supports Client’s wide-ranging business information requirements, implementing and supporting business intelligence software solutions.
  
• Develops and supports customized query applications which analyze key business data.
  
• Develops and supports guided analysis and drill-down functionality, routine scheduling and notification of report generation, and effective implementation of “opportunity” and “key-trend” alerts.
  
• Provides Clients with approach options and tools for managing business-related data in a manner that assists in quantitative analysis of progress and the relationship between operational actions and their effect on business objectives.
  
• Experience with analyzing data in source systems to identify data cleanliness issues (e.g. missing values, duplicate meanings, and invalid data)
  
• Experience with developing feedback processes to fix corrupt data in the source systems
  
• Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide-range of data repositories (relational and multidimensional data stores)
  
• Experience with developing, implementing and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts
  
• Experience with developing monitoring and error notification processes to ensure data is updated as designed
  
• Experience with developing automation extraction, cleansing and load scripts
  
• Experience generating research models and reports (scheduled and ad-hoc)
  
• Proven troubleshooting and analytical experience
  
• Experience in process decomposition/mapping and business process re-engineering and complex data models using UML.
  
• Experience in the use of development tools and business re-engineering software
  
• Experience in developing enterprise architecture deliverables (e.g. business, logical, and physical models) based on Enterprise Application Processes and Modeling methodology and guidelines
  

Requirements

Skills

Experience and Skill Set Requirements

  Technical Experience -

3-5 years experience in a business analyst capacity, with demonstrated work outlined clearly in:

Data and Statistics:

• Knowledge of data processing/warehousing and statistical analysis techniques
  
• Knowledge of theories, practices, and techniques of economic, mathematical, and statistical theory/analysis, research methods, and procedures to conduct analytical studies and surveys
  

Tools:

• Experience with a wide range of methods, tools, and techniques for business analysis such as, but not limited to business functional modeling, business event modeling, business process mapping
  
• Demonstrated understanding of software development methodology and life cycle Working Experience with data analysis tools Experience and knowledge working with data in some or all of these technologies: Excel, SQL, R, Python, and/or other scripting languages
  
• Experience working with business intelligence tools such as Power BI, Tableau, and/or Cognos,  for both on-premises and cloud solutions where applicable
  
• Experience working with Oracle and MSSQL databases
  
• Experience with various system testing strategies.
  
• Extensive experience with source control and environment management
  
• Demonstrated understanding of BA life cycle. This includes awareness of emerging I&IT trends and technologies (Microsoft Azure/Dev-Ops). Build automation experience is an asset
  
• Demonstrated Experience with GUI, user interface design, and mock-ups.
  
• Demonstrated Experience with Computer Aided Software Engineering (CASE) tools.
  

Research and Analysis:

• Knowledge of emerging technologies in data analytics to recommend research, evaluation, and data management tools/ techniques
  
• Demonstrated experience with developing business strategies, business process re-engineering
  
• Knowledge of regulatory guidelines, policies, practices, and protocols to ensure appropriate reporting and protection of privacy and security of personal information
  
• Experience developing strategic and operational frameworks to help ministry partners and internal projects make
  
• Knowledge of metrics development methodologies for measuring the effectiveness and efficiency of solutions
  

Solution Delivery:

• Technical knowledge to identify and evaluate information technology options, and to conduct complex systems analysis and design for the development of new systems or systems modifications
  
• Experience with software development lifecycles and applying them to the development of data analytic products
  
• Experience in evaluating and analyzing existing web applications and business intelligence tools for the Accessibility for Ontarians with Disabilities Act (AODA) compliance
  
• Conduct and provide technical expertise in complex systems analysis and design, coordinate development of all systems documentation, and develop and oversee testing and implementation of systems and applications
  
• Experience with creating documentation such as data dictionary and data source to target mapping; provide feedback/direction to team on how existing documentation can be improved
  

Data Science and Analysis:

• You can conduct feasibility studies, and cost and benefit analyses on complex business and systems initiatives, and recommend systems development solutions
  
• You have experience conducting data analysis to support research and project teams and prepare data analysis reports
  
• You can identify and evaluate sources of data for research purposes, assess and select mathematical/statistical methods, investigate and assess new technologies, and prepare statistical analysis
  
• You can document and assess current state processes and recommendations for future state processes based on business and cluster strategic direction
  
• You can conduct analysis on business/systems initiatives and recommend solutions to meet business needs and promote overall ministry IT strategies and objectives
  

Core Skills

• Experience conducting requirements gathering and developing documentation
  
• Working knowledge of systems design and development, and related methods, techniques, practices, and standards enable you to analyze and define clients' business and information technology requirements pertaining to data flow and data integration; provide recommendations to business
  
• Demonstrates Analytical and problem-solving skills to assess clients' business priorities and needs; to evaluate business and technical design alternatives
  
• Ability to work with business and development teams to document system requirements
  
• Demonstrated experience with creating Business Cases, Screen Design/User Interface, Business Process Models, Privacy Impact Assessments, Threat Risk Assessments, and Logical architecture artifacts, among other deliverables
  
• Demonstrated experience with Business Architecture
  
• Working knowledge of technology, data, databases, applications, and networking techniques, tools, and practices enables you to lead the design and development of infrastructure-related projects
  

Project Experience and Techniques

• Demonstrates lead design experience with technology upgrade/migration projects, and shows acumen in being able to evaluate and determine the best path going forward
  
• Demonstrates experience leading discussions with stakeholders to elicit requirements, developing/consulting on options and solutions, and facilitating the resolution of I&IT and Business issues. Ability to drill down on business pain points and determine the right solution, rather than delivering only the item that’s being requested by stakeholders
  
• Demonstrates development and design experience with SDLC processes, Agile and Waterfall methodologies
  

Communication Skills

• Demonstrated experience in solving problems analytically, and making sound decisions based on
  
• Experience in negotiating using both verbal and written communication skills and should have worked in a team-based environment with a proven record of meeting deadlines
  
• Strong stakeholder engagement, facilitation, negotiation, and consensus building
  

Public Sector Experience

• Previous public sector experience in an organization of equivalent size or complexity to the Ontario Public Service
  

MUST HAVES:

• Experience with a wide range of methods, tools, and techniques for business analysis such as, but not limited to business functional modeling, business event modeling, business process mapping
  
• Demonstrated understanding of software development methodology and life cycle Working Experience with data analysis tools Experience and knowledge working with data in some or all of these technologies: Excel, SQL, R, Python, and/or other scripting languages
  
• Experience working with business intelligence tools such as Power BI, Tableau, and/or Cognos, for both on-premises and cloud solutions where applicable
  
• Experience working with Oracle and MSSQL databases
  
• Demonstrated understanding of BA life cycle. This includes awareness of emerging I&IT trends and technologies (Microsoft Azure/Dev-Ops). Build automation experience is an asset
  
• Knowledge of emerging technologies in data analytics to recommend research, evaluation, and data management tools/ techniques
  
• Demonstrated experience with developing business strategies, business process re-engineering
  
• Technical knowledge to identify and evaluate information technology options, and to conduct complex systems analysis and design for the development of new systems or systems modifications
  
• Conduct and provide technical expertise in complex systems analysis and design, coordinate development of all systems documentation, and develop and oversee testing and implementation of systems and applications  
  
• You can identify and evaluate sources of data for research purposes, assess and select mathematical/statistical methods, investigate and assess new technologies, and prepare statistical analysis
  
• Demonstrated experience with creating Business Cases, Screen Design/User Interface, Business Process Models, Privacy Impact Assessments, Threat Risk Assessments, and Logical architecture artifacts, among other deliverables