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 recoverySkills
Sign in to read and join the discussion.