LanceSoft
Job title:
Data Analytical Specialist/Scientist – Junior
Company
LanceSoft
Job description
Role: Data Analytical Specialist/Scientist – Junior
Location: Toronto, ON(Hybrid)
Duration: 12 Months Contract With possible extension.Tools and techniques – 50%
- Superior Knowledge of MS analytical products in particular Excel and data validation on Excel forms.
- Experience with SQL databases
- Experience cleaning, transforming, and joining data
- Experience is creating and applying data standards
- Experience with dimensional data models
- Statistical modeling using R and experience integrating R with Microsoft Power BI an asset
- Experience building visualizations in R Shiny, SAS, Python, Esri/ArcGIS, Microsoft PowerBI, and Power Viewer, Cognos an asset
Power BI and Analytics Experience – 25%
- Experience developing business intelligence and various analytics resources
- Experience with cleaning, transforming, integrating, and visualizing data sets
- Experience understanding a data model
- Experience creating interactive visuals
Communication Skills – 20%
- Experience in developing documentation on data standardization and requirements
- Demonstrated consulting and relationship management skills, with proven ability to elicit requirements, develop/consult on options and solutions, and provide effective guidance
- Strong verbal and written communication skills; with both technical and non-technical audiences
- A demonstrated team player with a track record for meeting deadlines
OPS 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 data
- Experience with SQL databases
- Experience building visualizations in Microsoft PowerBI
Expected salary
Location
Toronto, ON
Job date
Fri, 11 Apr 2025 00:47:15 GMT
To help us track our recruitment effort, please indicate in your email/cover letter where (jobsnearcanada.com) you saw this job posting.