Here is a brief overview of the tasks and responsibilities that will fall to you:

- 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

The profile sought is as follows:

- 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

📌 Analyst in ETC (Extraction, Transformation, Data Loading) (Montreal)
🏢 COFOMO
📍 Montreal