Senior SQL Data Engineer – Gold Layer & Dimensional Models

Brightgrove Ltd.

Medellín

Remote

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

Full time

4 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

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

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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

Brightgrove Ltd. • Medellín

Remote
COP 120,000,000 - 180,000,000
Interview process respects time
IT community
Knowledge sharing
+1
Senior Data Engineer — ETL & Data Warehouse (Hybrid)
Senior Data Engineer — ETL & Data Warehouse (Hybrid)

Blyce • Medellín

Hybrid
COP 292,047,000 - 421,845,000
Hybrid work model (2 days in office, 3
Company laptop
Health insurance
+2
Mid Data Engineer: ELT Pipelines & Data Modeling
Mid Data Engineer: ELT Pipelines & Data Modeling

Lean Solutions Group • Medellín

On-site
COP 190,223,000 - 317,038,000
Senior SQL DB Administrator - Enterprise Data Ops
Senior SQL DB Administrator - Enterprise Data Ops

Lean Solutions Group • Medellín

On-site
COP 120,000,000 - 180,000,000
Medellín-based SQL and Power BI Reporting Analyst
Medellín-based SQL and Power BI Reporting Analyst

Lean Solutions Group • Medellín

Hybrid
COP 60,000,000 - 90,000,000
Mid Data Engineer
Mid Data Engineer

Lean Solutions Group • Medellín

On-site
COP 190,223,000 - 317,038,000
Senior Data Warehouse Engineer - Snowflake & dbt
Senior Data Warehouse Engineer - Snowflake & dbt

SoftServe Inc. • Colombia

On-site
COP 90,000,000 - 150,000,000
Data Engineer – dbt, Snowflake & Production Pipelines
Data Engineer – dbt, Snowflake & Production Pipelines

AgileEngine, LLC. • Medellín

Hybrid
COP 356,946,000 - 486,744,000
Professional growth
Competitive compensation
Exciting projects
+1
Bi Developer / Data Analyst - Bilingual
Bi Developer / Data Analyst - Bilingual

InterScripts, Inc. • Medellín

On-site
COP 60,000,000 - 100,000,000
Senior Data Engineer, Colombia
Senior Data Engineer, Colombia

CI&T • Colombia

On-site
COP 111,600,000 - 167,400,000
Maternity and Parental leaves
Mobile services subsidy
Sick pay-Life insurance
+3