Senior Data Engineer

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