We're Hiring: Data & Reporting Automation Analyst? Location: Bogotá, Colombia | On-site
? Company: Ace Link Solutions SAS
?? Client: U.S.-based transportation and logistics company
? Salary: COP $4,400,000 per month + all statutory benefits
? Contract: Indefinite-term employment contract (Contrato a término indefinido)
? Schedule: Monday to Friday | 42 hours per week
⏳ Experience: Minimum 2 years of relevant professional experience
About the RoleAce Link Solutions is looking for a skilled Data & Reporting Automation Analyst to join our team in Bogotá, Colombia, supporting the reporting, analytics, and automation needs of a U.S.-based transportation and logistics company.
This is a hands-on technical role for someone who can independently investigate PostgreSQL databases, develop complex SQL queries, build Power BI dashboards using multiple data sources, and automate reporting processes using tools such as Python and Power Automate.
You'll work closely with our Data Analytics Team Lead and support departments including Operations, Load Planning, Customer Service, Sales,



and Accounting.
Excellent English communication skills are essential. You will collaborate with a U.S.-based organization and must be comfortable discussing technical topics, understanding business requirements, and communicating professionally in English, both verbally and in writing.
Key Responsibilities• PostgreSQL Database Investigation: Explore and investigate PostgreSQL databases, understand schemas and table relationships, identify relevant data sources, and independently determine how to extract the required information.
• SQL Query Development: Create, optimize, maintain, and troubleshoot complex SQL queries involving joins, subqueries, CTEs, aggregations, and data transformations.
• Multi-Source Dashboard Development: Build and maintain Power BI dashboards that combine data from multiple sources, including SQL databases, spreadsheets, CSV files, APIs, and other business systems.
• Data Integ

📌 Data analyst and business intelligence (Bogotá)
🏢 Ace Link Solutions
📍 Bogotá