Business Intelligence Data Architect - Research, Assessment & Data (2025-2026)

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.

TITLE:

Business Intelligence Data Architect

REPORTS TO:

Assigned Supervisor

DEPARTMENT:

As Assigned

CLASSIFICATION:

Classified

FLSA:

Non-Exempt

WORK YEAR/HOURS:

261 days / 7.5 hours

ISSUED:

Created: April 2019

SALARY GRADE:

WTCL 64

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 Districts 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

• Bachelors 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 Drivers 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.