Data Engineering Consultant
With over 30 years of recognized expertise, COFOMO is now a leading Canadian consulting firm specializing in digital and artificial intelligence. Supported by more than 3,000 experts, 10 Centers of Excellence, and 4 offices across the country, we are uniquely positioned to successfully guide our clients through their transformations. Both strategic and tactical, we help organizations across a wide range of industries thrive in today’s rapidly evolving world.
Our promise
Help our clients succeed and maximize the impact of their transformation initiatives, turning them into powerful drivers of growth and innovation.
Job description
- Develop and maintain analytical data models for advanced reports, dashboards, and use cases;
- Translate business needs into clear, documented data transformations aligned with established standards;
- Develop and maintain data transformation pipelines (ELT/ETL) in collaboration with data engineering teams;
- Participate in decisions related to analytical modeling, including models, standards, patterns and semantic layers;
- Collaborate with data architecture consultants to ensure alignment between data models and analytical needs;
- Analyze data from SAP and other enterprise systems to ensure consistency, quality, and business understanding;
- Ensure data quality through testing, validation, and anomaly management;
- Document transformations, data models, and business definitions;
- Collaborate with business analysts to validate metrics, indicators and definitions;
- Contribute to the continuous evolution of the analytics platform, from raw data to consumption layers;
- To act as a reference in analytical modeling and SQL development.
The profile you are looking for is as follows:
- Hold a bachelor's or master's degree in computer science, business intelligence, analytics or a related field;
- Have a strong background in advanced SQL and data transformation;
- Master dimensional modeling;
- Demonstrate an excellent understanding of Power BI best practices (Desktop and Service);
- Understand data architecture concepts and actively contribute to their evolution;
- Experience with modern BI environments such as Snowflake (an asset);
- Know DBT (an asset);
- Have experience with SAP or other ERP systems and understand their data structures;
- Be comfortable in a role that combines technical expertise with an understanding of business needs;
- Popularize complex data-related concepts to non-technical stakeholders;
- Demonstrate rigor and ensure the quality and maintainability of the solutions developed;
- Demonstrate excellent organizational and priority management skills;
- Adopt a collaborative approach and oriented towards continuous improvement;
- Have experience in an Agile delivery context;
- This position requires fluency in French and English for daily tasks, understanding documentation and professional communication with customers, suppliers and colleagues across Canada. Language skills in French and English are essential, both oral and written.
Why choose a career at COFOMO?*
- Competitive compensation and benefits
- Wellness program
- 24/7 telemedicine access
- Support for legal, accounting, and mental health needs
- Focus on growth, development, and skills enhancement
- Personalized career plan and tailored guidance
- Hybrid work environment
- Active social club and year-round events
* Only applicable to permanent COFOMO employees.

Join our team.
Make a difference every day by taking advantage of our development programs, access to our Centers of excellence, and a stimulating work environment.
Professional development
We invest in our talent, encourage continuous growth, and support you in every aspect of your career.
Latest technologies and best practices
Leverage your skills, knowledge, and problem-solving abilities on large-scale projects for leading clients.
Welcoming and people-focused organization
A place where you can feel at home. COFOMO is a space where you can grow, learn, create, contribute, and be recognized for your achievements.
Working at COFOMO gives you the opportunity to collaborate today on the technological projects of tomorrow, from green technology to the latest innovations in artificial intelligence and information security.
Our Values
Beyond words, COFOMO’s values guide our actions and shape our policies. Without them, we’d be just another company, and we are anything but that.
At COFOMO :
You are recognized and valued for your skills, expertise, and, most importantly, your potential. That’s how we measure value here.
We hire people based on talent. Period.
Everyone matters, everyone’s voice counts, and everyone is respected.
COFOMO values the differences that enable each of us to make meaningful and unique contributions to our success and shared culture. We foster diversity and inclusion, creating workplaces where new ideas, different experiences, and unique perspectives can be shared, often with people you might not otherwise have the opportunity to collaborate with.
MASCULINE OR FEMININE TERMS ARE USED INTERCHANGEABLY WITHOUT ANY INTENT OF DISCRIMINATION. COFOMO IS AN EMPLOYER OF CHOICE THAT PROMOTES DIVERSITY AND APPLIES FAIR EMPLOYMENT PRACTICES.
Employer of choice
COFOMO is a consulting firm specializing in digital transformation and artificial intelligence. We stand out for the digital ingenuity of our talent, our unique approach, and our values. Make an informed choice and discover what makes us