We are seeking a Data Engineer with strong expertise in dimensional modeling, data pipeline development, and cloud-based data warehousing, with a particular emphasis on Snowflake. The ideal candidate will be instrumental in designing and maintaining robust data solutions that support business intelligence, advanced analytics, and AI initiatives across the LATAM region.
Key Responsibilities
Analyze business processes to identify and define necessary dimensions and facts.
Determine appropriate Slowly Changing Dimensions (SCD) levels for each dimension.
Design and implement data models (star and snowflake schemas) in Snowflake.
Develop and maintain scalable ETL/ELT pipelines integrating data from various sources.
Define data granularity levels to meet analytical requirements.
Schedule and manage data refresh processes to ensure data accuracy and timeliness.
Collaborate with BI and data science teams to support reporting and analytical needs.
Ensure data quality, integrity, and governance across all data assets.
Required Qualifications
Bachelor's degree in Computer Science, Information Systems, or a related field.
3+ years of experience in data engineering or a similar role.
Proficiency in SQL and experience with data modeling techniques.
Hands-on experience with Snowflake, including performance tuning and optimization.
Familiarity with ETL/ELT tools and frameworks.
Experience with cloud platforms such as AWS, Azure, or GCP.
Strong understanding of data warehousing concepts and best practices.
Preferred Skills
Experience with data orchestration tools like Apache Airflow or Azure Data Factory.
Proficiency in programming languages such as Python or Scala.
Familiarity with data lake architectures and datalake house concepts.
Knowledge of data governance and compliance standards.
Experience with BI tools, with a strong emphasis on Tableau.
Language Requirements
Fluent in Spanish (mandatory).
Proficient in English (mandatory).
Portuguese proficiency is a plus.
Soft Skills
Strong analytical and problem-solving abilities.
Excellent communication skills, both verbal and written.
Ability to work collaboratively in a cross-functional team environment.
Proactive and self-motivated with a commitment to continuous learning.