Senior Data Engineer

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.