Remote Lead Data Engineer (SQL) - Flexible Hours

BairesDev; Colombia; Remote; COP 284,765,000 - 411,327,000; Full time

Benefits offered by this job

100% remote work

USD or local currency pay

Hardware setup for home office

Flexible hours

Paid parental leave

Vacations and national holidays

Multicultural work environment

Mentorship and growth opportunities

Job summary

BairesDev is seeking a Lead Data Engineer (SQL) to drive the design, optimization, and management of robust database systems for enterprise applications. You will mentor peers and guide data solutions that align with business goals while delivering high-performance data processing.

The role emphasizes strong SQL, T-SQL, and data modeling expertise, with 100% remote work and compensation offered in USD or local currency.

Qualifications

• 5+ years of experience in Database Development, Data Engineering, or a related field.
• Proven expertise in SQL Server development and advanced T-SQL engineering.
• Strong hands-on experience building complex stored procedures, functions, views, and triggers.
• Solid understanding of query optimization, performance tuning, and execution plan analysis.

Responsibilities

• Mentor database developers and collaborate with key stakeholders to align technical solutions with business goals.
• Design and document high-performance relational data models and database schemas.
• Develop, test, and maintain complex database objects including stored procedures, functions, and triggers.
• Analyze query execution plans to diagnose performance bottlenecks and implement indexing and tuning strategies.
• Manage database transaction control, ensuring concurrency, data integrity, and proper isolation levels.

Skills

SQL Server

T-SQL

Stored procedures

Functions

Views

Triggers

Query optimization

Data modeling

English

Job description

BairesDev is seeking a Lead Data Engineer (SQL) to drive the design, optimization, and management of robust database systems for enterprise applications. You will mentor peers and guide data solutions that align with business goals while delivering high-performance data processing.

The role emphasizes strong SQL, T-SQL, and data modeling expertise, with 100% remote work and compensation offered in USD or local currency.