Senior SQL Software Engineer Medellin, Colombia, Sao Paolo, Brazil, Remote

Brightgrove Ltd.

Medellín

Remote

COP 120,000,000 - 180,000,000

Full time

4 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Interview process respects time
IT community
Knowledge sharing
Time for recovery

Job summary

Brightgrove Ltd. in Medellín, Colombia, is seeking a Senior SQL Developer to design, build, and optimise the Gold layer of a data platform using T-SQL, dimensional models, and ETL/ELT processes.

You will collaborate with a Data Modeler and international team to deliver high-performance data structures for BI and reporting, with a focus on data quality and scalable data pipelines. Strong SQL skills and experience with Azure DevOps and CI/CD are essential.

Qualifications

  • Strong T-SQL development skills, including complex queries, query optimisation, and performance tuning.
  • Good understanding of Kimball dimensional modelling (star schemas, fact and dimension tables, surrogate keys, slowly changing dimensions).
  • Experience with Data Warehousing, Lakehouse architecture, and Medallion Architecture (Bronze, Silver, Gold).
  • Experience with SQL-based ETL/ELT processes, incremental loading, change data capture, and data transformations.
  • Experience with Azure DevOps, Git, and CI/CD pipelines.
  • Knowledge of Delta/Parquet-based data structures.
  • Experience with data quality validation, reconciliation, and testing.
  • Ability to work independently, communicate effectively, and collaborate in Agile teams.

Responsibilities

  • Develop, optimise, and maintain complex T-SQL queries, stored procedures, and SQL transformations.
  • Implement dimensional data models, including fact and dimension tables, based on the Data Modeler's designs.
  • Build and optimise the curated Gold layer within a Medallion Architecture.
  • Develop and maintain ETL/ELT processes, including incremental loading, change data capture, and data transformations.
  • Translate source-to-target mappings into reliable SQL implementations.
  • Optimise query performance and data processing across large datasets.
  • Implement data quality checks, reconciliation, and automated testing.
  • Work with Azure DevOps, Git, and CI/CD pipelines.
  • Collaborate with the Data Modeler to identify and resolve data and performance issues.
  • Maintain technical documentation and support Agile delivery.

Skills

T-SQL
Dimensional modeling
Data Warehousing
Medallion Architecture
Data transformations
Data quality validation
Agile teamwork

Tools

Azure DevOps
Git
CI/CD pipelines
Delta/Parquet
Azure Data Factory
Spark SQL

Job description

Area

Data

Tech Level

Senior

About the Client

Our client is the largest specialist in geotechnical contracting globally.

Their diverse techniques, whether used individually or in combination, address various challenges across the construction industry. This includes industrial, commercial, and residential developments, as well as critical infrastructure projects like dams, tunnels, transportation, and water treatment facilities, alongside initiatives to tackle environmental issues.

The global expertise and extensive experience provide access to innovative solutions led by the brightest minds in the industry.

With approximately 10,000 employees and operations spanning five continents, we bring the resources, skill, and stability needed to respond swiftly, execute projects effectively, and maintain a strong focus on safety.

This project focuses on building and implementing dimensional data models for Keller's enterprise data platform.

The SQL Developer will work on developing and optimising the Gold layer of the data platform, using SQL transformations, data integration processes, and dimensional models designed by the Data Modeler.

The goal is to deliver reliable, reusable, and high-performance data structures that support business intelligence and reporting.

Your Team

You will work closely with the Data Modeler, other developers, and business stakeholders in an international team.

The Data Modeler will lead the design, while the SQL Developers will focus on implementation, optimisation, and data quality.

What's in it for you
  • Interview process that respects people and their time
  • Professional and open IT community
  • Internal meet-ups and resources for knowledge sharing
  • Time for recovery and relaxation
  • Bright online and offline events
  • Opportunity to become part of our internal volunteer community
