Senior Data Integration Engineer

EPAM Systems; Colombia; On-site; COP 291,290,000 - 388,387,000; Full time

Benefits offered by this job

Healthcare benefits

LinkedIn Learning access

Global career opportunities

Paid time off

Upskilling and certification courses

Job summary

EPAM Systems in Colombia is seeking a Senior Data Integration Engineer to build production data models and semantic layers that support business teams and autonomous AI agents via Snowflake Cortex and Snowflake Intelligence.

You will design dbt models, integrate Gong transcripts, Salesforce CRM data, and usage telemetry, and deliver enterprise data assets in an agile environment for analysts and product teams.

Qualifications

• 3+ years of analytics engineering, data engineering, or data architecture experience.
• Proficiency in SQL, including window functions, CTEs, complex joins, and analytical queries.
• 3+ years of production dbt experience with modular project structure, Jinja macros, tests, and incremental models.
• Practical experience with Snowflake, including virtual warehouses, Time Travel, and access control.
• Hands-on data modeling for B2B SaaS revenue and interactions (Salesforce CRM, Gong, etc.).
• Understanding of Kimball dimensional modeling and semantic layer design.
• Experience with Git workflows and CI test runs.
• English proficiency at B2 level or higher.

Responsibilities

• Build and maintain production data models in dbt and Snowflake.
• Combine structured records and unstructured data into account-level dimensions.
• Establish consistent modeling patterns, naming conventions, and metric definitions.
• Build and maintain an enterprise semantic layer to unify metric calculations.
• Prepare clean datasets for Snowflake Cortex, Snowflake Intelligence, and AI agents.
• Design feature tables and context stores for LLM agents.
• Manage metadata, RBAC, and data governance across sensitive data.
• Write automated tests and schema validations for data pipelines.
• Collaborate with Revenue Operations and governance teams on data lineage.
• Work in agile sprints and contribute to design reviews and standards.
• Deliver self-service data models and documentation for analysts.

Skills

Advanced SQL

dbt

Snowflake

Data modeling

Gong/CRM data integration

Python

Education

Bachelor's degree in Computer Science

Tools

Git

CI/CD

Job description

EPAM is a leading global provider of digital platform engineering and development services. We are committed to having a positive impact on our customers, our employees, and our communities. We embrace a dynamic and inclusive culture. Here you will collaborate with multi-national teams, contribute to a myriad of innovative projects that deliver the most creative and cutting-edge solutions, and have an opportunity to continuously learn and grow. No matter where you are located, you will join a dedicated, creative, and diverse community that will help you discover your fullest potential.

We are seeking a Senior Data Integration Engineer to build production data models and semantic layers that serve both business teams analyzing account health and pipeline velocity and autonomous AI agents running automated meeting preparation, account research, and relationship tracking through Snowflake Cortex and Snowflake Intelligence.

Responsibilities

• Build and maintain production data models in dbt and Snowflake that track account health, engagement velocity, and customer intent signals


• Combine structured records and unstructured interaction data (Gong call transcripts, emails, Salesforce CRM objects, and product usage telemetry) into clean account-level dimensions


• Establish consistent modeling patterns, naming conventions, and metric definitions across GTM datasets


• Build and maintain an enterprise semantic layer (such as the dbt Semantic Layer or MetricFlow) to eliminate conflicting metric calculations across business tools


• Prepare clean, context-rich datasets structured for retrieval, search, and reasoning within Snowflake Cortex, Snowflake Intelligence, and internal AI agents


• Design feature tables and context stores that power LLM agents for automated meeting prep, competitive intelligence, and account research


• Manage metadata and data enrichment patterns so AI agents correctly interpret account stages, customer sentiment, and relationship history


• Write automated tests, schema validations, and freshness monitors in dbt for both structured metrics and unstructured data transformations


• Maintain data governance, role-based access controls (RBAC), and audit trails across sensitive sales pipeline and customer interaction data


• Partner with Revenue Operations and governance teams to document data lineage and maintain clear dataset ownership


• Work within an agile sprint cadence, contributing to backlog planning, design reviews, and technical standards


• Deliver self-service data models and documentation that enable analysts and product teams to query data independently

Requirements

• 3+ years of commercial experience in analytics engineering, data engineering, or data architecture roles


• Proficiency in advanced SQL, including window functions, CTEs, complex joins, analytical queries, and execution plan optimization


• 3+ years of production dbt experience, including modular project structure, Jinja macros, custom tests, incremental models, and snapshots


• Practical experience with Snowflake, including virtual warehouse sizing, query profile analysis, clustering keys, Time Travel, zero-copy cloning, and access control


• Hands-on experience modeling B2B SaaS revenue and interaction data (Salesforce CRM, Gong, Marketo, or subscription billing data)


• Understanding of Kimball dimensional modeling (star schemas, slowly changing dimensions SCD 1/2/4, conformed dimensions) and semantic layer design


• Daily comfort with Git workflows, branching strategies, code reviews, and automated CI test runs


• Flexibility to use AI-assisted development tools (GitHub Copilot, Cursor, Claude Code) to speed up modeling work, test coverage, and documentation


• English proficiency at B2 level or higher

Nice to have

• Practical experience or working familiarity with Snowflake Cortex AI functions (Cortex Search, LLM functions, embeddings)


• Familiarity with vector embeddings, chunking strategies, and retrieval-augmented generation (RAG) for conversational text


• Working knowledge of Python for data manipulation (Pandas), API extraction, or pipeline automation


• Experience with metadata and lineage tools such as Alation, Collibra, DataHub, or dbt Docs


• Experience designing data models for self-service consumption in Tableau, Looker, or Power BI

We offer

• International projects with top brands


• Work with global teams of highly skilled, diverse peers


• Healthcare benefits


• Employee financial programs


• Paid time off and sick leave


• Upskilling, reskilling and certification courses


• Unlimited access to the LinkedIn Learning library and 22,000+ courses


• Global career opportunities


• Volunteer and community involvement opportunities


• EPAM Employee Groups


• Award-winning culture recognized by Glassdoor, Newsweek and LinkedIn

EPAM is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, sexual orientation, gender identity or expression, disability, protected veteran status, or any other characteristic protected by applicable law.