Rubicon Path logo
Rubicon PathPosted 1 month ago

RQ07951 - Sr. Business Intelligence Specialist

On-siteToronto, Ontario, Canada

Full TimeSenior LevelSmall

Job Summary

Implement and support business intelligence software solutions by developing customized query applications that analyze key business data. Execute daily and initial load ETL programs across relational and multidimensional repositories, while managing data cleansing, transformation, and automation scripts. Generate scheduled and ad-hoc research models, dashboards, and reports using R, Power BI, and Tableau to assist in quantitative analysis of operational actions. Collaborate with stakeholders to define interface specifications, document enterprise architecture deliverables, and provide expert advice on statistical modeling and advanced analytics strategies.

Required Qualifications

  • Demonstrates experience working and communicating directly with stakeholders
  • Managing high volumes of data
  • R Scripting
  • Power BI
  • Public Sector Experience
  • Experience working and communicating directly with business stakeholders
  • Experience in working with and analyzing large and diverse data sets
  • Strong knowledge of design, development, and implementation experience utilizing Analytics technologies involving the use of administrative postsecondary data
  • Knowledge of Statistics and modelling techniques such as econometrics, theory of Probability and Statistics - inference based on survey data, confidence intervals, regression models - multinomial linear, logistic, ridge, machine learning algorithms - training, model evaluation, hyper parameters search techniques
  • Knowledge of advanced data visualization tools and techniques
  • Knowledge of statistics and analytical tools such as R/SAS/SPSS
  • Knowledge of BI technologies such as R Shiny, Power BI, Tableau
  • Strong interpersonal and communication skills (both written and oral)
  • Ability to communicate with people in a wide variety of areas and at various levels from technical specialists to senior management
  • Must be able to work in a high functioning team environment
  • Excellent analytical, problem-solving and decision-making skills
  • Verbal and written communication skills
  • Interpersonal skills and team work skills
  • Outstanding consulting and relationship management skills
  • Proven ability to elicit requirements, develop/consult on options and solutions, and provide effective guidance
  • Adept at communicating to both technical and non-technical audiences
  • Experience with a range of analytical methods, techniques and tools such as, but not limited to: statistical analysis and modelling, data mining, machine learning and algorithms, natural language processing
  • Ability to manipulate and analyze complex, high-volume data from structured and unstructured sources
  • Experience developing data extraction, transformation, and load functionality for large relational and multi-dimensional data stores
  • Experience designing high quality interfaces to present information in a meaningful way to end users
  • Broad understanding of data management, financial and business analysis, database architecture, and information visualization
  • Proficiency in query languages and experience constructing complex query statements
  • Experience in one or more programming or scripting languages
  • Strong investigative and logic skills
  • Proficiency in mathematics and statistics
  • Functional area experience as required
  • Demonstrated experience with database design (SQL Server, Oracle)
  • Experience developing BI and analytics Roadmaps for clients (e.g. Microsoft BI)
  • Working knowledge of advanced data visualization tools and techniques (statistical graphics, plots, information graphics)
  • Some tools that would be of interest are Rshiny, Google Analytics, Tableau and Power BI
  • Demonstrated experience with data preparation and scripting tools (such as OpenRefine, Python and DAX)
  • Demonstrated experience with a range of analytical methods, techniques and tools: statistical analysis and modelling, data mining, machine learning and algorithms, natural language processing, business performance management, benchmarking text mining, predicative/prescriptive analysis
  • Demonstrated experience with statistics and analytical tools such as R/SAS/SPSS
  • Demonstrated experience with data warehousing and dashboards

Desired Qualifications

  • Public Sector Experience
  • Experience with 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
  • 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
  • Experience with developing monitoring and error notification processes to ensure data is updated as designed
  • Knowledge of design, development, and implementation experience utilizing Analytics technologies involving the use of administrative postsecondary data
  • Knowledge of Statistics and modelling techniques such as econometrics, theory of Probability and Statistics - inference based on survey data, confidence intervals, regression models - multinomial linear, logistic, ridge, machine learning algorithms - training, model evaluation, hyper parameters search techniques
  • Knowledge of advanced data visualization tools and techniques
  • Knowledge of statistics and analytical tools such as R/SAS/SPSS
  • Knowledge of BI technologies such as R Shiny, Power BI, Tableau
  • Strong interpersonal and communication skills (both written and oral)
  • Ability to communicate with people in a wide variety of areas and at various levels from technical specialists to senior management
  • Must be able to work in a high functioning team environment
  • Excellent analytical, problem-solving and decision-making skills
  • Verbal and written communication skills
  • Interpersonal skills and team work skills
  • Outstanding consulting and relationship management skills
  • Proven ability to elicit requirements, develop/consult on options and solutions, and provide effective guidance
  • Adept at communicating to both technical and non-technical audiences
  • Experience with a range of analytical methods, techniques and tools such as, but not limited to: statistical analysis and modelling, data mining, machine learning and algorithms, natural language processing
  • Ability to manipulate and analyze complex, high-volume data from structured and unstructured sources
  • Experience developing data extraction, transformation, and load functionality for large relational and multi-dimensional data stores
  • Experience designing high quality interfaces to present information in a meaningful way to end users
  • Broad understanding of data management, financial and business analysis, database architecture, and information visualization
  • Proficiency in query languages and experience constructing complex query statements
  • Experience in one or more programming or scripting languages
  • Strong investigative and logic skills
  • Proficiency in mathematics and statistics
  • Functional area experience as required
  • Demonstrated experience with database design (SQL Server, Oracle)
  • Experience developing BI and analytics Roadmaps for clients (e.g. Microsoft BI)
  • Working knowledge of advanced data visualization tools and techniques (statistical graphics, plots, information graphics)
  • Some tools that would be of interest are Rshiny, Google Analytics, Tableau and Power BI
  • Demonstrated experience with data preparation and scripting tools (such as OpenRefine, Python and DAX)
  • Demonstrated experience with a range of analytical methods, techniques and tools: statistical analysis and modelling, data mining, machine learning and algorithms, natural language processing, business performance management, benchmarking text mining, predicative/prescriptive analysis
  • Demonstrated experience with statistics and analytical tools such as R/SAS/SPSS
  • Demonstrated experience with data warehousing and dashboards

Hiring someone like this?

Get your role in front of qualified candidates on Sorce.

Get started

Apply to this job in one click with Sorce

Apply on Sorce