Match score not available

Senior Analytics Engineer

Remote:

Full Remote

Experience:

Senior (5-10 years)

Work from:

Colombia

Offer summary

Qualifications:

Advanced SQL expertise with performance optimization, Hands-on experience with DBT and version control using Git, Strong understanding of data modeling methodologies, Proficiency with data formats like CSV, JSON, and Parquet.

Key responsabilities:

Develop and optimize datasets using dimensional modeling
Identify and resolve data quality issues through analysis

Lean Tech Information Technology & Services SME https://www.leangroup.com/

501 - 1000 Employees

See all jobs

Job description

Description

Company Overview:

Lean Tech is a rapidly expanding organization situated in Medellín, Colombia. We pride ourselves on possessing one of the most influential networks within software development and IT services for the entertainment, financial, and logistics sectors. Our corporate projections offer many opportunities for professionals to elevate their careers and experience substantial growth. Joining our team means engaging with expansive engineering teams across Latin America and the United States, contributing to cutting-edge developments in multiple industries.

We are seeking an Analytics Engineer to design reliable datasets using SQL, DBT, and data modeling, ensuring accuracy and usability for analytics and applications.

Position Title: Senior Analytics Engineer

Location: Remote - Colombia

What you will be doing:

We are looking for an Analytics Engineer to design, develop, and maintain high-quality datasets that support applications, data scientists, and power users. This role requires expertise in SQL, data modeling, and DBT, focusing on data transformation and quality assurance. You will collaborate with teams to ensure the usability and accuracy of datasets, contributing to a robust data ecosystem. This position is not centered around data visualization, machine learning, or data ingestion but rather on creating reliable and accessible datasets. Your responsibilities include:

Develop and optimize datasets using dimensional modeling (Kimball, Star Schema).
Create, chain, document, and test SQL models in DBT.
Perform calculations and derive new fields to enhance data usability.
Write and optimize advanced SQL queries, including window functions and performance tuning.
Investigate and resolve data quality issues through record analysis and reporting.
Work closely with downstream teams to address data requirements and enable advanced transformations.
Use Git for code management and version control.
Add unit tests to data models to ensure accuracy and reliability.
Participate in peer code reviews to maintain coding standards.
Work with data in formats such as CSV, JSON, and Parquet.

Requirements & Qualifications

To excel in this role, you should possess:

SQL Proficiency: Advanced SQL expertise, including window calculations, performance optimization, and familiarity with Snowflake functions.
DBT Proficiency: Hands-on experience with DBT, including advanced workflows and testing.
Data Modeling: Strong understanding of Kimball and Star Schema design methodologies.
Version Control: Experience using Git for collaboration and code versioning.
Data Formats: Proficiency with CSV, JSON, and Parquet file formats.
Error Investigation: Ability to identify and resolve data quality issues.
Code Quality: Experience in unit testing and participating in peer code reviews.

Nice-to-Have Skills:

Familiarity with Snowflake tools and features.
Basic Python knowledge for enhancing DBT workflows or advanced transformations.
Experience with knowledge graphs or data frame libraries (e.g., Pandas, Polars, Spark).
Understanding of cloud storage solutions such as S3 or Azure Blob Storage.

Why you will love Lean Tech:

Join a powerful tech workforce and help us change the world through technology
Professional development opportunities with international customers
Collaborative work environment
Career path and mentorship programs that will lead to new levels.

Join Lean Tech and contribute to shaping the data landscape within a dynamic and growing organization. Your skills will be honed, and your contributions will be vital to our continued success. Lean Tech is an equal-opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.