Senior Data Engineer

Why you’ll love Softchoice:

We are a software-focused IT solutions and services provider that equips organizations to be agile and innovative, and for their people to be engaged, connected, and creative at work. That means moving them to the cloud, helping them build the workplace of tomorrow, and enabling them to make smarter decisions about their technology. By doing these things we help them create success for their customers and their people.

We stand proudly for our people and support their success through career development and advancement. We are recognized and respected for our culture of inclusion and belonging, continuously striving to do what’s good for our people and communities. 
 

The impact you will have:

As a senior member of the Data Engineer team, you will be responsible for leading the design development, and optimization of enterprise-grade data solution within Microsoft Fabric ecosystem. This role requires deep technical expertise, strategic thinking, and the ability to mentor junior engineers while collaborating with cross-functional teams. You will work closely with data scientists, analysts, and other stakeholders to ensure seamless data integration, transformation, and storage, enabling data-driven decision-making across the organization. 

What you’ll do:

• Design and orchestrate complex integrations across Data Factory, REST APIs, and other enterprise data services. 

• Lead scalable ELT strategies using Spark Notebooks, Data Factory, and Synapse Pipelines. 

• Architect multi‑domain Lakehouse environments, including structure, metadata, and governance standards. 

• Optimize Data Warehousing workloads and configure performance settings for high‑throughput environments. 

• Design enterprise‑grade data models and refresh strategies for scalable, governed Power BI reporting. 

• Define and enforce modeling standards and best practices across engineering and analytics teams. 

• Develop reusable, optimized Spark jobs and configure compute pools for cost‑efficient performance. 

• Establish naming conventions, workspace governance, and CI/CD deployment strategies across Fabric. 

• Lead data governance frameworks, including sensitivity classifications and access‑control standards. 

• Build monitoring dashboards, alerts, and automated testing for Fabric pipelines and operations. 

• Demonstrate expert-level platform knowledge with the ability to troubleshoot, automate, and optimize end‑to‑end Fabric solutions. 

• Partner with architects, data scientists, and business stakeholders to align technical strategy with business needs. 

• Mentor engineers, review notebooks and data models, and drive adoption of Microsoft Fabric best practices. 

• Align Microsoft Fabric capabilities with enterprise data strategy, roadmaps, and long-term growth plans. 

• Lead cross-team data initiatives and influence architectural direction, governance decisions, and platform evolution. 

• Leverage AI coding agents and AI-assisted development tools (e.g., GitHub Copilot, Windsurf, or similar) to accelerate data engineering workflows, automate repetitive tasks, and improve code quality across the Fabric ecosystem. 

• Author and review advanced DAX measures, calculated columns, and time-intelligence logic to support complex, governed Power BI semantic models. 

• Translate ambiguous business problems into clear technical requirements, adapting communication style to audiences ranging from executive sponsors to frontline analysts with varying levels of data literacy. 

What you’ll bring to the table:

• 5+ years of experience with deep expertise across the Microsoft data ecosystem, including Microsoft Fabric, Data Factory, Spark, Synapse, and Power BI 

• Proven ability to design and orchestrate complex data integrations, leveraging Data Factory, REST APIs, and other enterprise data sources 

• Leadership in defining and executing scalable ELT strategies using Spark notebooks, Data Factory, and Synapse pipelines 

• Experience architecting multi-domain Lakehouse environments, with strong governance around structure, metadata, and reuse 

• Advanced knowledge of data warehousing optimization, including performance tuning and workload configuration 

• Expertise in designing scalable Power BI semantic models, refresh strategies, and governed reporting solutions 

• Ability to define and enforce data modeling standards and best practices across multiple teams 

• Strong skills in writing reusable, high-performance Spark jobs and configuring compute pools for optimal performance and cost efficiency 

• Experience establishing naming conventions, workspace governance, and CI/CD deployment strategies 

• Leadership in data governance, including sensitivity classifications, security models, and access control frameworks 

• Ability to build and maintain monitoring, alerting, and automated testing for Fabric pipelines and data assets 

