Data Analyst Medellin. Monday to Friday PERMANENT POSITION $6M to $9M per month (depending on experience) DESCRIPTION: RESPONSIBILITIES AND DUTIES: Essential Functions: Develop and maintain SQL queries, stored procedures, and scripts for data extraction, transformation, and loading (ETL). Debug and analyze data to identify relevant problems, trends, and patterns. Optimize the queries, stored procedures, and functions developed in the current databases to improve performance and efficiency. Generate reports and data visualizations. Generate documentation of the developments carried out. Implement automated database integration processes. Support and promptly attend to assigned requirements. Create solutions that strengthen current processes. Guarantee the quality and integration of the data.Responsibilities **Requirements**: Bilingual, with a high level of competence in English and Spanish. Experience in the health insurance and/or travel industry. Excellent oral and written communication skills to discuss with stakeholders problems, needs and propose solutions. Proactive in proposing creative solutions to problems presented. Agility to solve problems and develop solutions. Ability to work in teams. Ability to work on several projects at the same time. Strong organizational and attention to detail skills. Skilled with Microsoft Office programs such as Word, Excel, PowerPoint, etc.NECESSARY KNOWLEDGE Broad knowledge and experience in SQL, including the ability to write complex queries and optimize query performance. (mandatory) Experience in debugging and data analysis to identify problems and patterns (mandatory) Data integration and loading (mandatory) Experience in developing ETL processes using at least one ETL tool (mandatory)Experience in the development and maintenance of stored procedures (mandatory) Query optimization in databases. Knowledge and experience in handling different databasesSQL Server DB2 - AS400 PostgreSQL MySQLAbility to configure and maintain automated database integration processes. Experience in generating reports and data visualizations using tools such as Power BI Knowledge and experience in agile development methodologies Desirable experience in the use of JIRA Education and Experience: A professional degree related to the following areas: systems, computer science, information science, or related fields. Minimum 3 years of professional experience in a similar role. At ttg, “We believe in making a difference One Person at a Time,” ttg OPT