Overview
Remote
$50 - $70
Contract - Independent
Contract - W2
Contract - 12 Month(s)
Skills
Data Warehouse
PL/SQL
Oracle Cloud
Job Details
Job Title: Senior Data Warehouse Developer
Duration: 12 Months
Work Arrangement: Remote
Top 3 Required Skills:
- PL/SQL & T-SQL
- Data Warehouse Design & Development
- Code Review & Conversion
Job Description:
The DAFS Data Warehouse team is seeking two experienced Senior Data Warehouse Developers to support the ongoing PRISM and OMS ReFRAME projects. These individuals will also assist agency users with the current production environments and provide continued support after project go-live.
Key Responsibilities:
- Prepare detailed design specifications for highly complex and large-scale systems to guide development and programming efforts.
- Maintain assigned systems by responding to and resolving issues, ensuring continuous availability and proper functionality.
- Develop systems using high-level languages (e.g., 3GLs, 4GLs), enterprise-grade application development tools, utilities, and project management tools to ready systems for implementation.
- Diagnose and isolate complex application software issues; formulate and implement solutions that consider system capacity, limitations, and desired outcomes.
- Design and develop reusable subroutines to enhance development productivity.
- Perform advanced and specialized programming tasks to meet user and business requirements.
- Manage multiple priorities effectively while maintaining consistent progress on assigned work.
- Engage in a customer-focused approach when collaborating with cross-functional teams and business stakeholders.
- Work efficiently within a shared team development environment, contributing to all stages of the Software Development Life Cycle (SDLC).
- Operate in an Oracle Cloud environment with demonstrated capability.
- Apply best practices in Data Warehouse design and development, including the Kimball methodology.
- Design and work with data warehouse Star Schemas to support analytical and reporting needs.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.