RQ08480 - Data Analytical Specialist/Scientist - JuniorJob Openings RQ08480 - Data Analytical Specialist/Scientist - JuniorAbout the job RQ08480 - Data Analytical Specialist/Scientist - JuniorDescriptionResponsibilitiesLead the development and delivery of functional and ministry-specific analytics to support evidence-based decision-making and produce actionable insights. Work closely with clients groups to assess current data analytics and reporting capabilities, gather future-state requirements and identify further opportunities for improvement. Facilitate decision-making and manage client expectations. Own the execution of analytics initiatives including end-to- end reporting and data set delivery. Develop robust statistical models and machine learning algorithms to model business scenarios and extract valid inferences. Participate in documentation, development, testing, and end user training.Work with functional area experts, Data Architects and ETL Developers and stakeholders to understand complex business issues and develop appropriate Business Intelligence solutions. Design methods to capture, structure, transform and process data to be used to generate models. Build data models that provide information which is accurate, easy to understand and unbiased. Communicate complex quantitative analysis in a explicit and precise manner, providing useful visuals and summaries. Provide interpretation, advice, and expertise to client groups and other stakeholders, including direction on how to transform analytics into actionable information and proactive insights that support decision making.General SkillsExcellent analytical, problem-solving and decision-making skills, verbal and written communication skills, interpersonal skills and team work skills.Outstanding consulting and relationship management skills, with proven ability to elicit requirements, develop/consult on options and solutions, and provide effective guidanceAdept at communicating to both technical and non-technical audiencesExperience 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, and other related disciplines at the specified experience levelAbility to manipulate and analyze complex, high-volume data from structured and unstructured sourcesExperience developing data extraction, transformation, and load functionality for large relational and multi-dimensional data storesExperience designing high quality interfaces to present information in a meaningful way to end usersBroad understanding of data management, financial and business analysis, database architecture, and information visualizationProficiency in query languages and experience constructing complex query statementsExperience in one or more programming or scripting languagesStrong investigative and logic skills. Proficiency in mathematics and statisticsAwareness of emerging Business Intelligence trends and directionsFunctional area experience as requiredExperience with analytical software such as R, PowerPivot, Matlab, SPSS, or SAS an assetProficiency with desktop analysis software including Microsoft Excel, Access, VBAA junior (Level 1) Data Scientist is required to support the assessment and analytics of datasets for proofs-of-concept. The general scope of work for the data scientist involves:Assessing datasets from various ministry sources, including those involved with land-use planning, child care, and school related data; Identifying potential gaps (e.G. inconsistencies, errors) in datasets and documenting gaps as well as steps for resolution; Identifying new datasets needed to improve analytical capabilities of a proof of concept; Developing reports in various visualization tools (e.G. GIS, Tableau,



Microsoft PowerBI); Conducting historical analytics on relational datasets; Conducting predictive analytics on relational datasets; andDocumenting the findings at each phase of work and reporting the findings to the team; The candidate must be able to work in an agile/iterative project environment.Skills:Experience with land-use planning, child care, StatsCan demographics, and Ontario Open Data is an assetExperience integrating R Script into Microsoft Power BIExperience with predictive analyticsExperience with dimensionalized data / building cubesSkillsExperience and Skill Set RequirementsTools and techniques - 50%Superior Knowledge of MS analytical products in particular Excel and data validation on Excel forms.Experience with SQL databasesExperience cleaning, transforming and joining dataExperience is creating and applying data standardsExperience with dimensional data modelsStatistical modeling using R and experience integrating R with Microsoft Power BI an assetExperience building visualizations in R Shiny, SAS, Python, Esri/ArcGIS, Microsoft PowerBI, and PowerViewer, Cognos an assetPower BI and Analytics Experience - 25%Experience developing business intelligence and various analytics resourcesExperience with cleaning, transforming, integrating, and visualizing data setsExperience understanding a data modelExperience creating interactive visualsCommunication Skills - 20%Experience in developing documentation on data standardization and requirementsDemonstrated consulting and relationship management skills, with proven ability to elicit requirements, develop/consult on options and solutions, and provide effective guidanceStrong verbal and written communication skills; with both technical andnon-technical audiencesA demonstrated team player with a track record for meeting deadlinesOPS Experience - 5%Previous public sector experience in an organization of equivalent size and complexity to the Ontario Public Service.MUST HAVES:Superior Knowledge of MS analytical products in particular Excel and data validation on Excel forms.Experience cleaning, transforming and joining dataExperience with SQL databasesExperience building visualizations in Microsoft PowerBI#J-18808-Ljbffr

📌 Rq08480 - Data Analytical Specialist/Scientist - Junior (Toronto)
🏢 Rubicon Path
📍 Toronto