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

BairesDev; Colombia; Remote; COP 284.783.000 - 379.711.000; Vollzeit

Benefits dieser Stelle

100% remote

Flexible hours

Hardware provided

Competitive USD pay

Zusammenfassung

BairesDev, a global technology company, seeks a Lead Data Engineer (SQL) to lead design, optimization, and management of enterprise databases. You will mentor developers and align database strategies with business goals on a 100% remote, globally distributed team.

The role emphasizes SQL Server, T-SQL, and advanced data modeling, with strong focus on performance, concurrency, and data integrity. Attractive USD or local currency pay and flexible work options are offered.

Qualifikationen

• 5+ years of experience in Database Development, Data Engineering, or 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.

Aufgaben

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

Tools

SQL Server

T-SQL

Stored procedures

Functions

Views

Triggers

Query optimization

Performance tuning

Execution plans

Data modeling

Jobbeschreibung

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!