Offer summary

Qualifications:

Bachelor’s degree in Information Technology or a related field, or 5+ years of progressive IT experience., 3+ years of experience in Microsoft SQL database development and/or analysis., Proficiency in Microsoft Power BI, SSIS, and T-SQL, including performance tuning., Strong experience with REST and SOAP APIs, and familiarity with Azure SQL and cloud-based services..

Key responsibilities:

Design and develop data models, transformations, and interfaces using Microsoft SQL Server and SSIS.

Manage data flows between systems, including file-based and API integrations.

Develop and maintain dashboards and reports in Microsoft Power BI to support business intelligence needs.

Collaborate with engineering teams to improve data integrations and automate manual processes.

Job description

Description

Company Overview:

Lean Tech is a rapidly expanding organization situated in Medellín, Colombia. We pride ourselves on possessing one of the most influential networks within software development and IT services for the entertainment, financial, and logistics sectors. Our corporate projections offer a multitude of opportunities for professionals to elevate their careers and experience substantial growth. Joining our team means engaging with expansive engineering teams across Latin America and the United States, contributing to cutting-edge developments in multiple industries.

As a Mid + Database Developer and Analyst you will play a critical role in supporting the organization's data infrastructure, focusing on the development of data interfaces, managing data imports/exports, and supporting business intelligence needs. This role requires strong experience with Microsoft SQL Server, Power BI, and ETL tools, and will contribute to both operational and strategic initiatives across various departments.

Position Title: Mid+ Database Developer and Analyst

Location: Remote

What you will be doing:

You will work closely with our operations and engineering teams to ensure our business runs on clean, consistent, and well-structured data. This role combines database development, data validation, and reporting to drive better decisions and system performance. If you're passionate about data accuracy, process automation, and making a tangible impact through data infrastructure, we want to hear from you.

Design and develop data models, transformations, and interfaces (ETL/ELT) using Microsoft SQL Server and SSIS.
Manage data flows between systems, including file-based and API integrations.
Develop and maintain dashboards and reports in Microsoft Power BI.
Write and maintain stored procedures and SQL queries to support reporting and integration.
Ensure database security, efficiency, reliability, and compliance.
Collaborate with the engineering team to improve backend data integrations and contribute to the automation of manual data processes.
Design internal reports and dashboards used by client operations and leadership teams.
Create documentation for logic flows, tables, and scripts to support future maintenance and onboarding.
Support business and systems reporting, helping the organization make data-informed decisions.
Act as a point of contact for operations data needs, helping non-technical stakeholders translate business questions into data requests.

Required Skills & Experience:

Bachelor’s degree in Information Technology or a related field, or 5+ years of progressive IT experience.
3+ years of experience in Microsoft SQL database development and/or analysis.
3+ years of hands-on experience with Microsoft Power BI, SSIS, and T-SQL (queries, stored procedures, and performance tuning).
Proficiency in Azure SQL and cloud-based database services.
Strong experience with REST and SOAP APIs, including JSON and XML.
Experience with system integrations and working with legacy systems is required.

Good to Have:

Experience with Microsoft SSAS for BI reporting and maintenance.
Understanding of OLTP and OLAP systems and data modeling.
Knowledge of data governance and compliance standards (e.g., FERPA, HIPAA).
Industry experience in logistics or student transportation is a plus.

Soft Skills:

Strong problem-solving and analytical skills.
Excellent communication and collaboration skills, particularly in cross-functional teams.
Adaptable with the ability to work in a fast-paced, ever-evolving environment.
Must be a "builder" with the drive and initiative to design and implement new systems and processes from the ground up.
A proactive and solutions-oriented approach to challenges and troubleshooting.

Why you will love Lean Tech:

Join a powerful tech workforce and help us change the world through technology
Professional development opportunities with international customers
Collaborative work environment
Career path and mentorship programs that will lead to new levels.

Join Lean Tech and contribute to shaping the data landscape within a dynamic and growing organization. Your skills will be honed, and your contributions will play a vital role in our continued success. Lean Tech is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

Required profile