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.