Consultant - R Shiny Full Stack

Role Summary: This role demands experienced developers to create detailed member level information supporting the MART application development which involves Application (UX) development and integration with data sources , ETL pipeline development. Responsibilities: Design, develop, and maintain the user interface (UI) of the MART application using R Shiny, JavaScript, and CSS, ensuring a seamless and intuitive user experience. Develop and maintain efficient and scalable ETL pipelines using GCP Dataform and BigQuery to extract, transform, and load data from various on-premise (Oracle) and cloud-based sources. This includes leveraging Big R query for accessing on-premise Oracle data. Develop and implement data manipulation and transformation logic in R, creating a longitudinal data format with unique member identifiers. Develop and implement comprehensive logging and monitoring using Splunk. Collaborate with other developers, data scientists, and stakeholders to ensure the timely delivery of high-quality software. Participate in all phases of the software development lifecycle, from requirements gathering and design to testing and deployment. Contribute to the maintenance and improvement of existing application functionality. Work within a Git-based version control system. Manage data in a dedicated GCP project, adhering to best practices for cloud security and scalability. Contribute to the creation of summary statistics for groups via the Population Assessment Tool (PAT). Required Skillsets: Strong proficiency in R Shiny for UI development. Strong proficiency in JavaScript, CSS, and HTML for front-end development. Proven experience in designing, developing, and maintaining ETL pipelines, preferably using GCP Dataform and BigQuery. Experience with data manipulation and transformation in R, including creating longitudinal datasets. Experience working with on-premise databases (Oracle), preferably using Big R query for data access. Experience with Git for version control. Experience with Splunk for logging and monitoring. Experience working with cloud platforms, specifically Google Cloud Platform (GCP). Strong analytical and problem-solving skills. Excellent communication and collaboration skills. Good to Have Skillsets: Experience with Tableau for dashboarding and data visualization. Experience with advanced data visualization techniques. Experience working in an Agile development environment. Shift Requirement: 3PM to 12 midnight