Analyst in ETC (Extraction, Transformation, Data Loading)
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
- Design, develop and maintain solutions for data extraction, transformation, loading and provision;
- Develop data processing and pipelines using SQL and PL/SQL;
- Develop dimensional data warehouses and operational data stores that meet business needs;
- Structure data architectures and the infrastructures necessary for their exploitation;
- Ensure the quality, reliability, integrity and security of data through the application of appropriate controls;
- Collaborate with data analysts, business intelligence specialists and data scientists to meet their information needs;
- Automate data flows and optimize loading and transformation processing;
- Validate data and resolve anomalies that may affect its use;
- Document the processes, transformations and business rules associated with the data;
- Enforce applicable data governance and privacy requirements.
- Hold a bachelor's degree in information technology, business administration or a related field;
- Have a minimum of five (5) years of experience in SQL and PL/SQL programming;
- Master the design, development and maintenance of dimensional data warehouses or operational data stores;
- Leverage Oracle or PostgreSQL databases in enterprise environments;
- Develop data extraction, transformation and loading processes as well as data pipelines;
- Use visualization and reporting tools such as Qlik Sense, Tableau or Power BI;
- Participate in projects carried out using agile approaches;
- Understand the principles of data modeling and data warehouse architecture;
- Analyze complex needs and recommend solutions adapted to business objectives;
- Demonstrate rigor, autonomy and excellent analytical skills;
- Collaborate effectively with multidisciplinary teams and communicate clearly with stakeholders.
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