Jobs Database Developer SQL in Colombia

Rol: Ingeniero Analista de Aplicaciones - L1 Requisitos: Ingeniero de Sistemas o carreras afines. Conocimientos medios de SQL, con experiencia demostrable, preferiblemente contra base de datos Oracle. Capacidad analítica. Conocimiento de Webservice SOAP. Experiencia en soporte de aplicaciones Web. Dominio de Excel. Conocimientos en Java / J2EE. Conocimientos de XML y JSON. Función: El objetivo primordial del equipo es analizar evidencias de errores reportados y determinar un diagnóstico de dicho error, en donde entran en juego las capacidades analíticas del trabajador al tener que comprender el funcionamiento de toda una plataforma de banca empresarial, compuesta por diversas aplicaciones y bases de datos (comunicaciones por WS, transmisión de archivos, etc). Condiciones Laborales: Lugar de Trabajo: Bogotá. Tipo de Contrato: A Término Indefinido. Salario: A convenir de acuerdo a la experiencia. Esta vacante es divulgada a través de ticjob.co

You will work as part of a client team supporting a Data Communications Lead and Data Manager on the collection, ingestion and processing of marketing data and deliver cleaned data to the modelling side of the team for analysis. The Data Analyst is expected to make use of data processing techniques including SQL and ETL to handle the data. They will also utilise our internal data automation tools to ensure data pipelines, which clean and transform data, are executed effectively. Additionally, the Data Analyst will work with the Data Manager on co-ordinating with client and agency contacts around continued flow of data from relevant data sources. The role will also interact with the wider data community, especially with members of the Data Centre or Excellence (DCOE) to share best practice and both provide and receive support. Role: Data Analyst Experience & Expertise: Comfortable working with large amounts of Data in a Cloud Ecosystem. Familiar with standard data processing tools/concepts (e.g. SQL, ETL), and experience driving robust QA Processes. Snowflake experience a plus. Experience with Data manipulation/visualization tools (e.g. Excel, SQL, Tableau). Python / R experience a plus. Extreme attention to detail a must. Understanding or experience of business marketing and media a plus. Strong interpersonal and communication (written and oral) skills. Team orientated attitude. Capacity to learn new skills and master new tools. Advanced English level. What you'll do: Data Management & Analysis: Manage data extraction, manipulation and validation. Undertake data extraction and processing. Build Data QA insights relevant to the project. Ensure that all data is systematically checked and passes all QA steps. Data Architecture: Execute and update data pipelines. Building and maintaining data ingestion and transformation pipelines. Working with fellow data analysts to building scalable solutions using ETL / ELT Pipelines. Research & Development: Support wider improvements in data. Propose better approaches to help improve internal procedures including new methodology, etc. Share techniques and ideas with the wider data community. Labor Conditions: Workplace: Bogotá. Type of Contract: Indefinite Term. Salary Range: $4,000,000 - $5,000,000. This vacancy is disclosed through ticjob.co