20 days ago
San José, Costa RicaMid Level
Responsibilities
- Design, build, and operate scalable ETL/ELT pipelines ingesting AI Assistant, DevOps, API, database, event, and log data into Snowflake.
- Build and maintain dbt data models, tests, and documentation while designing and optimizing Snowflake staging, core, and mart layers.
- Design and manage MongoDB collections, schemas, indexes, aggregation pipelines, and change streams for analytics integration.
- Implement data observability, quality checks, lineage, security controls, monitoring, CI/CD, and production operations.
- Partner with analytics and product teams to deliver reliable data products.
- Support incident triage, root cause analysis, runbook creation, and translation of business and delivery requirements into data products, analytics, and dashboards.
Requirements
- Hands-on experience designing and developing scalable ETL/ELT data pipelines.
- Strong Snowflake experience, including data modeling, dimensional and star schemas, query tuning, and performance optimization.
- Hands-on experience with dbt for data modeling, testing, and documentation.
- Experience with MongoDB collections, schemas, indexes, aggregation pipelines, and change streams.
- Experience integrating APIs, databases, event sources, logs, and DevOps platforms.
- Experience with Power BI, Tableau, or comparable data visualization tools or libraries.
- Knowledge of data observability, quality validation, lineage tracking, monitoring, and alerting.
- Experience with CI/CD, Git, infrastructure as code, and Dev/QA/Prod environments.
- Knowledge of data security practices including RBAC, masking, encryption, and audit controls.
- Experience using generative AI coding assistants such as GitHub Copilot, Codex, Claude Code, or Cursor, including validating AI-generated outputs through rigorous testing.
- Preferred experience with data generated by AI development assistants such as Cursor, Codex, Claude, Copilot, or Devin.
- Preferred familiarity with Jenkins, SonarQube, Git, and Jira, plus experience supporting data-platform incidents and creating runbooks.
Benefits
- Hybrid work arrangement in San José, Costa Rica, with two to three days per week on-site.
About Encora
Encora provides software and digital product engineering services for technology companies and enterprises, including cloud-native development, data engineering, and QA. It operates a global delivery model and supports outsourced product development and managed engineering teams. Headquartered in Santa Clara, California, Encora is privately held and was acquired by Coforge; it previously raised $200 million in private equity funding in 2019.