8 days ago
Remote, Peru +4 moreSenior
Responsibilities
- Design and implement ingestion and transformation pipelines from databases, APIs, and files into Snowflake.
- Build full and incremental loads that preserve source data and extraction metadata while supporting recovery and reprocessing without loss or duplication.
- Develop dimensional models, historization, curated data layers, dbt models, automated tests, and documentation.
- Investigate data sources, reconcile figures against business reports, validate metrics, and resolve discrepancies with stakeholders.
- Implement monitoring, alerts, logs, and controls that prevent incomplete information from being published.
- Configure and validate Snowflake roles, privileges, row-level restrictions, masking, and other access policies.
- Diagnose performance issues and control Snowflake credit consumption.
- Prepare semantic models, metrics, and views for natural-language queries and AI agents.
- Organize incremental deliveries, communicate risks, adjust scope, document the solution, and transfer operational and recovery procedures.
Requirements
- At least five years of data engineering experience, including direct construction and operation of data warehouses.
- At least two years of Snowflake production experience.
- Experience taking solutions from design and implementation through deployment, monitoring, and maintenance.
- Advanced SQL, practical Snowflake ingestion and warehouse administration, dimensional modeling, access controls, and cost optimization experience.
- Production dbt experience covering model organization, dependencies, incremental materializations, testing, and documentation.
- Python experience for integration, automation, and data processing.
- Experience integrating authenticated, paginated APIs with rate limits, retries, and error handling.
- Experience with relational databases, preferably SQL Server.
- Experience orchestrating pipelines with Airflow, Step Functions, Snowflake-native tools, or equivalent technologies.
- Git version control and testing and deployment practices across environments.
- Ability to clarify requirements, define metrics, validate results with business users, and organize staged deliveries.
- Practical use of AI tools for development, research, testing, or documentation with human review before production.
- Preferred experience includes Snowflake Cortex Analyst, Cortex Search, Cortex Agents, Snowflake Intelligence, CoCo, semantic models, Text-to-SQL, verified queries, agent evaluation, Openflow, Dynamic Tables, Snowpark, Streamlit, SAP, SAP ASE/Sybase, ODBC, AWS, infrastructure as code, CI/CD automation, RAG, and SnowPro certifications.
Benefits
- Fully remote/home-office work for candidates in Mexico and Latin America.
- Full-time work with a Monday-to-Friday schedule and hours adjusted to the assigned project team.
- Birthday day off.
- Major medical insurance and life insurance for Mexico-based employees.
- Access to courses and certifications.
- Virtual integration events and interest groups.
- English classes.
- Integration with global brands and disruptive startups.
- Great Place to Work certified employer.
About DaCodes
DaCodes is a software consultancy that designs and builds custom web and mobile applications, CRMs, and enterprise systems for businesses. The company operates on a project-based services model, providing product management, design, engineering, and ongoing support from a distributed team. Founded in 2014 and headquartered in Houston, Texas, it is privately held and serves clients across varied industries.