Software Engineer (ETL / Data Engineer)

Rx Savings Solutions offers an innovative, patented software system that educates and empowers consumers to make the best healthcare choices at the lowest cost. Founded and operated by a team of pharmacists and software engineers, we support a collaborative, cost-saving solution for purchasing prescription drugs.
We currently have an opportunity for a Software Engineer (ETL/Data) to join our growing Solution Implementation & Support data engineering team!  This role will assist in planning, designing, and documenting technical requirements for data flows between disparate operational systems and our data warehouse. The ideal candidate will have ETL tool experience (i.e. Talend, Informatica, SSIS or Datastage), experience with SQL, and general purpose programming languages such as Python or Java for data engineering/ingestion work. This individual will assist in end-to-end development of the ETL processes, data analytics, review business requirement documents and execute object and data models.
Check out what our CTO shares about the personal growth opportunities and impactful work as an Engineer on our team:https://www.youtube.com/watch?v=52P-A-pZYw4
Our office is located in the Kansas City area, however, we offer hybrid and remote work options.

Responsibilities:

• Build data pipelines to ingest and automate files provided by customers using ETL tool
• Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using primarily ETL tools
• Explore and learn the latest AWS technologies to provide new capabilities and increase efficiency
• Investigate and resolve data related issues and provide support and troubleshooting expertise

Requirements:

• Bachelor's degree or greater in Computer Science, or related technical degree and/or experience
• 2+ years of experience in ETL Tools (Talend is a plus, but not required), including building data pipelines to ingest and automate files provided by customers
• 2+ years of experience with SQL queries, including various SQL commands
• Knowledge of Structured and Unstructured data
• Possess understanding of BI concepts and be familiar with relational or multi-dimensional modeling concepts
• Understanding of RDBMS best practices and performance tuning techniques
• Experience with cloud technologies such as AWS, and a passion for a role working in a cloud data warehouse

It would be nice if you had...

• Experience with Agile and Scrum methodologies
• Knowledge of Java or JavaScript
• Experience with AWS Services – S3, Cloudwatch, EC2
• Experience with Databricks

#LI-DM1#LI-Remote