Position: OLAP/Redshift SME
Location: 100% Remote - Owings Mills MD
Duration: 3 Month contract but will get extended to probably 1 year
**EXPERT LEVEL EXPERIENCE WITH REDSHIFT & POSTGRES RDS**
Job Description:
Our current End-Stage Renal Disease Quality Reporting System (EQRS) project involves creating a new, modernized system on the AWS platform replacing three CMS legacy systems
Place of performance
Services can be 100% remote. Candidate must have access to internet during business hours.
Description of Activities & Responsibilities
- Assist ManTech EQRS Enterprise Architect to design OLAP schema(s) in Redshift to efficiently support extracts, reporting, and analytics
- Work under the direction of the Enterprise Architect on relevant data repository implementation activities, including, but not limited to:
- Designing, writing, and maintaining ETL processes and assisting other team members with their ETL implementations;
- Reviewing ETL designs and recommending improvements;
- Reviewing API designs and recommending improvements;
- Researching and recommending options to resolve technical roadblocks to implementation.
- Attend scrum meetings a couple of times a week, weekly team backlog refinement sessions, and knowledge sharing sessions as part of the data repository implementation team
