Senior Data Scientist - Power BI & AI
$109,000–$174,800 year
HybridNew Brunswick, Canada
Job Summary
Design, develop, and maintain enterprise-grade Power BI semantic models that integrate financial data and data science outputs to support decision-making. Build and optimize trusted, analysis-ready datasets using SQL, PySpark, and modern data modeling practices while applying best practices in DAX optimization, workspace governance, and performance tuning. Prepare data for AI and Copilot-enabled analytics experiences by simplifying schemas, setting up verified answers, and authoring domain-specific instructions. Partner effectively with business stakeholders, data engineers, and data scientists to define requirements and deliver scalable, enterprise-ready decision-support solutions.
Required Qualifications
- 7+ years of hands-on experience developing production-grade BI and analytics solutions in enterprise environments
- Bachelor Degree required
- Master degree preferred
- Deep expertise in Power BI, including semantic modeling, dashboard development, DAX, and performance optimization
- Strong SQL skills and experience transforming large, complex datasets into trusted analytical models
- Strong understanding of dimensional modeling, data warehousing concepts, and enterprise semantic model design
- Experience integrating data science outputs such as forecasts, predictions, or statistical measures into BI solutions
- Experience working closely with business stakeholders to define requirements, KPIs, and reporting solutions
- Experience with Microsoft Fabric and familiarity with modern data and analytics workflows
- Strong engineering discipline, including documentation, testing, governance, and support of production solutions
- Bachelor's degree in Computer Science, Information Systems, Data Science, Engineering, Business Analytics, Statistics, Finance, or a related quantitative field
- Experience using Python or R for data analysis, automation, or advanced analytics
- Experience with Copilot in Power BI, Fabric agents, or related AI-enabled analytics capabilities
- Experience preparing data for AI, including schema simplification, verified answers, and instruction authoring
- Experience with large-scale enterprise datasets, including financial or operational data
- Familiarity with DevOps practices for BI, including Git, pipelines, and automated testing
- Experience designing performant semantic models at scale
- Experience with SAP and familiarity with SAP backend tables
- Experience in finance, enterprise reporting, or other data-intensive business environments
Desired Qualifications
- Experience building analytics products that go beyond reporting to support decision automation and intelligent workflows
- Familiarity with enterprise-scale governance, security models, and adoption practices for BI platforms
- Experience mentoring other developers or helping establish BI development standards and best practices
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.