Data Analyst 1785

INGEPSY; Medellín; Presencial; COP 33.480.000 - 61.380.000; Jornada completa

Descripción de la vacante

INGEPSY is seeking a technically strong Data Analyst to join its Compliance team in Medellín. You will work with raw datasets, investigate data quality issues, apply statistical reasoning, and deliver actionable insights to support business decisions.

You will use SQL and Python (or R) to query, transform, and automate analyses, collaborate with engineering and business stakeholders, and help build reliable data workflows in a regulated environment.

Formación

• Bachelor's degree in a technical field.
• 2+ years in data analysis beyond reporting.
• 2+ years writing SQL against relational databases.
• 1+ year using Python or R for data manipulation.
• Experience with raw/unstructured data and documenting transformations.
• Git version control experience.
• Strong statistical concepts and hypothesis testing.
• Professional English communication.

Responsabilidades

• Investigate complex business problems and provide data-driven recommendations.
• Perform exploratory data analysis to uncover trends and anomalies.
• Assess data quality and document transformation decisions.
• Apply statistical methods to validate hypotheses.
• Develop and maintain repeatable data workflows and analyses.
• Present findings clearly to business stakeholders.
• Use SQL and Python (or R) to query, transform, and analyze data.
• Collaborate with business and engineering teams to improve data processes.

Conocimientos

Data analysis

SQL

Python

Git

English communication

Analytical thinking

Stakeholder collaboration

Educación

Bachelor's degree

Herramientas

PostgreSQL

MySQL

SQL Server

Power BI

Tableau

Pandas

Descripción del empleo

Descripción del trabajo Job Description

We are looking for a technically strong Data Analyst to join our Compliance team. This role is ideal for someone who enjoys solving complex business problems through data analysis rather than simply creating reports. You will work with raw and complex datasets, investigate data quality issues, apply statistical reasoning, and deliver reliable, actionable insights that support business decisions.

Key Responsibilities

• Investigate complex and ambiguous business problems from definition through solution, providing data-driven recommendations.
• Perform exploratory data analysis (EDA) to uncover trends, patterns, and anomalies.
• Assess data quality, identify inconsistencies at the source, determine root causes, and document transformation decisions.
• Apply statistical methods to validate hypotheses and ensure conclusions are supported by data.
• Develop and maintain repeatable, reliable data workflows and analysis processes.
• Present technical findings in a clear and concise manner for business stakeholders.
• Use SQL and Python (or R) to query, transform, automate, and analyze data.
• Partner with business and engineering teams to improve data quality and data collection processes.

Requisitos

• Bachelor's degree in Computer Science, Systems Engineering, Data Engineering, Statistics, Mathematics, or a related technical field.
• 2+ years of experience in a data analysis role with hands‑on analytical work beyond reporting.
• 2+ years of experience writing SQL queries against relational databases such as PostgreSQL, MySQL, or SQL Server.
• 1+ year of experience using Python (preferred) or R for data manipulation, transformation, and analysis.
• Experience working with raw or unstructured datasets, including documenting transformation logic and analytical assumptions.
• Experience using Git for version control.
• Familiarity with statistical concepts, including hypothesis testing, distributions, and correlation vs. causation.
• Strong analytical thinking and problem‑solving skills.
• Ability to collaborate effectively with technical and non‑technical stakeholders.
• Professional English communication skills.

Preferred Qualifications

• Experience with Power BI or Tableau for data visualization.
• Experience building repeatable analytical workflows and automating data processes.
• Background working with compliance, risk, audit, or regulated business environments.

Required Technologies & Tools

• SQL
• Python (Pandas, NumPy) or R
• PostgreSQL, MySQL, or SQL Server
• Git
• Power BI or Tableau (nice to have)

Core Skills

• Advanced analytical thinking
• Exploratory Data Analysis (EDA)
• Data quality analysis and root cause investigation
• Statistical reasoning and hypothesis testing
• Data transformation and automation
• Cross-functional collaboration
• Clear communication of technical findings

Requirements

Bachelor's degree in Computer Science, Systems Engineering, Data Engineering, Statistics, Mathematics, or a related technical field. 2+ years of experience in a data analysis role with hands‑on analytical work beyond reporting. 2+ years of experience writing SQL queries against relational databases such as PostgreSQL, MySQL, or SQL Server. 1+ year of experience using Python (preferred) or R for data manipulation, transformation, and analysis. Experience working with raw or unstructured datasets, including documenting transformation logic and analytical assumptions. Experience using Git for version control. Familiarity with statistical concepts, including hypothesis testing, distributions, and correlation vs. causation. Strong analytical thinking and problem‑solving skills. Ability to collaborate effectively with technical and non‑technical stakeholders. Professional English communication skills.