Data Warehouse Developer

Job Title: Data Warehouse Developer (Contract) - Job#5744 Location: 100% Remote Job Description Our client is seeking a Data Warehouse Developer to support the Data Warehouse team. This role will contribute to the PRISM and OMS ReFRAME projects while continuing to support existing production environments. The analyst will work closely with business stakeholders to gather requirements, review and convert legacy coding, and ensure successful system development and maintenance. Post go-live, this position will provide ongoing support to ensure stable system performance. Key Responsibilities • Develop, maintain, and enhance large-scale, complex systems using PL/SQL, enterprise-class tools, and system utilities. • Prepare detailed design specifications to guide system development efforts. • Review, refactor, and convert existing code for improved efficiency and maintainability. • Provide ongoing support and troubleshooting for production systems, resolving issues to ensure continuous availability. • Design and develop subroutines, applications, and processes in support of data warehouse and system development initiatives. • Diagnose, isolate, and resolve software problems while considering system capacity, limitations, and requirements. • Gather business requirements and translate them into clear technical specifications and documentation. • Apply Data Warehouse design and development principles, including star schema and Kimball methodology. • Perform thorough software testing, validation, and deployment support to ensure quality deliverables. • Collaborate with business users and cross-functional teams to deliver effective solutions. • Support project timelines while balancing multiple priorities in a dynamic environment. • Work within an Oracle Cloud Infrastructure (OCI) environment. Required Skills & Qualifications: • Strong experience with PL/SQL development. • Hands-on experience with Data Warehouse design, development, and maintenance. • Proven ability to review, convert, and refactor existing code. • Experience gathering and analyzing business requirements and creating detailed technical documentation. • Familiarity with Data Warehouse structures, star schema, and the Kimball methodology. • Strong understanding of the full software development lifecycle (SDLC) in a team-based environment. • Experience with system testing, validation, and deployment. • Ability to diagnose and resolve complex system and software issues. • Strong organizational skills with the ability to balance multiple priorities. • Excellent problem-solving and analytical skills with a customer-focused approach. • Strong written and verbal communication skills. Preferred Qualifications: • Experience working in an Oracle Cloud Infrastructure (OCI) environment. • Experience supporting large-scale government or enterprise IT systems. • Familiarity with project management tools and shared team development environments. About Delphi-US Delphi-US is a national recruiting firm based in Newport, Rhode Island. We specialize in IT, Engineering, and Professional Staffing services for premier corporations and a multitude of industries across the United States. We are the Peacemakers in the Talent War – bringing the best and brightest talent to Employers of Choice, enabling critical project success, fostering progressive employment relationships, and promoting competitive advantages for our Clients and the Talent Marketplace we serve. Delphi accomplishes this with a proprietary skill-based and cultural matching process that results in higher qualified submissions along with increased interviews and offer rates. You’ll find our team is highly experienced, friendly, professional, and ready to advocate on your behalf, armed with industry trends and an understanding of employer expectations.