RQ10972 - Int. Data Analytical Specialist/Scientist
$122,970–$131,768 year
On-siteToronto, Ontario, Canada
Job Summary
Lead the development and delivery of functional and ministry-specific analytics to support evidence-based decision-making and produce actionable insights. Work closely with client groups to assess current data capabilities, gather requirements, and identify opportunities for improvement. Own end-to-end execution of analytics initiatives, including designing data models, developing robust statistical and machine learning algorithms, and delivering interactive Power BI dashboards. Facilitate decision-making by communicating complex quantitative analysis in clear, precise visuals and providing expert interpretation to stakeholders. Participate in documentation, testing, and end-user training while collaborating with Data Architects and ETL developers to transform business needs into effective reporting solutions.
Required Qualifications
- 10+ month contract (210 business days) - possible extension
- ONSITE 5 days - Toronto
- Strong data analysis and problem-solving skills
- Advanced proficiency in SQL for data extraction, transformation, and analysis
- Expertise in Power BI dashboard and report development
- Ability to design and develop interactive Power BI dashboards, scorecards, and KPI reports
- Strong knowledge of DAX and Power Query for advanced analytics and data transformation
- Experience with data modeling (fact and dimension tables, star schema)
- Data cleansing, validation, and quality management
- Experience with ETL processes and data integration from multiple sources
- Ability to gather business requirements and translate them into reporting solutions
- Strong data visualization and storytelling skills
- Experience creating executive, operational, and analytical reports
- Knowledge of Power BI Service, report publishing, workspace management, and security
- Understanding of Row-Level Security (RLS) and data governance practices
- Experience working with large datasets and data warehouses
- Familiarity with cloud analytics platforms and modern data ecosystems
- Ability to identify trends, patterns, risks, and opportunities through data analysis
- Strong stakeholder communication and presentation skills
- Experience documenting data definitions, KPIs, and reporting processes
- 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
- 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, and other related disciplines at the specified experience level
- 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
Desired Qualifications
- Prior OPS or Public sector Exp.
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.