Encora logo

Senior Data Engineer

Encora

Bolivia, Colombia, Costa Rica, Peru Full-time

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.

Apply on company site

You will be redirected to the company website to complete your application.

Browse similar remote roles

Similar jobs

Please confirm

Are you sure you want to continue?