Senior Java Engineer (Data Engineering Focus)
We are seeking a highly skilled Senior Java Engineer with strong experience in data engineering workflows, particularly ETL processes, SQL modeling, and cloud-based data systems.
The ideal candidate will have hands-on experience with PostgreSQL, Snowflake, AWS, and containerized environments, as well as strong analytical and problem-solving capabilities.
This role involves building and optimizing data pipelines, integrating with internal and external data systems, and contributing to the design of scalable and efficient data architectures.
About First Factory
We are a software development company with over two decades of experience, boasting a dynamic team of 175+ professionals actively engaged in diverse projects across various industries. We invite you to join us on this journey as we continue to thrive and embrace fresh challenges.
Key Responsibilities
- Design and implement ETL processes for ingesting, transforming, and delivering data across systems.
- Expertise in SQL optimization for massive datasets.
- Work with Snowflake and PostgreSQL databases to design schemas, write optimized queries, and support data ops.
- Develop, maintain, and optimize Java-based applications that interact with data pipelines and services.
- Build and optimize SQL models using DBT.
- Manage data storage and workflows using AWS S3.
- Deploy, configure, and maintain containerized applications in Kubernetes (AKS).
- Collaborate with Data Engineers and Architects to ensure high-quality, scalable, and efficient data solutions.
- Troubleshoot and optimize data systems for performance, scalability, and reliability.
Requirements
- 7+ years of experience in Java development.
- Experience working with high-volume data processing and ETL pipelines.
- Strong SQL skills, including query optimization, indexing, and analytical queries.
- Extensive hands-on experience with Snowflake.
- Experience using DBT for data modeling, transformations, and testing.
- Solid knowledge of AWS S3 and cloud-based data workflows.
- Experience with Kubernetes (AKS preferred) for deployment and orchestration.
- Strong understanding of data structures, algorithms, and software engineering best practices.
Nice to have
- Strong understanding of AdTech concepts (e.g., DSPs, pixels, impressions) or the ability to learn them quickly.
- Familiarity with geospatial operations and tools (e.g., H3, ST_WITHIN).
- Department
- Software Engineering
- Role
- Senior Java Engineer (Data Engineering Focus)
- Locations
- Heredia
- Remote status
- Hybrid
About First Factory
For over 25 years, First Factory has been a place where collaborative excellence meets modern technologies. We’re a strong team building exceptional software solutions from Costa Rica and LATAM for primarily US-based clients. With industry-low turnover, top eNPS globally, and 5 consecutive Inc. 5000 awards, we foster an environment where talented engineers thrive on challenging projects using modern tech stacks.