Data Warehouse Developer

$83,081 - $117,392/Yr

Kern Community College District - Bakersfield, CA

Full-time - Entry Level

Bakersfield, CA

Educational Services

About the position

The Data Warehouse Developer at Kern Community College District plays a crucial role in the design, development, implementation, maintenance, and enhancement of data warehousing, business intelligence, and reporting systems. This position is integral to the Data Warehouse and Reporting team, focusing on delivering effective business intelligence solutions and supporting the operational needs of the college.

Responsibilities

• Develop an in-depth understanding of data maintained in various transactional systems and how data from these systems are best organized and integrated to support transactional, reporting, and analytic needs.
• Analyze complex business processes and analytics requirements in higher education and develop cost-effective solutions using Ellucian's Operational Data Store (ODS), Oracle Discoverer, Argos, and other reporting tools and software.
• Create and maintain relational and dimensional data structures within the data warehouse and operational data store to meet functional requirements and optimize performance.
• Develop and maintain data marts, data cubes, queries, and reports.
• Develop and maintain data models and data maps for the data warehouse system and operational data store.
• Develop processes and applications for migration/transformation of data from College-wide systems to the data warehouse system and operational data store.
• Coordinate, schedule, and test upgrades to the data warehouse and reporting systems.
• Research and evaluate software, system upgrades, and enhancements and provide technical recommendations.
• Provide assistance to end users and programmers regarding data warehouse/reporting related problems and issues.
• Manage end-user accounts and accessibility; provide technical expertise to end-users who create complex queries and reports.
• Work closely with key internal customers to identify opportunities to further and better support KCCD operations in terms of reporting and information access.
• Keep current with the latest technology; regularly attend technical training in order to maintain technical expertise.
• Perform related duties as assigned.

Requirements

• Bachelor's degree in Information Systems, Computer Science or related field and some experience working with or supporting information technology systems.
• OR an Associate's degree and 2 years of work experience in data warehousing, business intelligence, and reporting systems.
• OR a high school diploma, GED or equivalent certificate of competency and 4 years of work experience in data warehousing, business intelligence, and reporting systems.
• Preferred: One year of data warehouse and reporting experience.

Nice-to-haves

• Knowledge of Data Warehouse and Data Mart concepts, structures, and systems
• Experience with Extract, Transform and Load processes
• Familiarity with reporting design and delivering reporting solutions
• Understanding of relational database concepts
• Experience with PL/SQL coding
• Knowledge of end-user reporting tools
• Familiarity with Windows and Unix operating systems
• Basic statistical methods

Benefits

• Salary range of $6,923.44 - $9,782.64 monthly
• Professional development opportunities
• Diversity and inclusion initiatives
• Support for reasonable accommodation during the selection process