• Expert-level understanding of the Fabric platform, with the ability to troubleshoot, automate, and optimize end-to-end solutions 

• Strong partnership skills, collaborating with architects, data scientists, and business stakeholders to align technical solutions with business goals 

• A passion for mentoring and technical leadership, including code reviews, model reviews, and driving adoption of new Fabric capabilities 

• Ability to align Microsoft Fabric implementations with enterprise data strategy and long-term growth plans 

• Hands-on experience using AI coding agents and AI-assisted development tools in a data engineering context; comfort integrating AI into daily development workflows and evangelizing adoption across the team. 

• Advanced DAX proficiency, including complex measure authoring, calculation groups, and optimization techniques for large-scale Power BI semantic models. 

• Strong business acumen with a genuine interest in understanding business domains, KPIs, and decision-making processes — and the ability to build trust with stakeholders at all levels of data sophistication, from data-savvy analysts to non-technical business leaders. 

• Preferred Microsoft Fabric certification – DP600, DP700. 

• Proven experience leading cross-team data initiatives, influencing platform architecture and governance direction 

• Strong problem-solving skills and ability to work in a collaborative environment. 

• Excellent verbal, written, communication, presentation, organizational, and interpersonal skills. 

Compensation:

A reasonable estimate of the current base pay range for this position in Ontario is $91,200 to 114,000 annually + 12% Target Incentives.

Actual salary will be based on a variety of factors, including location, experience, skill set, education, and related certification. The range for this position in other geographic locations may differ.

Softchoice offers a comprehensive and competitive benefit plan to all full-time employees, which includes:

• Health and Wellbeing: Medical and Dental Care, Employee & Family Assistance Program
• Financial Benefits: RRSP/DPSP Retirement Savings Plan with Company Matching, Life and Disability Insurance
• Paid Time Off: Vacation and Sick Leave, Holidays, Parental Leave, Volunteer Days, Bereavement Leave
• Additional Perks: Employee Discount Program

Not sure if you qualify? Think about applying anyway:

We understand that not everyone brings 100% of the skills and experience for the role.

At Softchoice, we offer opportunities to a diverse group including those with a variety of workplace experiences and backgrounds.  Whether you are new to corporate tech, returning to work after a gap in employment, or looking to transition and take the next step in your career, we are excited to learn more about you and encourage you to apply.

Why You’ll Love Working Here:

• The People: You’ll thrive in our collaborative environment, surrounded by incredible colleagues who foster support and innovation, driving our collective success
• High-Performing Culture: At Softchoice, we are dedicated to achieving our goals and committed to success for our customers and each other
• Flexibility: Plan your workdays in a way that suits you best
• Award-Winning Workplace: Proudly recognized as a Great Place to Work for 20 consecutive years
• Inclusive Culture: We are committed to an inclusive culture where every team member can be their authentic self
• Competitive Benefits: Benefit from competitive perks that start on day one

Inclusion & Equal opportunity employment:

We are an equal opportunity employer committed to diversity, inclusion & belonging. People seeking employment at Softchoice are considered without regard to any protected category including but not limited to, race, color, religion, national origin, age, sex, marital status, ancestry, disability, veteran status, gender identity, or sexual orientation.

Require accommodation? We are ready to help:

We are proud to provide interview & employment accommodation during the recruitment and hiring process. If you require any accommodation to apply or interview for a position, please reach out directly to asktalentacquisition@softchoice.com. We are committed to working with you to best meet your needs.

Our commitment to your experience:

We are committed to the safety of all applicants and team members. With that in mind, we have implemented digital interviewing for everyone. We understand that you may need to interview with distractions around you (such as children or furry friends) and we will be doing the same.

Before you start with us, we will conduct a criminal record check, verify your education, and check your references.

When you join Softchoice, we will onboard you remotely. Don't worry. It's quick, simple and you'll be connected with your new team in no time.

Job Requisition ID: 7401 

EoE/M/F/Vet/Disability  

#LI-MM1