Lead Data Engineer (SQL) - Remote Work | REF#306492

BairesDev; Sucre; Remote; COP 379,687,000 - 506,249,000; Full time

Benefits offered by this job

Remote work - 100%

USD compensation available

Home office hardware & software setup

Flexible hours

Parental leave & vacation

Job summary

BairesDev is seeking a Lead Data Engineer (SQL) to mentor teams and design high-performance relational data models. You will develop, test, and maintain complex database objects, optimize queries, and ensure data integrity across systems.

This is a 100% remote role with flexible hours and global collaboration. Ideal candidates have 5+ years in database development or data engineering, with advanced T-SQL skills and a strong grounding in data modeling.

Qualifications

• 5+ years of experience in Database Development or Data Engineering.
• Proven expertise in SQL Server development and advanced T-SQL engineering.
• Strong hands-on experience building complex stored procedures, views, and triggers.

Responsibilities

• Mentor database developers and align technical solutions with business goals.
• Design and document high-performance relational data models and schemas.
• Develop, test, and maintain complex database objects including procedures, functions, and triggers.
• Analyze query execution plans to diagnose bottlenecks and tune performance.
• Manage database transactions, ensuring data integrity and proper isolation.

Skills

SQL Server development

T-SQL

Stored procedures & functions

Query optimization

Relational data modeling

English proficiency

Job description

Lead Data Engineer (SQL) at BairesDev

At BairesDev®, we've been leading the way in technology projects for over 15 years. We deliver cutting-edge solutions to giants like Google and the most innovative startups in Silicon Valley. Our diverse 4,000+ team, composed of the world's Top 1% of tech talent, works remotely on roles that drive significant impact worldwide. When you apply for this position, you're taking the first step in a process that goes beyond the ordinary. We aim to align your passions and skills with our vacancies, setting you on a path to exceptional career development and success.

What You’ll Do

• 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.

What We Are Looking For

• 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.
• Experience with relational data modeling, normalization, and transaction management.
• Advanced proficiency in English.

How we do make your work (and your life) easier:

• 100% remote work (from anywhere).
• Excellent compensation in USD or your local currency if preferred
• Hardware and software setup for you to work from home.
• Flexible hours: create your own schedule.
• Paid parental leaves, vacations, and national holidays.
• Innovative and multicultural work environment: collaborate and learn from the global Top 1% of talent.
• Supportive environment with mentorship, promotions, skill development, and diverse growth opportunities.

Join a global team where your unique talents can truly thrive and make a significant impact!