Data Analytical Specialist/Scientist – Senior

Job title:

Data Analytical Specialist/Scientist – Senior

Company

LanceSoft

Job description

Position: Sr. Data Analytical Specialist
Location: Toronto, ON (Hybrid)
Duration: 6+ Months Contract with possible 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.
• Presentation Skills: Strong presentation skills, capable of delivering insights and findings to both technical and non-technical audiences.
• Conflict Resolution and Negotiation Skills: Ability to resolve conflicts and negotiate effectively, maintaining a focus on business objectives.
• Time Management and Organizational Skills: Demonstrated effective time management skills, with the ability to prioritize tasks and meet deadlines in a dynamic environment.
• Adaptability and Flexibility: Ability to adapt to changing business needs and technology landscapes, maintaining effectiveness in varying environments.
• Stakeholder Management: Experience in managing stakeholder expectations and maintaining open lines of communication throughout project lifecycles.
• Critical Thinking and Problem-Solving: Strong critical thinking skills, with an ability to analyze problems, identify root causes, and develop innovative solutions.

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, Mermaid.js, Excel
• Ability to Lead and advise on data compatibility and recommend solutions.
• Superior knowledge of the Microsoft 365 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

Skills and Knowledge:

• Proven experience as a Data Analyst in building Business Intelligence reports and dashboards
• Proven experience in understanding, capturing, and analyzing complex and sometimes competing business requirements to develop Power BI and Business Intelligence products
• Demonstrated experience with Power BI, SQL Query and/or other data query tools
• Demonstrated knowledge and experience of Microsoft Power BI service
• Proven, demonstratable experience in data visualization; working with BI implementation methodologies
• Knowledge of data analysis, data management
• Proven ability to partner with internal/external stakeholders and liaise with technical experts and non-technical colleagues
• Excellent verbal and written communication skills, interpersonal and facilitation skills
• Strong written, presentation and interpersonal communication skills with special attention to correct use of tense, grammar/spelling and terminology
• Demonstrated effective time management and organizational skills, including the ability to plan and prioritize workload, ensuring timelines are met and respond to demands of a dynamic environment
• Mandatory Requirements: At least 5 years of experience
• All roles procured are required to be cleared through the Contractor Security Clearance Process of the OPS.
• Security Clearance process, levels, roles etc. are subject to change without prior notice. Candidates may be required to undergo revised/new process (or levels) any time prior or during the term of the contract.

Must haves:

• 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, Mermaid.js, Excel
• Ability to Lead and advise on data compatibility and recommend solutions.
• Superior knowledge of the Microsoft 365 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

Expected salary

Location

Toronto, ON

Job date

Fri, 11 Oct 2024 07:22:28 GMT

To help us track our recruitment effort, please indicate in your email/cover letter where (un-jobs.net) you saw this job posting.