Senior Specialist, Data Modeler (Microsoft

Working closely with data scientists, developers, analysts, and business stakeholders, the Senior Specialist ensures that data solutions are performant, scalable, and aligned with enterprise data governance standards. Develop ETL processes using SSIS, ADF, Databricks, and related tools Automate workflows to improve reliability and reduce manual intervention 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 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 Provide training and knowledge transfer to stakeholders and peers Support communication, presentations, and change management initiatives Contribute to continuous improvement and data maturity programs You are a senior-level data modeling professional with deep expertise in Microsoft data platforms, cloud-based data architecture, and modern analytics ecosystems. You have strong experience working with large-scale, complex data sets and building high-performance data models to support reporting, analytics, and AI use cases. 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 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