Big Data Lead
Mexico7h ago
Key details
- Location
- Mexico
- Work style
- Onsite
- Level
- Senior
- Function
- other
- Focus area
- other
- Posted
- 7h ago
Skills
data architecturedata modelingdata warehousingdbtjavascriptpythons3snowflakesqlstored procedures
About the role
Data Modeling & ELT: Design, develop, and optimize data models and ELT processes using Snowflake for efficient data processing and analytics. • Design and implement end-to-end ELT pipelines for loading data from various sources into Snowflake using Fivetran. • Implement data transformation logic using SQL and dbt ensuring the integrity, accuracy, and consistency of data. • Optimize data loads and transformations for scalability and performance using Snowflake’s micro-partitioning and clustering features. • Collaborate with data architects and business stakeholders to understand data requirements. • Create Streamlit apps for user enablement and maintenance tasks • Develop and maintain documentation for data processes and solutions. • Ensure data quality, governance, and security within the Snowflake environment. • Troubleshoot and resolve issues related to the Snowflake data warehouse. • Stay updated with the latest Snowflake features and best practices. • API Integrations: Work on integrating Snowflake with external APIs for seamless data extraction and transfer using Fivetran. Qualifications: • Proven experience as a Snowflake Developer with hands-on experience in Snowflake data warehousing solutions. • Data Architecture: Strong understanding of Snowflake platform features, including micro-partitioning, file processing from AWS S3, and data quality practices. • Expertise in writing and optimizing SQL queries, including complex queries, CTEs, and stored procedures (using JavaScript within Snowflake). • Solid experience in working with dbt. • Knowledge of Python for data engineering tasks and automation. • Familiarity with designing and managing data pipelines and ELT processes. • Excellent communication skills and the ability to collaborate effectively with cross-functional teams.
How well do you match this job?
Skills
Experience
Level
Title
Location
Salary
Freshness
Similarity
Free account needed to apply or save. It takes a minute, and we'll bring you right back to this job.