Data Analytical Specialist

Global Pharma TekToronto, ON

30+ days ago

Salary

CA$44.00 hourly

Job description

Position : Data Analyst Specialist

Location : Toronto, ON (Hybrid)

Duration : Business Days + Days Extension

Job Description : Technical Skills :

Experience in Business Intelligence Reporting : Demonstrated ability to construct comprehensive BI reports and dashboards, reflecting expertise in data visualization and interpretation.
Proficiency in Power BI : Proven skills in utilizing Power BI for data analysis and report creation, including familiarity with advanced features and functionalities.
Expertise in SQL and Data Query Tools : Demonstrated experience in SQL querying and the use of various data query tools for data extraction, transformation, and loading (ETL) processes.
Knowledge of Microsoft Power BI Service : In-depth understanding and practical experience with Microsoft Power BI Service, including its integration and customization.
Data Visualization Skills : Proven capability in creating effective and insightful data visualizations, utilizing various tools and techniques.

BI Implementation Methodologies :

Familiarity with different Business Intelligence implementation methodologies and their practical application in real-world scenarios.

Data Analysis and Management Knowledge : Comprehensive understanding of data analysis principles and data management practices, including data quality and governance.

Advanced Analytical Techniques : Demonstrated experience in applying advanced analytical techniques such as machine learning, predictive analytics, and statistical analysis to derive actionable insights from large datasets.

Experience with Data Cleansing and Preprocessing : Proven skills in data cleansing and preprocessing, including handling missing data, anomaly detection, and normalization, to ensure data quality and reliability for analysis.

Proficiency in Data Analytics Tools : Expertise in using data analytics tools such as Python (Pandas, NumPy, SciPy), R, or SAS for complex data manipulation and analysis.

Data Interpretation and Insight Generation : Strong ability to interpret data, identify trends and patterns, and generate meaningful insights that support business decision-making.

Experience with Data Mining Techniques : Proficiency in data mining techniques and methodologies, including clustering, classification, regression, and association rules, to extract valuable information from large datasets.

Experience in Data Warehousing : Understanding of data warehousing concepts and experience in working with data warehouse technologies.

Knowledge of Data Integration Techniques : Skills in integrating data from various sources and formats for comprehensive analysis.

Documentation, Collaboration & Communication Skills :

Clarity in Complex Business Challenges : Ability to bring clarity to complex business issues and articulate business process requirements versus technology solutions effectively.

Excellent Verbal and Written Communication : Demonstrated excellence in both verbal and written communication, including the ability to convey complex data concepts in understandable terms.

Interpersonal and Facilitation Skills : Strong interpersonal skills, with an ability to facilitate discussions and consensus among diverse groups.

Effective Documentation Skills : Proficiency in creating clear and detailed documentation, including reports, guides, and process maps.

Collaboration with Internal / External Stakeholders : Demonstrated ability to effectively partner with both internal and external stakeholders, fostering productive relationships.

Teamwork and Cross-Functional Collaboration : Experience in working collaboratively in cross-functional teams, contributing to a cohesive team environment.

Mandatory Requirements :

Ability to examine, understand and present requirements, data and information in a cohesive manner using various tools including TOAD, SQL Server Management Studio, Visio, Powerpoint, Miro, , Excel

Ability to Lead and advise on data compatibility and recommend solutions.

Superior knowledge of the Microsoft Office suite and Microsoft Azure ecosystem

Experience in database transition to work between platforms and manage multiple stages of projects from initiation to testing to delivery

Ability to liaise and provide reporting information, assessment and data interpretation to others