Senior Data Engineer
- Role
- Data Engineering
- Experience
- Senior
- Employment
- Full-time
Open to CR, PE, CO, BO only. Set where you work from to check your eligibility.
No BS summary
Senior Data Engineer with 3+ years of production-grade SQL and strong expertise in at least two relational databases (MySQL, PostgreSQL, SQL Server, Oracle). Must have 2+ years building data pipelines with Python or PySpark, and experience with dimensional modeling. Remote role based in Costa Rica, Peru, Colombia, or Bolivia.
Core skills
Required skills
Optional skills
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.
What you'll do
- 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.
What they require
- 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.
At Coforge, we hire professionals solely based on their skills and qualifications, and we do not discriminate based on age, disability, religion, gender, sexual orientation, socioeconomic status, or nationality.
What people say about this company
3.6/ 5