Data Architect Save

Under direction, designs and implements organizational data models and pipelines to support Measure C and Oakland Children’s Initiative (OCI)-related initiatives; builds a data warehouse and establishes modern data operation systems and practices; collaborates with various stakeholders to develop and implement short and long-term solutions to critical data resource issues aligned with best practices and Agency policies, procedures, and standards; provides complex professional assistance to the Impact Officer in areas of expertise; and performs related duties, as assigned.

• Designs complex data models to represent children, families, providers, contractors, and other entities, enabling robust business intelligence and project evaluation across Measure C, OCI, and agency-wide initiatives.
• Builds data processing operations using SaaS and cloud tools to extract, transform, and load data from flat files and live internal/external sources into the data warehouse.
• Serves as a technical expert for complex data systems integration projects; conducts extensive research on system compatibility; collaborates with technical experts cross-departmentally on optimal system configuration, applications systems integration, database management, protocols, and related systems matters.
• Designs, develops, communicates, and visualizes road maps for short- and long-term solutions to critical data systems issues and presents to stakeholders; ensures compliance with the Agency’s policies, procedures, and standards.
• Meets with internal data stakeholders to gather requirements and ensure data models and warehouse align with organizational needs.
• Collaborates with peers to ensure secure operation of the data infrastructure and compliance with data governance standards.
• Participates in administering information technology related contracts; prepares project specifications; evaluates submitted proposals and provides feedback on vendor qualifications and proposed services; monitors and evaluates contractor performance to ensure compliance with Agency’s standards and contract provisions; initiates corrective action as appropriate
• Attends and participates in professional group meetings; conducts research and stays current on contemporary trends and innovative technology solutions; recommends innovative technologies that would improve the City’s enterprise and departmental information technology services and operational effectiveness.
• Observes and complies with all Agency and mandated safety rules, regulations, and protocols.

Minimum Qualifications

Any combination of training and experience that would provide the required knowledge, skills, and abilities is qualifying. Additional experience and/or education can be substituted to meet typical qualifications. A typical way to obtain the required qualifications would be:

Five (5) years of increasingly responsible data system design experience and equivalent to a bachelor’s degree with major coursework in computer science, information technology, or a closely related field.

Additional relevant work experience may be substituted to meet the college coursework/bachelor's degree standard.

Knowledge of:

• Data model design principles and practices for representing complex entities such as individuals, families, providers, and contracts.
• Early childhood care data systems and their structural and operational requirements.
• Data orchestration tools and ETL (Extract, Transform, Load) processes for integrating diverse data sources.
• Data quality management techniques to ensure accuracy, consistency, and reliability of datasets.
• Data governance frameworks and security protocols for managing access, compliance, and integrity.
• SaaS-based data processing platforms and cloud infrastructure.
• Business intelligence concepts and tools used for performance evaluation and decision-making.
• Applicable federal, state, and local laws, regulatory codes, ordinances, and procedures relevant to assigned areas of responsibility.
• Principles and practices of developing and maintaining technical documentation for assigned projects.
• Applicable federal, state, and local laws, codes, and regulations as well as industry standards and best practices pertinent to the assigned area of responsibility.
• Agency and mandated safety rules, regulations, and protocols.
• Techniques for providing a high level of customer service, by effectively dealing with the public, vendors, contractors, and Agency staff.
• The structure and content of the English language, including the meaning and spelling of words, rules of composition, and grammar.
• Modern equipment and communication tools used for business functions and program, project, and task coordination, including computers and software programs relevant to work performed.

Ability to:

• Design and document scalable, interconnected data models and diagrams to support organizational analytics.
• Implement and manage data orchestration workflows and data warehousing solutions.
• Collaborate effectively with stakeholders to gather requirements and translate them into technical specifications.
• Ensure secure and compliant data operations aligned with governance standards.
• Optimize data infrastructure for performance and cost-efficiency.
• Communicate technical concepts clearly to both technical and non-technical audiences.
• Adapt to evolving data technologies and integrate new tools into existing systems.
• Create and maintain reports and dashboards to visualize and communicate data trends.
• Stay updated on emerging database technologies, trends, and best practices to enhance database management skills.
• Understand, interpret, and apply all pertinent laws, codes, regulations, policies and procedures, and standards relevant to work performed. • Prepare clear and concise correspondence, documentation, and other written materials.
• Use tact, initiative, prudence, and independent judgment within general policy and procedural guidelines.
• Independently organize work, set priorities, meet critical deadlines, and follow-up on assignments.
• Communicate clearly and concisely, both orally and in writing, using appropriate English grammar and syntax.
• Establish, maintain, and foster positive and effective working relationships with those contacted in the course of work.
• Effectively use computer systems, software applications relevant to work performed, and modern business equipment to perform a variety of work tasks.

Please note:

We are working a hybrid in-office schedule and may return full-time at an undetermined date.

All First 5 employees must live and work in California.

The salary range for this position is $110,000 to $159,000 and as an independent government agency, the posted salary is the set salary range for this position. We cannot offer salaries above this posted range.

We conduct reference and background checks for all potential employees.

About First 5 Alameda County

First 5 Alameda County believes every child in Alameda County should have optimal health, development, and well-being to reach their greatest potential. Through innovative programs and policy advocacy, we help provide children and their families access to resources that support their first five years of development.

Join our mission-driven team that in partnership with the community, supports a county-wide continuous prevention and early intervention system that promotes optimal health and development, narrows disparities, and improves peak years of child development.

First 5 Alameda County Benefits

We offer a comprehensive benefits package with health care options to meet the diverse needs of our employees and their families. These benefits include but are not limited to Medical, Dental, & Vision Coverage, $1,500 credit per year to spend on benefits, Health and Dependent Care Flexible Spending Accounts (FSAs), Employer Paid & Voluntary Life & AD&D Insurance, Long-Term Disability Insurance, Retirement Plans including the ACERA Pension Plan, Commuter Benefits, Employee Assistance Plan and more.

We also offer paid vacation, paid time off and sick time. We have 17 paid holidays including the week between Christmas Day and New Year's Day as paid time off.