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