Logo
Rx Savings Solutions

Enterprise Data Warehouse Developer

Rx Savings Solutions, Overland Park, Kansas, United States, 66213


**Enterprise Data Warehouse Developer**Overland Park, Kansas / Engineering Data Engineering / Full-time, Hybrid Here at Rx Savings Solutions, we are driven to make a difference in the pharmaceutical industry by exposing cost-savings analytics to our members. We take pride knowing that the work we do can greatly impact the lives of our customers.We currently have an opportunity for an experienced Data Engineer to join our growing EDW Team! This role will assist in planning, designing, and documenting technical requirements for data flows between disparate operational systems and to our data warehouse. The candidate will be assisting in end-to-end development of the ETL process as well as build data models and define, analyze, build, unit test and maintain new as well as existing software applications to support business requirements. This Data Warehouse Engineer works closely with the Business, Data Ingestion and Insights teams in order provide meaningful data products for the business and enables consistently informed management decisions.Check out what our CTO shares about the personal growth opportunities and impactful work as an Engineer on our team: **Education**+ Bachelors degree or greater in Computer Science or related experience**Job Duties**+ Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using primarily ETL tool.+ 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**+ 2 - 3 years of experience in ETL Tools (Talend is a plus)+ Strong knowledge of Python required , especially around data frames and pandas.+ Good knowledge about Bitbucket , Jenkins and CI/CD pipelines.+ Need to have knowledge on cloud data warehouse solutions (Snowflake, Redshift or Big Query).+ Experience loading data into database and generating outbound files using any ETL tool.+ Expertise and excellent understanding of Internals and integration of cloud data warehouse solutions with other data processing and reporting technologies.+ Knowledge on ETL and ELT pipelines using any ETL tool.+ Understanding of BI concepts and be familiar with relational or multi-dimensional modeling concepts.+ Hands on experience writing Stored Procs, Materialized views and Views.+ Understanding of RDBMS best practices and performance tuning techniques.+ Knowledge of Structured and Unstructured data.+ Strong analytical skills and attention to detail.+ Ability to communicate with stakeholders of different backgrounds and skill levels.+ Highly motivated, self-directed, and flexible.+ A great attitude with a passion for supporting your team and offering creative solutions.+ Willingness and enthusiasm to learn new skills and techniques.+ Experience with AWS technologies, Passionate about your role and working for cloud Data Warehouse.+ A solid experience and understanding of designing and operationalization of large-scale data and analytics solutions on Data Warehouse is a must.+ Experience with Agile and Scrum methodologies.+ Knowledge of Java or JavaScript.+ Knowledge of CI/CD pipelines.+ Good to have hands on experience on AWS Services S3, CloudWatch, EC2, App Flow, Jenkins, and Salesforce.