Key Skills: Data Modelling, Dimensional Modelling, Snowflake, AWS, SQL, Power BI, ETL/ELT, Star Schema, Data Architecture, DBT
Experience: 7–10+ years of experience.
Location: LATAM (open to all countries in the region)
Work Model: Remote for legal residents in Latam
• Design and maintain enterprise data models (conceptual, logical, and physical models)
• Develop dimensional data models (facts, dimensions, star schemas) optimized for Snowflake and Power BI consumption
• Define data entities, relationships, hierarchies, grain, naming standards, and reusable structures
• Collaborate closely with Business Analysts, Data Engineers, Analytics Engineers, and QA/SDET teams to ensure alignment across data solutions
• Ensure consistency of core business metrics and establish a single source of truth
• Align business definitions with scalable data structures to support reliable analytics and reporting
• Support the consolidation of data into a centralized cloud-native platform (Snowflake on AWS)
• Design data models that enable decision-making across underwriting, claims, finance, and operations
• Ensure data models are optimized for performance, scalability, and usability
• 7–10+ years of experience in Data Modelling and Data Warehousing environments
• Strong expertise in data modelling (DW/DM concepts) and dimensional modelling (star schema, facts, dimensions)
• Advanced proficiency in SQL
• Hands-on experience with Snowflake
• Experience with cloud data platforms (AWS or Azure)
• Experience working with BI tools such as Power BI or similar
• Strong understanding of ETL/ELT pipelines and end-to-end data flows
• Knowledge of data performance optimization and scalability best practices
• Ability to translate business concepts into scalable and reusable data models
• Strong focus on data consistency, structure, and usability
• Experience working in cross-functional data teams
• Advanced or fluent English communication skills (mandatory)
• Experience in the insurance domain (claims, policies, underwriting, risk)
• Hands-on experience with DBT (Data Build Tool)
• Familiarity with modern cloud-native data architectures
• Experience supporting enterprise data transformation initiatives
Skills Required
- 7-10+ years of experience in Data Modelling and Data Warehousing environments
- Strong expertise in data modelling (DW/DM concepts) and dimensional modelling (star schema, facts, dimensions)
- Advanced proficiency in SQL
- Hands-on experience with Snowflake
- Experience with cloud data platforms (AWS or Azure)
- Experience working with BI tools such as Power BI or similar
- Strong understanding of ETL/ELT pipelines and end-to-end data flows
- Knowledge of data performance optimization and scalability best practices
- Ability to translate business concepts into scalable and reusable data models
- Strong focus on data consistency, structure, and usability
- Experience working in cross-functional data teams
- Advanced or fluent English communication skills (mandatory)
- Experience in the insurance domain (claims, policies, underwriting, risk)
- Hands-on experience with DBT (Data Build Tool)
- Familiarity with modern cloud-native data architectures
- Experience supporting enterprise data transformation initiatives
Encora Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Encora and has not been reviewed or approved by Encora.
-
Healthcare Strength — Health coverage is described as employer-provided in multiple locations, with private plans and family coverage highlighted in Spain and Mexico. Medical insurance quality is presented as a recurring bright spot alongside standard coverage.
-
Leave & Time Off Breadth — Time off includes paid holidays and PTO, with regional materials indicating additional leave provisions in certain countries. Leave is generally portrayed as conventional to generous depending on location.
-
Flexible Benefits — Work-from-home flexibility is frequently highlighted as a plus, though it varies by role and client needs. Remote and hybrid options are positioned as part of the overall package.
Encora Insights
What We Do
Headquartered in Santa Clara, California, and backed by renowned private equity firms Advent International and Warburg Pincus, Encora is the preferred technology modernization and innovation partner to some of the world’s leading enterprise companies. It provides award-winning digital engineering services including Product Engineering & Development, Cloud Services, Quality Engineering, DevSecOps, Data & Analytics, Digital Experience, Cybersecurity, and AI & LLM Engineering. Encora's deep cluster vertical capabilities extend across diverse industries, including HiTech, Healthcare & Life Sciences, Retail & CPG, Energy & Utilities, Banking Financial Services & Insurance, Travel, Hospitality & Logistics, Telecom & Media, Automotive, and other specialized industries. With over 9,000 associates in 47+ offices and delivery centers across the U.S., Canada, Latin America, Europe, India, and Southeast Asia, Encora delivers nearshore agility to clients anywhere in the world, coupled with expertise at scale in India. Encora’s Cloud-first, Data-first, AI-first approach enables clients to create differentiated enterprise value through technology
