Data Analytical Specialist Scientist
Job Location:
Monthly Salary:
Experience Required:
Posted on:
Vacancies:
Job Summary
Job Description Data Analytical Specialist / Scientist
Position Summary
We are seeking an experienced Data Analytical Specialist / Scientist to design develop and deliver enterprise Business Intelligence (BI) and analytics solutions using Microsoft technologies. The successful candidate will work closely with business stakeholders Data Architects ETL Developers and technical teams to transform complex business requirements into data-driven insights interactive dashboards and advanced analytical solutions that support strategic and operational decision-making.
The role requires strong expertise in Power BI SQL DAX Power Query ETL Azure Data Factory SSIS data modeling statistical analysis and business intelligence development within a Microsoft technology environment. Experience working in the Ontario Public Service (OPS) or other public sector organizations is considered an asset.
Key Responsibilities
- Lead the design development and implementation of Business Intelligence and analytics solutions using Microsoft Power BI.
- Collaborate with business users and stakeholders to gather reporting and analytics requirements.
- Design and develop interactive dashboards scorecards KPI reports and executive reporting solutions.
- Analyze large complex datasets to identify trends patterns risks and business opportunities.
- Develop and maintain data models using dimensional modeling techniques including fact and dimension tables and star schema.
- Design develop and support ETL processes using SSIS and Azure Data Factory.
- Perform data extraction cleansing transformation validation and integration from multiple structured and unstructured data sources.
- Develop advanced DAX calculations Power Query transformations and reusable reporting components.
- Build statistical models machine learning algorithms and predictive analytics solutions to support evidence-based decision-making.
- Create reports using Power BI Service (Cloud) and Power BI Server (On-Premises) ensuring security scalability and performance.
- Implement Row-Level Security (RLS) workspace management and report deployment best practices.
- Collaborate with Data Architects Business Analysts ETL Developers Project Managers and business teams to deliver end-to-end BI solutions.
- Participate in system testing user acceptance testing (UAT) deployment documentation and end-user training.
- Produce technical documentation design specifications user guides and knowledge transfer materials.
- Ensure all deliverables comply with GO-ITS standards organizational policies and established development methodologies.
- Support production releases infrastructure upgrades and ongoing maintenance activities.
Required Qualifications
- Extensive experience developing Business Intelligence and analytics solutions.
- Advanced expertise with Microsoft Power BI including dashboard development report design and data visualization.
- Strong knowledge of DAX Power Query (M) and advanced Power BI development.
- Advanced SQL skills for data extraction transformation reporting and performance optimization.
- Experience designing dimensional data models including star schema fact tables and dimension tables.
- Hands-on experience with ETL development using SSIS and Azure Data Factory.
- Experience with Microsoft BI technologies including SSAS SSRS SQL Server SQL Server Management Studio (SSMS) and Visual Studio.
- Knowledge of statistical analysis data mining machine learning predictive analytics and Natural Language Processing (NLP).
- Experience working with large enterprise data warehouses and complex relational databases.
- Strong understanding of data governance data quality and information management principles.
- Experience implementing Power BI Service Power BI Server workspace management dataset publishing and Row-Level Security (RLS).
- Experience integrating data from multiple enterprise systems and cloud platforms.
- Proficiency in Python or other scripting languages for analytics and automation.
Required Skills
Business Intelligence
- Power BI Dashboard Development
- Report Development
- KPI & Scorecard Development
- Executive Reporting
- Data Visualization
- Business Intelligence Solutions
Data Analytics
- Statistical Analysis
- Predictive Analytics
- Machine Learning
- Data Mining
- Trend Analysis
- Data Interpretation
Data Management
- Data Modeling
- Data Warehousing
- Star Schema
- Fact & Dimension Tables
- Data Cleansing
- Data Validation
- Data Integration
- ETL Development
Technical Skills
- SQL
- DAX
- Power Query
- Python
- SSIS
- Azure Data Factory
- SSAS
- SSRS
- SQL Server
- Power BI Service
- Power BI Server
- Azure Analytics
Soft Skills
- Strong analytical and problem-solving abilities.
- Excellent verbal and written communication skills.
- Ability to communicate effectively with both technical and non-technical stakeholders.
- Strong stakeholder management and consulting skills.
- Excellent organizational and leadership capabilities.
- Proven ability to manage multiple priorities and meet project deadlines.
- Strong collaboration and teamwork skills.
Preferred Qualifications
- Previous Ontario Public Service (OPS) or other public sector experience.
- Experience working within GO-ITS standards and government environments.
- Knowledge of Azure DevOps SharePoint and enterprise documentation practices.
- Experience supporting enterprise Business Intelligence analytics and reporting initiatives in large complex organizations.
Required Skills:
Mandatory Skills & Experience Cloud & Infrastructure Engineering Proven experience designing deploying and maintaining hybrid infrastructure environments across: Microsoft Azure Amazon Web Services (AWS) Linux-based environments SaaS solutions COTS solutions On-premises systems Strong experience with Windows and Linux server administration including: CentOS Ubuntu CoreOS Experience supporting modern web technology stacks including: LAMP MEAN Drupal Elasticsearch Experience with virtualization platforms storage solutions networking and enterprise infrastructure services. Strong understanding of cloud architecture frameworks technology assessments and cloud solution strategies. Identity & Access Management Experience managing and supporting identity and access controls using: Active Directory Microsoft Entra ID Enterprise IAM solutions Experience implementing authentication authorization and access governance controls. DevOps & CI/CD Automation Strong experience designing building and administering CI/CD pipelines for continuous integration and deployment. Experience with development and collaboration tools including: Azure DevOps JIRA Confluence Maven Jenkins Experience with Infrastructure as Code (IaC) and version-controlled deployments. Strong knowledge of DevOps methodologies automation frameworks and release management best practices. Experience with containerization and orchestration technologies including: Docker Kubernetes AKS / EKS Experience automating operational and compliance-related activities using: PowerShell Bash Python Programming & Scripting Hands-on experience with scripting and programming languages including: Python Bash PHP Java JavaScript Experience with build and configuration management tools including: Git Ansible Chef Puppet API & Integration Experience Experience building and consuming APIs and integration endpoints. Experience integrating cloud platforms enterprise systems and deployment pipelines. Understanding of enterprise integration architectures and service-based deployments. Security Monitoring & Compliance Strong understanding of infrastructure security cloud security and DevOps security best practices including: Least privilege access Secure logging Secrets management Vulnerability remediation Experience with security and monitoring tools including: Radware Dynatrace Splunk Azure Monitor / Log Analytics AWS CloudTrail / CloudWatch ELK Stack / SIEM solutions Experience implementing centralized audit logging and monitoring across enterprise platforms. Ability to support internal and external audits through reporting evidence gathering and log analysis. Experience supporting forensic investigations audit remediation and incident reviews. Familiarity with Government of Ontario I&IT Directives Policies and Information Technology Standards. Release Management & Operational Support Experience coordinating infrastructure and application releases across technical and business teams. Knowledge of change management processes deployment approvals rollback planning and release governance. Experience with release readiness reviews deployment validation and post-release monitoring. Ability to maintain release documentation operational records and audit artifacts. Project Management & Communication Strong project planning coordination and resource management skills. Experience with roadmap planning modernization initiatives and infrastructure investment planning. Strong stakeholder communication and cross-functional collaboration skills. Ability to explain complex technical concepts to business users leadership teams and non-technical stakeholders. Strong documentation reporting presentation and technical writing skills. Mobile Device Management Experience supporting mobile device management for cellular devices and tablets across multiple platforms and operating systems. Desirable Skills Experience supporting Government of Ontario enterprise environments. Experience with enterprise modernization and cloud transformation initiatives. Familiarity with enterprise governance compliance frameworks and audit readiness programs. Experience mentoring and coaching junior DevOps and infrastructure resources. Strong understanding of operational resilience disaster recovery and enterprise monitoring strategies. Additional Information Strong hands-on DevOps cloud infrastructure automation CI/CD security and enterprise release management experience is mandatory for this role.
