Technical Data Warehouse Analyst

Role: Technical Data Warehouse Analyst Location: 100% Remote Type: Contract (8 months, possible extension) Overview We are seeking an experienced Technical Data Warehouse Analyst to support critical projects (PRISM and OMS ReFRAME) while also assisting with production system enhancements and user support. This role involves PL/SQL development, data warehouse design, requirements gathering, testing, and documentation, with a strong focus on Star Schema and Kimball methodology. Top Required Skills • Strong expertise in PL/SQL and Data Warehouse concepts • Hands-on experience with Star Schema design and Kimball methodology • Ability to review, convert, and optimize existing code • Strong background in gathering business requirements and translating into technical specs • Experience creating technical documentation and supporting full SDLC • Strong knowledge of software testing practices Key Responsibilities • Support project delivery for PRISM and OMS ReFRAME initiatives and post go-live support. • Gather business requirements and translate them into technical design documentation. • Design and maintain large-scale data warehouse systems, including Star Schema models. • Prepare detailed design specifications to facilitate development and programming. • Develop and optimize PL/SQL routines to support system development and productivity. • Diagnose, troubleshoot, and resolve complex application/software issues in production environments. • Collaborate with cross-functional teams to meet project timelines and deliverables. • Support system development in an Oracle Cloud Infrastructure (OCI) environment. • Apply knowledge of Data Warehouse design principles to improve efficiency and reporting. • Perform software testing, ensuring quality and accuracy of deliverables. Qualifications • Proven experience in data warehouse development and analysis. • Strong skills in PL/SQL programming and performance tuning. • Familiarity with Oracle Cloud Infrastructure (OCI) preferred. • Excellent problem-solving and multitasking abilities. • Strong communication skills with a customer-focused approach. • Ability to thrive in a shared development environment and manage multiple priorities.