Responsibilities
  • Develop, optimise, and maintain complex T-SQL queries, stored procedures, and SQL transformations.
  • Implement dimensional data models, including fact and dimension tables, based on the Data Modeler's designs.
  • Build and optimise the curated Gold layer within a Medallion Architecture.
  • Develop and maintain ETL/ELT processes, including incremental loading, change data capture, and data transformations.
  • Translate source-to-target mappings into reliable SQL implementations.
  • Optimise query performance and data processing across large datasets.
  • Implement data quality checks, reconciliation, and automated testing.
  • Work with Azure DevOps, Git, and CI/CD pipelines.
  • Collaborate with the Data Modeler to identify and resolve data and performance issues.
  • Maintain technical documentation and support Agile delivery.
Skills

Required:

  • Strong T-SQL development skills, including complex queries, query optimisation, and performance tuning.
  • Good understanding of Kimball dimensional modelling (star schemas, fact and dimension tables, surrogate keys, slowly changing dimensions).
  • Experience with Data Warehousing, Lakehouse architecture, and Medallion Architecture (Bronze, Silver, Gold).
  • Experience with SQL-based ETL/ELT processes, incremental loading, change data capture, and data transformations.
  • Experience with Azure DevOps, Git, and CI/CD pipelines.
  • Knowledge of Delta/Parquet-based data structures.
  • Experience with data quality validation, reconciliation, and testing.
  • Ability to work independently, communicate effectively, and collaborate in Agile teams.

Nice to have:

  • Microsoft Fabric (Lakehouse, Warehouse, SQL analytics endpoint, OneLake).
  • Azure Data Factory, Fabric Data Factory, and Azure SQL Database.
  • Spark SQL and PySpark.
  • Experience integrating data from Microsoft Dynamics 365 or similar ERP systems.
  • Understanding of Power BI semantic models and Direct Lake.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Mid Data Engineer
Mid Data Engineer

Lean Solutions Group • Medellín

On-site
COP 190,223,000 - 317,038,000
Platform Engineer (Database Sme)
Platform Engineer (Database Sme)

Sprocket International Group • Medellín

On-site
COP 90,000,000 - 120,000,000
Health insurance
Parking
Office near Milla de Oro
+1
Senior SQL Data Engineer – Gold Layer & Dimensional Models
Senior SQL Data Engineer – Gold Layer & Dimensional Models

Brightgrove Ltd. • Medellín

Remote
COP 120,000,000 - 180,000,000
Interview process respects time
IT community
Knowledge sharing
+1
Senior Data Warehouse and Integration Engineer
Senior Data Warehouse and Integration Engineer

Goods & Services • Colombia

On-site
COP 18,000,000 - 32,000,000
Data Engineer ID99039
Data Engineer ID99039

AgileEngine • Perímetro Urbano Barranquilla

Hybrid
COP 292,047,000 - 421,845,000
Professional growth
Competitive USD-based pay
Exciting projects with Fortune 500
+1
Data Engineer
Data Engineer

AgileEngine, LLC. • Colombia

Remote
COP 450,973,000 - 579,822,000
Data Engineer ID99039
Data Engineer ID99039

AgileEngine • Perímetro Urbano Manizales

Hybrid
COP 227,147,000 - 324,496,000
Professional growth
Competitive compensation
Exciting projects
+1
Data Engineer (Middle/Senior) ID32276
Data Engineer (Middle/Senior) ID32276

AgileEngine, LLC. • Bogotá

Hybrid
COP 194,194,000 - 388,387,000
Mentorship
Flextime
Education budgets
+1
Data Engineer Sr- Remote Latam – ID #00199
Data Engineer Sr- Remote Latam – ID #00199

Werben HR • Bogotá

Remote
COP 100,000,000 - 120,000,000
Data Engineer ID99039
Data Engineer ID99039

AgileEngine, LLC. • Cartagena de Indias

Hybrid
COP 292,047,000 - 421,845,000
Professional growth
Competitive compensation
Exciting projects
+1