Job Title: Senior Data Engineer
Key Skills: SQL, Databricks, PySpark, Data Engineering, PostgreSQL, AWS
Experience: 3+ YOE.
Location: Costa Rica, Peru, Colombia, and Bolivia.
Mode: Remote.
We at Coforge are hiring Senior Data Engineer (#22328) with the following skill set.
Key Responsibilities
· Write, optimize, and maintain complex SQL across MySQL, Aurora PostgreSQL, SQL Server, and Databricks (Spark SQL).
· Design, develop, and support data ingestion pipelines using API integrations, file ingestion, CDC patterns, and modern data engineering practices.
· Build and optimize Databricks Lakehouse architectures following the Medallion model (Bronze, Silver, Gold).
· Own and enhance stored procedures, views, and functions supporting production business workflows and reporting processes.
· Perform database performance tuning, query optimization, execution plan analysis, indexing, and partitioning strategies.
· Design and maintain dimensional models and star schemas for analytical workloads.
· Collaborate closely with software engineering teams on data access patterns, integrations, migrations, and API data contracts.
· Support data migration initiatives, data validation, reconciliation processes, and production go-live activities.
· Implement and maintain ETL/ELT processes with automated testing, monitoring, alerting, and data quality controls.
· Contribute to data governance, security, lineage tracking, and compliance requirements across enterprise data platforms.
Required Skills & Qualifications
· Bachelor’s degree in Computer Science, Information Systems, or a related field.
· 3+ years of hands-on experience writing production-grade SQL.
· Strong expertise with at least two relational databases such as MySQL, PostgreSQL, SQL Server, or Oracle.
· Advanced knowledge of CTEs, window functions, recursive queries, query plan analysis, and stored procedure development.
· 2+ years of experience building data processing pipelines using Python or PySpark.
· Experience designing and maintaining dimensional models and star schemas.
· Solid understanding of software engineering fundamentals including Git, CI/CD pipelines, code reviews, and Agile/Scrum methodologies.
· Experience working with distributed and offshore teams across multiple time zones.
· Strong analytical, troubleshooting, and problem-solving skills.
Preferred Skills
· Experience with Databricks, Lakehouse architecture, and Medallion patterns (Bronze/Silver/Gold).
· Experience with AWS services such as Aurora, Glue, S3, Lambda, and EventBridge.
· Background in Financial Services, Loan Servicing, or FinTech environments.
· Familiarity with event-driven architectures, CDC patterns, Kafka, or MSK.
· Experience with data governance, security controls, and handling PII or sensitive financial data.
· Experience with OutSystems or other low-code platforms.
· Experience using AI-assisted development tools such as Claude Code or similar solutions.
· Exposure to Databricks Mosaic AI or other LLM-powered data technologies.
Posted On: 14-08-2026
At Coforge, we hire professionals based solely on their skills and do not discriminate based on age, disability, religion, gender, sexual orientation, socioeconomic status, or nationality.
Skills Required
- Bachelor's degree in Computer Science, Information Systems, or related field
- 3+ years hands-on experience writing production-grade SQL
- Strong expertise with at least two relational databases (MySQL, PostgreSQL, SQL Server, Oracle)
- Advanced knowledge of CTEs, window functions, recursive queries, query plan analysis, and stored procedure development
- 2+ years building data processing pipelines using Python or PySpark
- Experience designing and maintaining dimensional models and star schemas
- Solid understanding of software engineering fundamentals including Git, CI/CD, code reviews, and Agile/Scrum
- Experience working with distributed and offshore teams across multiple time zones
- Strong analytical, troubleshooting, and problem-solving skills
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
