Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Brightgrove Ltd.

New

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

Posted Updated

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.

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. 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. Interview process respects time IT community Knowledge sharing Time for recovery

Skills

What Senior Software Engineering jobs ask for — and how much of it you have →
Apply

See also

Software Engineering jobs by country — openings, pay and top skills →