Data Analytical SpecialistScientist
Share
Job Location:
Monthly Salary:
Posted on:
4 hours ago
Vacancies:
1 Vacancy
Job Summary
Job Summary:
The Data Analytical Specialist role within the Data Platform team focuses on designing and deploying data and cloud infrastructure solutions. This role involves detailed data mapping documentation and collaboration with various stakeholders to ensure data accuracy and alignment with business needs. The specialist will also support data quality validation and contribute to reporting and insights.
The Data Analytical Specialist role within the Data Platform team focuses on designing and deploying data and cloud infrastructure solutions. This role involves detailed data mapping documentation and collaboration with various stakeholders to ensure data accuracy and alignment with business needs. The specialist will also support data quality validation and contribute to reporting and insights.
Location:Toronto Ontario Canada
Responsibilities:
- Lead detailed data mapping activities between source systems data platforms and target destinations.
- Document field-level mapping transformation rules data lineage and business logic.
- Ensure mappings align with enterprise data standards governance rules and architectural patterns.
- Maintain clear and version-controlled mapping specifications for engineering teams.
- Analyze and profile datasets to understand data structures quality issues relationships and anomalies.
- Validate that mapped data accurately represents business processes and stakeholder expectations.
- Identify data gaps inconsistencies and risks during migration or integration projects.
- Work closely with data engineers architects business analysts product owners and SMEs to gather requirements.
- Translate business definitions into technical mapping documentation.
- Facilitate workshops to resolve data ambiguities clarify business rules and align on mapping decisions.
- Support testing teams by providing validation rules and expected outputs for data transformations.
- Perform data reconciliation between source and target systems.
- Partner with data governance teams to improve data integrity metadata accuracy and documentation quality.
- Build dashboards reports or analytics as needed to support business needs.
- Present findings and recommendations clearly to technical and non-technical stakeholders.
- Contribute to self-service analytics and standardized reporting frameworks.
- Lead detailed data mapping activities between source systems data platforms and target destinations.
- Document field-level mapping transformation rules data lineage and business logic.
- Ensure mappings align with enterprise data standards governance rules and architectural patterns.
- Maintain clear and version-controlled mapping specifications for engineering teams.
- Analyze and profile datasets to understand data structures quality issues relationships and anomalies.
- Validate that mapped data accurately represents business processes and stakeholder expectations.
- Identify data gaps inconsistencies and risks during migration or integration projects.
- Work closely with data engineers architects business analysts product owners and SMEs to gather requirements.
- Translate business definitions into technical mapping documentation.
- Facilitate workshops to resolve data ambiguities clarify business rules and align on mapping decisions.
- Support testing teams by providing validation rules and expected outputs for data transformations.
- Perform data reconciliation between source and target systems.
- Partner with data governance teams to improve data integrity metadata accuracy and documentation quality.
- Build dashboards reports or analytics as needed to support business needs.
- Present findings and recommendations clearly to technical and non-technical stakeholders.
- Contribute to self-service analytics and standardized reporting frameworks.
Required Skills & Certifications:
- Bachelors degree in Data Science Information Systems Computer Science Business Analytics or related field.
- 8 years experience in data mapping data modeling or data migration projects.
- 8 years experience in Data Quality & Validation
- Proficiency in SQL (intermediate to advanced).
- Proficiency in data analysis and profiling techniques.
- Proficiency in Excel or other analysis tools.
- Proficiency in data visualization tools (Power BI).
- Understanding of relational databases structured data and data integration patterns.
- Ability to interpret and document data transformation logic clearly.
- Strong communication and documentation skills.
- Bachelors degree in Data Science Information Systems Computer Science Business Analytics or related field.
- 8 years experience in data mapping data modeling or data migration projects.
- 8 years experience in Data Quality & Validation
- Proficiency in SQL (intermediate to advanced).
- Proficiency in data analysis and profiling techniques.
- Proficiency in Excel or other analysis tools.
- Proficiency in data visualization tools (Power BI).
- Understanding of relational databases structured data and data integration patterns.
- Ability to interpret and document data transformation logic clearly.
- Strong communication and documentation skills.
Preferred Skills & Certifications:
- Public sector experience is not necessary.
- Public sector experience is not necessary.
Special Considerations:
- Hybrid work model: 3 days onsite/2 days remote (subject to change).
- Hybrid work model: 3 days onsite/2 days remote (subject to change).
Scheduling:
-
-
