Senior Data Engineer
RemoteColombia or Costa Rica
Job Summary
Write, optimize, and maintain complex SQL across MySQL, Aurora PostgreSQL, and Databricks. Design, develop, and support data ingestion pipelines using API integrations, file ingestion, and CDC patterns. Build and optimize Databricks Lakehouse architectures following the Medallion model. Own stored procedures, views, and functions supporting production workflows. Perform database performance tuning, query optimization, and indexing strategies. Design dimensional models and star schemas for analytical workloads. Collaborate with software engineering teams on integrations and API data contracts. Implement ETL/ELT processes with automated testing, monitoring, and data quality controls. Contribute to data governance, security, and compliance requirements. This role requires 3+ years of experience and is open to remote candidates in Costa Rica, Peru, Colombia, and Bolivia.
Required 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
Desired Qualifications
- 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
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.