Senior Data Engineer

APPLY is building modern data foundations for customer engagement, and you will help shape how data moves from source systems into cloud warehouses and activation pipelines. This hybrid/remote-friendly role supports an inclusive, safe environment with AI and strategic upskilling, agentic delivery practices, and a generous vacation policy alongside flexible work arrangements.

Responsibilities

• Partner with internal teams, vendors, clients, and stakeholders to define data requirements and the technology stack for projects.
• Audit source systems across CRM and marketing platforms (including Salesforce and Sailthru) and define migration guidelines for what to migrate, the target structure, and execution order for internal or third-party delivery.
• Translate business needs into technical specifications covering data streams, integrations, transformations, and the data warehouse.
• Design and build transformation layers in dbt on Snowflake, including identity resolution, the semantic layer, and consumption or reporting layers.
• Build and maintain pipelines to activate data in customer engagement platforms such as Braze.
• Run discovery audits of digital products (apps, games, web) and deliver data foundation recommendations.
• Work within git-based workflows using code review, dbt tests, and existing CI/CD practices for warehouse objects.
• Define a data architecture framework with standards and principles, including modelling, metadata, security, and reference data; analyze and optimize models for performance and cost.
• Create a plan to populate new solutions with current and historical data.
• Implement data security and access controls to meet company policies and regulations.
• Document data sources, ELT/ETL processes, data dictionaries, metadata, and maintain data lineage and data flow documentation.
• Research, evaluate, and recommend new technologies while developing best practices for data management, security, and privacy.

Requirements

• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• At least 5 years of experience in data engineering or a related field.
• Expert-level SQL with strong experience in ELT/ETL and cloud data warehousing, including hands-on Snowflake experience.
• Strong hands-on experience with dbt (modelling, tests, documentation, macros) and git-based workflows (branching, code review, CI/CD).
• Proven data modelling experience, including dimensional and semantic layers, and analysis techniques.
• Experience with customer data modelling and identity resolution across CRM, marketing, and product sources.
• Experience integrating with customer engagement platforms such as Braze, Salesforce Marketing Cloud, and Sailthru or similar.
• Experience planning data migrations (source audit, mapping, target structure definition, historical backfill).
• Working knowledge of Python for data tooling and automation.
• Working knowledge of at least one major cloud platform: AWS or GCP.
• Ability to troubleshoot data issues and develop effective solutions.
• Comfort producing written guidelines and recommendations for client and third-party teams.
• Understanding of data privacy and security best practices.
• Excellent communication and problem-solving skills, with fluent English.

Location & Work Setup

• APPLY is hybrid/remote-friendly.
• The preferred candidate should be based in Latin America, preferably working hours aligned to PT (Pacific Time) or ET (Eastern Timezone).
• Candidates in Santiago, Chile can work out of the Santiago office as remote/hybrid employees.
• Candidates outside Santiago, Chile will be fully remote.

Technology Stack

Snowflake, dbt, ELT, ETL, SQL, git, CI/CD, Python, AWS, GCP, Salesforce, Sailthru, Braze, Salesforce Marketing Cloud, Spark/PySpark, Docker, Kubernetes.

Nice to Have

• Snowflake (SnowPro) or dbt certification; cloud certifications welcome.
• Spark/PySpark.
• Docker and Kubernetes.
• Experience with consumer or digital-product data (apps, games, subscriptions).

Benefits

• Agentic Delivery.
• An inclusive and safe environment.
• AI & Strategic Upskilling.
• Generous vacation policy.
• Flexible work arrangements.