Hybrid Business Intelligence Data Architect - Research, Assessment & Data (2025-2026) bei Oakland Unified School District

Ref. 8311

The District and SEIU 1021 are working together to create promotional opportunities for existing staff, therefore this job posting is available for five (5) days for internal candidates based on our collective bargaining agreement.

BASIC FUNCTION:  Under supervision of the assigned supervisor, the Business Intelligence Data Architect builds and implements data solutions that will be the backbone of reporting and analytics overseen by the assigned department. The Data Architect will provide data solutions for various data sources; Develop and maintain data models and relevant strategies; Design and implement ETL (Extract, Transform, Load) processes; Develop and maintain metadata documentation; Support team members with needs and questions of underlying data structure for data analysis.

REPRESENTATIVE DUTIES: (Incumbents may perform any combination of the essential functions shown below. This position description is not intended to be an exhaustive list of all duties, knowledge, or abilities associated with this classification, but is intended to reflect the principal job elements accurately.)

ESSENTIAL FUNCTIONS:

• Understand and translate raw business requirement and data reporting needs into data modelling, data strategy and data integration requirements.
• Propose database solutions for different data sources.
• Develop and maintain data models and data processes to support reporting.
• Take the lead on migrating data from various data systems into our databases.
• Implement best practices for data structures and data integration.
• Develop and maintain SQL stored procedures, functions, and ad hoc queries.
• Automate data processes that will feed data into our data dashboards.
• Improve system performance by conducting tests, troubleshooting and integrating new elements.
• Develop and maintain database design and architecture documentation.
• Develop and maintain data dashboards using Tableau or other business intelligence tools.
• Work closely with the data team to identify future needs and requirements.
• Mentor, share and provide cross-training on database knowledge.
• Collaborate with Tech Services team to define security and backup procedures, and to ensure compliance with data security.
• Develop database solutions by designing proposed system.
• Determine database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients, and evaluating current systems.
• Suggest areas for improvement in system performance along with possible solutions.
• Resolve and/or escalate issues in a timely fashion.
• Work with IT staff and District stakeholders to understand data requirements.
• Update job knowledge by self-directed study, such as reading professional publications; taking online courses, and/or participating in professional organizations.
• Hold status meetings, as appropriate, with interdepartmental project team.
• Perform other related duties as assigned.

QUALIFICATIONS:

The District determines whether a candidate is qualified based on fulfillment of prerequisites, relevant work experience, ability to perform the essential functions, reference checks, effective interpersonal and communication skills demonstrated by interview performance and/or writing samples, and achievement on performance-based assessments (if applicable) that demonstrate the candidate possesses the requisite knowledge, skills and abilities.  Meeting prerequisites only satisfies the initial screening process and does not indicate the candidate is qualified to perform the essential functions of the position.

KNOWLEDGE OF:

• Advanced knowledge of relational database design and data modeling skills
• Automating data migration using SSIS
• Planning, organization, and procedural guidelines of the District’s Research, Assessment and Data programs
• Microsoft Office software including Word, Excel, Access, PowerPoint
• Business Intelligence software such as Tableau, SSRS, Power BI, etc.

ABILITY TO:

• Interpret, apply and explain rules, regulations, policies and procedures
• Make sound, independent decisions within established guidelines and when there are competing priorities
• Communicate clearly and effectively orally and in writing
• Work collaboratively and effectively with the project leader, database administrators, data analysts and management
• Establish and maintain effective customer-focused working relationships with managers, customers, vendors, consultants, employees and others encountered in the course of work
• Read and interpret complex data, information and documents
• Analyze and solve problems
• Observe and interpret situations
• Use math and mathematical reasoning

PREREQUISITES

• Bachelor’s degree required with a major in computer science or engineering, or related major preferred
• 6+ years of experience in data modelling
• 6+ years of experience in using SQL
• 6+ years of experience in designing and building relationship databases
• 6+ years of experience in data integration
• 6+ years of experience in data governance
• Valid California Driver’s License, if applicable

PRE-EMPLOYMENT PROCESS:

Employment eligibility will include fingerprints, tuberculosis and/or other employment clearance

WORKING CONDITIONS

ENVIRONMENT:

Office and diverse school site environments; driving a vehicle to conduct work; fast-paced work; constant interruptions

PHYSICAL REQUIREMENTS:

Consistent mental alertness; sitting or standing for extended periods of time; lifting, carrying, pushing, and pulling objects up to 30 pounds, occasionally 30+ pounds; bending and twisting at the waist, reaching overhead, above the shoulders and horizontally; dexterity of both hands and fingers while performing duties; seeing to read, write and use the computer; hearing and speaking to exchange information, in person or on the telephone, and make presentations.

NON-DISCRIMINATION POLICY:

The Oakland Unified School District does not discriminate in any program, activity, or in employment on the basis of actual or perceived race, religion, color, national origin, ancestry, age, marital status, pregnancy, physical or mental disability, medical condition, genetic information, veteran status, gender, sex, or sexual orientation.