Senior Specialist, Data Modeler (Microsoft
$119k per yearVale Base Metals
You bring strong hands-on technical skills in SQL Server, Azure Data Factory, Databricks, and ETL frameworks, combined with a solid understanding of data governance, architecture, and performance optimization.
You are a collaborative partner who can work across technical and business teams, translating requirements into scalable data solutions. You are comfortable guiding power users, supporting democratized data environments, and driving best practices in modeling, governance, and performance.
You are passionate about improving data quality, enabling AI and advanced analytics, and delivering impactful insights through dashboards, reporting, and data products. In This Role, You Will: Data Modeling & Architecture
- Design, develop, and maintain scalable data models across Microsoft ecosystems (SQL Server, Analysis Services, Databricks, ADF)
- Integrate data from multiple sources including databases, APIs, files, applications, and IoT devices
- Build efficient models for reporting, analytics, and AI solutions
- Design models that support drill-down and drill-through reporting functionality
- Ensure models are fault-tolerant, recoverable, and optimized for high performance
- Align models with enterprise data governance and architecture
- Identify data sources and collaborate with developers to build ETL pipelines
- Develop ETL processes using SSIS, ADF, Databricks, and related tools
- Automate workflows to improve reliability and reduce manual intervention
- Optimize pipelines and models to process large datasets efficiently
- Support data integration with Data Lakes, Data Hubs, and enterprise platforms
- Design and support data models for Power BI and enterprise reporting tools
- Build and optimize reports, dashboards, and visualizations
- Ensure data accuracy, integrity, and performance across reporting solutions
- Collaborate with stakeholders to gather requirements and deliver insights
- Enable data-driven decision-making across business functions
- Collaborate with Data Scientists and Engineers to support machine learning solutions
- Prepare and model data for predictive analytics, anomaly detection, and AI use cases
- Build pipelines and models supporting advanced analytics initiatives
- Act as a trusted advisor on data modeling, reporting, and analytics best practices
- Guide power users and democratized teams on governance and performance optimization
- Collaborate with vendors, infrastructure teams, DBAs, and developers
- Ensure compliance with data governance, privacy, and security standards
- Evaluate vendor deliverables and support production rollouts
- Create and maintain comprehensive documentation (models, mappings, architecture)
- Provide training and knowledge transfer to stakeholders and peers
- Support communication, presentations, and change management initiatives
- Contribute to continuous improvement and data maturity programs
- Bachelor's degree in Computer Science, Data Science, Software Engineering, or a related field
- Azure Cloud Certifications
- Microsoft (ADF, SSIS, Analysis Services) Certifications
- Databricks Certifications
- Data Modeling / Data Engineering Certifications
- Data Visualization or BI Certifications
- AI / Machine Learning Certifications
- Certified Data Management Professional (DAMA)
- 8–10+ years of experience in data modeling, data engineering, or analytics roles
- Strong hands-on experience with Microsoft data stack (SQL Server, SSIS, SSAS, ADF, Azure, Databricks)
- Experience building ETL pipelines, data models, and reporting solutions
- Experience supporting BI, analytics, and AI/ML use cases
- Proven ability to work across complex, multi-stakeholder environments
- Experience collaborating with vendors and cross-functional teams
- Experience in mining, heavy industry, or similar domains is an asset
- Expert data modeling and ETL development skills
- Strong proficiency in SQL, Python, and data scripting languages
- Deep understanding of cloud data platforms and architecture (Azure preferred)
- Strong knowledge of data governance, data quality, and security practices
- Experience with BI tools such as Power BI and data visualization techniques
- Ability to analyze complex datasets and translate into actionable insights
- Strong communication and stakeholder engagement skills
- Project management, prioritization, and problem-solving capabilities
- Ability to work in agile, fast-paced, and evolving environments
- Competitive compensation including a variable annual incentive plan
- Participation in a competitive Defined Contribution Pension package
- Comprehensive benefits package (company paid core coverage, health and dental coverage, flex accounts, disability plans, and optional insurances)
- Leave for all of life's reasons (vacation, personal, sick, parental)
- Work culture dedicated to safety, diversity & inclusion, and career growth
- Employee Family Assistance Program
- Virtual Healthcare online
- Online training and career development opportunities
$112k per year
...enduring. The Opportunity We are currently seeking a Specialist, Data Developer (Microsoft) to join our Data Platforms & Foundation team within Information... ...Build and maintain data lakes, warehouses, semantic models, and analytics environments Ensure data solutions...MicrosoftPermanent employmentFull timeWork at office- Do you have a minimum 5 years of experience as a Data Architect, Data Specialist, or equivalent role in complex, multi‑system environments... ...great opportunity for you! Our client is looking for a Senior Data Architect/Modeller for a 12 month contract in Toronto. This is an...SeniorContract work
- ...Job Description We are seeking an experienced Enterprise Data Modeler with strong expertise in Insurance Data Modeling and ACORD standards to design and govern scalable, integrated, and enterprise-wide insurance data ecosystems. The ideal candidate will have...Suggested
$85k - $100k per year
...a proven track record on executing project deliverables? Our Microsoft team is looking for a professional like you with the skills and drive... ..., where you'll help organizations modernize and transform their data governance, security, and compliance strategies using Microsoft...SeniorMicrosoftFull timeInternship$90k - $130k per year
...Context We are looking for a Data Engineering Specialist for the Go Expansion program as part of... ...Analytics and Insights Apply data modeling expertise to design and optimize data... ...V4, and certifications in tools like Microsoft SQL Server, Tableau, AWS, Azure, or GCP...MicrosoftFlexible hours$68k - $102k per year
...Job Type: Permanent Work Model: Hybrid Reference code: 132114 Primary Location... ...finance, mathematics, statistics, data science or other relevant post-graduate degree... ...102,000 (Consultant) or $84,000 - $126,000 (Senior Consultant), and individuals may be eligible...SeniorPermanent employmentFlexible hours$69k - $114k per year
...Job Type: Permanent Work Model: On-site Reference code: 133360 Primary Location... ...solutions. By applying a strategic, data-driven mindset, you will leverage analytics... ...business requirements Advanced proficiency Microsoft Excel skills. Intermediate proficiency in...SeniorMicrosoftPermanent employmentFlexible hoursShift work$20 - $40 per hour
...include Benchmark , General Catalyst , Peter Thiel , Adam D'Angelo , Larry Summers , and Jack Dorsey . Position: Microsoft Word Expert – Artifact Docs Conversion Type: Contract Compensation: $20–$40/hour Location: Remote Role...MicrosoftRemote jobContract workSummer workFlexible hours- ...Role Description Seeking an experienced Data Modeler with strong expertise in Capital Markets, Banking, and U.S. Regulatory Reporting domains. The candidate will be responsible for designing and maintaining enterprise data models supporting trading, risk, finance, compliance...Senior
$70 - $75 per hour
...Job Title: Data Analytical Specialist/Scientist - Senior Location: Hybrid – 3 days onsite / 2 days remote (subject to change) Contract: 6 month contract... ...Validation 8+ years of hands-on experience with Microsoft Azure Key Responsibilities Data Mapping &...SeniorMicrosoftContract workRemote work$69k - $114k per year
...Job Type: Permanent Work Model: Hybrid Reference code: 133221 Primary Location... ...typical day look like? The Ethics Senior Consultant plays a critical role in strengthening... ...organization’s ethical culture through data‑driven analysis, reporting, and insights...SeniorPermanent employmentWork at officeFlexible hours$144k - $200k per year
...Canada is seeking an experienced Senior Manager –Solution Architect to join our growing Microsoft Customer Engagement and Power Platform... ...on increasing customer and data-centric digital transformation strategies... ...Power Platform (Canvas Apps, Model-driven Apps, Power Automate,...SeniorMicrosoftLong term contractFor contractorsWorldwideWeekend work- ...markets. A failure to effectively prepare for and manage emerging model risk related to AI would subject RBC to financial, regulatory, and... ...exploring modelling considerations such as conceptual soundness, data processing, metric reproducibility & stability, benchmarking, robustness...Full time
$72k - $138k per year
...Job Type: Permanent Work Model: Hybrid Reference code: 128409 Primary Location: Toronto, ON All Available Locations... ...of our delivery processes and tools. We aim at the excellence on Microsoft Dynamics 365 platform, develop new ways of better serving our customers...SeniorMicrosoftPermanent employmentFlexible hours$88k - $132k per year
...EY Canada is seeking an experienced Senior Consultant to join our growing Microsoft Power Platform team. Our Microsoft solutions... ...on increasing customer and data-centric digital transformation strategies... ...-based projects. Ability to model complex business processes and structure...SeniorMicrosoftWorldwide- ...City: Toronto Summary As the Specialist, SCM Data, you will be joining a team that embraces... ...manage the data, clean and prepare for modelling. ● Data Analysis: Support and maintain... ...using the following services/tools: 1. Microsoft Azure cloud services: Azure Data...SeniorMicrosoftInternshipWork at officeLocal areaRemote work
- ...Job Title: TSBI / Business Systems Analyst (Data Warehouse & Data Modelling) Location: Toronto, ON – Hybrid (2 Days/Week Onsite) Experience... ...legacy systems, create mapping documents, support L2/L3 data model design, and drive data integration initiatives across...Contract work2 days per week
$90k - $125k per year
...carbon and replace cars. Could you be the full-time Data Center Infrastructure IT Specialist in Toronto, ON we’re looking for? This job posting... ...(SUSE/Ubuntu/RHEL) ~ Hands-on experience managing Microsoft SQL Server in production (install/configure, backup/restore...MicrosoftLong term contractFull timeWorldwide$81.5k - $95k per year
...We are looking for a highly organized and detail‑oriented Data Operations Specialist to manage and optimize data across our entire data landscape... ...Prepare, structure, and organize datasets required for AI model development and analytics. Ensure timely availability of...Long term contract$81.5k - $95k per year
...class Aecon community! What is the Opportunity? As the Data Engineering Specialist, you will be versatile and driven to help build the data... ...data pipelines, transform complex data sources, and ensure our models have the high-quality inputs they need to deliver real impact...- ...Job Title: Data Analytics/ Microsoft Sales Representative Employment: Full-time Location: Toronto, Canada OSI Digital is a global consulting firm with over three decades of experience helping organizations accelerate their digital transformation. As a trusted partner...MicrosoftLong term contractFull timeContract work
$62.87k - $147.5k per year
...are the same. Job Description Role: Data Engineer Location: Canada – PST (Remote... ...and external data feeds. Develop data models that enable the efficient analysis and manipulation... ...licenses, Relevant experience and skills, Seniority and performance, Market and business...SeniorPermanent employmentFull timeLocal areaRemote work$103.2k - $192k per year
...Dundas Street West Job Family Group: Data Analytics & Reporting This is a 12... ...and constructs new processes for modeling data. Develops predictive models and leverages... ...enterprise-wide level and serves as a specialist resource to senior leaders and stakeholders. Applies...SeniorContract workTemporary workPart timeShift work$95k - $145k per year
Senior Data Analyst Position Description CGI is a global business and technology service provider with $11.5B in revenues. CGI is on a... ...them into data-driven insights. 5. Design and implement data models, ensuring data accuracy and consistency. 6. Provide recommendations...SeniorWork at officeWorldwide3 days per week- ...) Department, you will analyze and ensure data received from member employers and other third... ...with OTPP's policies. As a Member Data Specialist Trainee, you will have the opportunity to... ...s Teachers. Under the direction of a Senior and/or Team Coordinator: Assist employers...SeniorFull timeTraineeshipWork at officeRemote workFlexible hours
$61.6k - $113.9k per year
...and a 196-year dividend history. Drive data engineering and automation initiatives... ...systems thinking, and technical design. Microsoft Power Platform certifications: PL-900... ...Have advanced skills: Power BI - Data modeling, DAX, dashboard design. Power Apps - Low...MicrosoftFull timeContract workPart time- Do you have 8+ years experience in Data Mapping & Documentation? Do you have 8+ years experience in Data Quality & Validation... ...a great opportunity for you! Our client is looking for a Senior Data Analytical Specialist/Scientist for a 6 month contract in Toronto. This is a...SeniorContract workRemote work
$66.5k - $101k per year
...career can make a difference. The Central Data Support Team (CDST) is a part of the... ...PySpark, Azure Data Factory, Databricks, Microsoft Fabric, Azure Data Lake Storage, Power BI... ...including SQL stored procedures and data modeling) or cloud technologies (Azure suite, Databricks...SeniorMicrosoftLong term contractPermanent employmentFull timeInternshipFlexible hours$75k - $85k per year
...and rapidly expanding internationally in regions like Europe, Southeast Asia and the Middle East. Job Overview: The Data Extraction Specialist is responsible for the creation, maintenance, and execution of CMiC Data Mapping and Extraction scripts, which will be used...Full timeSeasonal workNight shiftWeekend workWeekday work- ...have been creating a global network of youth-HIV leaders. Job Overview: We are seeking a creative and strategic Digital Marketing Specialist to join our team. This role will focus on enhancing LetsStopAIDS' online presence, driving engagement, and growing our digital...Full timeWork at officeMonday to fridayShift work
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Senior Specialist, Data Modeler (Microsoft. Be the first to apply!
- spécialiste en amélioration continue Toronto, ON
- spécialiste talent Toronto, ON
- health promotion specialist Toronto, ON
- grocery specialist Toronto, ON
- visual specialist Toronto, ON
- disability management specialist Toronto, ON
- ecommerce specialist Toronto, ON
- emergency management specialist Toronto, ON
- fire specialist Toronto, ON
- optimization specialist Toronto, ON
