SQL Analyst and Data Management

Description

Job Summary: We are seeking a passionate SQL Analyst with expertise in data management to design, optimize, and audit data flows, ensuring system quality and performance. Key Highlights: 1. Directly impact system quality and performance 2. Design, analyze, and optimize SQL queries 3. Collaborative work and continuous improvement in data management Join our team as an SQL Analyst & Data Manager Are you passionate about understanding how data flows from applications to the database—and transforming that information into robust, efficient, and reliable structures? This is your opportunity to directly impact the quality and performance of our systems. At BPO Global Services, we are an inclusive organization that values collaborative work, continuous improvement, and the importance of well-structured data from its source. Today, we seek an SQL Analyst with strong technical expertise and an analytical mindset. What will be your role? Design, analyze, and optimize SQL queries in SQL Server and MySQL Audit and understand the data flow from applications to the database: Inserts Updates Transactions Identify and correct poor practices in backend data writing Extract information from multiple sources such as: Other databases Flat files (CSV, Excel) External APIs or services Structure and store data in SQL while ensuring: Integrity Performance Scalability Detect and resolve issues related to: Slow queries Locks High resource consumption Support development teams in adopting best practices for data persistence Propose data model improvements based on information origin What are we looking for in you? Mandatory Solid SQL proficiency: Complex JOINs Subqueries CTEs Indexes Stored Procedures Experience with SQL Server and/or MySQL Ability to understand how applications insert data into the database Basic/intermediate knowledge of JavaScript and TypeScript for backend code reading Experience integrating and loading data from multiple sources into SQL Desirable Experience with ETL/ELT processes API consumption and handling of external data Use of ORMs or query builders Strong judgment in data modeling and normalization Ideal Profile Technician or professional in Systems, Industrial Engineering, Statistics, and/or Databases Minimum 3 years of experience in this role Analytical, proactive, and optimization-oriented Strong technical communicator with development teams Job Conditions Contract: Indefinite-term, direct employment with the company. Schedule: Monday to Friday, with Saturday availability Work Location: Medellín. · Here, you don’t just analyze data—you help improve the entire information ecosystem from its foundation.-Requirements- Minimum Education: University degree / Technical program 3 years of experience Age: 18 years or older Keywords: analyst, db, bd, sql, db2, firebird, informix, interbase, oracle, postgresql, sqlserver, data