Data Engineer

Summary

• As a Data Engineer at Gainwell, you can contribute your skills as we harness the power of technology to help our clients improve the health and well-being of the members they serve — a community’s most vulnerable. Connect your passion with purpose, teaming with people who thrive on finding innovative solutions to some of healthcare’s biggest challenges. Here are the details on this position.

Your role in our mission

• Lead the end-to-end design of pipelines and storage solutions supporting applications and reporting.
• Build and optimize ETL/ELT processes for ingesting and transforming applications.
• Architect and maintain high performance and PostgreSQL databases integrated with OutSystems front-end applications and AWS backend services.
• Collaborate closely with OutSystems developers, architects, business analysts, and SMEs to deliver solutions aligned with the requirements.
• Implement and monitor quality, lineage, and validation to ensure accuracy in reporting.
• Integrate with AWS services such as S3, RDS, Glue, Lambda, Step Functions, and manage pipelines and workflows.
• Provide technical leadership, mentor junior data engineers, and define best practices for internal process, performance tuning, and governance.

What we're looking for

• Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Engineering, or a related field.
• 5+ years of data engineering experience, including leading complex projects.
• 3+ years of hands-on experience with AWS services (e.g., RDS/PostgreSQL, Glue, S3, Lambda, CloudWatch).
• Deep experience designing and optimizing PostgreSQL schemas and queries.
• Experience integrating OutSystems applications with external databases and APIs.
• Solid understanding of ETL frameworks, and orchestration tools (e.g., Airflow, Step Functions).
• Strong communication skills with the ability to translate business requirements into scalable solutions.
• Experience building dashboards to support operational metrices.
• Familiarity with OutSystems service components and integration patterns.
• AWS and/or OutSystems certifications.

What you should expect in this role

• Work Environment

  • Remote/ Hybrid