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

BairesDev; Colombia; A distancia; COP 284.765.000 - 411.327.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

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

Descripción de la vacante

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.

Formación

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

Responsabilidades

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

Conocimientos

SQL Server

T-SQL

Stored procedures

Functions

Views

Triggers

Query optimization

Data modeling

English

Descripción del empleo

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.

Lead Data Engineer (SQL) at BairesDev

As a Lead Data Engineer (SQL), you will spearhead the development, optimization, and management of robust database systems to power our enterprise applications. You will act as a key technical guide, ensuring high-performance data processing while aligning database strategies with organizational needs.

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!