Senior Analytics Engineer – Kimball

Yesterday

Apply Now

Receive Emails with Similar Jobs

NOUS LATAM

WebsiteLinkedInAll Job Openings

HR Tech • B2B • AI

NOUS LATAM is a people management platform designed to build engaged, high-performing teams. It provides companies with tools to hire tech professionals efficiently by vetting talent and ensuring perfect matches swiftly. With a focus on aligning individual and team success to organizational goals, NOUS LATAM enhances manager-employee relationships, helps employees develop through marketplaces of opportunity, and offers support during transitions, such as layoffs. Its platform utilizes AI to streamline the hiring process and foster professional connections among talent in the tech industry.

2 - 10 employees

Founded 2022

👥 HR Tech

🤝 B2B

📋 Description

• Design and build dimensional models and Data Warehouse / Data Mart architectures following best practices. • Develop robust analytical models in DBT, including: • Macros • Snapshots • Incremental models • SCD (Type 1 and 2) • Dimensions and facts according to Kimball methodology • Work with multidimensional modeling and relational (ER) modeling. • Apply concepts from the Kimball approach, selecting the ideal strategy for each domain. • Translate business requirements into clear, scalable, and maintainable data models. • Build surrogate keys, historized dimensions, and Data Warehouse versioning structures. • Analyze complex queries, extract business concepts, and restructure models when necessary. • Implement transformation pipelines in DBT with a focus on organization, reuse, and governance. • Document business rules, model structures, and relationships clearly and accessibly. • Ensure quality and consistency through tests, validations, and DBT best practices.

🎯 Requirements

• Proven experience building Data Warehouses (ideally from scratch). • Deep expertise in multidimensional modeling and relational (ER) modeling. • Solid knowledge of Kimball methodologies. • Strong hands-on experience with DBT and its core concepts: • Materializations • Macros • Snapshots • Tests • Documentation • Lineage • Advanced SQL, with ability to analyze and optimize complex queries. • Experience with BigQuery, Snowflake, Redshift, or Databricks. • Ability to translate business rules into structured data models. • Intermediate knowledge of Python for simple automations. • Experience with Data Warehouse versioning (SCD Type 1/2 and surrogate keys).