Analyst in ETC (Extraction, Transformation, Data Loading)

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