BI Architect

Tacoma Public Schools

Expected Start Date: As soon as possible

FTE: 1.0

Salary Level: Range is $129,773 - $179,662 DOE

This position performs duties designed to maximize and unify Business Intelligence (BI) capabilities; manages assigned staff, develops, supports, and implements BI solutions; applies business intelligence across the enterprise using business analytics tools to analyze data and share insights; builds new solutions for reporting and analytics; gathers and analyzes business requirements; plans, prepares, implements, and delivers end-to-end solutions to meet District objectives

ESSENTIAL JOB FUNCTIONS

1. Lead, supervise, and evaluate BI, Data, and Reporting staff to achieve the mission of the department and district

2. Serves as the lead and primary liaison for data and reporting across the district, including but not limited to the data warehouse, Power BI, district reporting, and data standards. Is the “go-to” person for staff and departments across the district for any data and reporting issues or projects

3. Working with the Director of Data & Application Development, leads training and professional development to ensure that staff are informed and trained in their roles.

4. Develops scalable and maintainable BI applications to meet business objectives and to transform data into knowledge supporting data-informed decision making; works together with administrators and customers to identify and scope their business opportunities

5. Maintains, supports, and enhances the enterprise data warehouse and its constituent star-schema/dimensional model data marts; is responsible for data integrity as well as the quality of data; identifies root cause problems in data quality and collaborates with technology and other staff to develop plans to avoid or mitigate data quality issues

6. Participates in the development and implementation of security and authentication standards for the organization

7. Manage and balance work priorities to ensure the department delivers what is expected of it|

8. Maintains accurate and complete technical architectural documents and data validation methods

9. Defines BI standards, guidelines, and best practices for business groups and technical teams

10. Supports BI tools upgrades in development, testing, and documentation

11. Performs maintenance and troubleshooting activities for BI tools.

12. Diagnoses and resolves BI tool capacity issues with a strong aptitude for modern BI solution development using Power BI, Azure, and SQL Server

13. Recommends strategies to improve performance and capacity of BI tools for current and future data

14. Addresses customer queries and issues promptly; provides analytic support to the application and/or data source; delivers end-user analytics issue troubleshooting, performance improvements, and support

15. Provides BI administration and technical support during weekends, after-hours, and holidays, when needed

16. Provides technical training on BI tools to junior staff; develops end-user training, training materials, and provides guidance and mentoring for the District staff, as needed

17. Leads BI Administrators, Developers, Analysts, and other essential staff in the successful development of BI reporting and analysis solutions; promotes data and analytic goals with technology resources, infrastructure, and other service areas

18. Collaborates with business groups and technical teams to develop and maintain the data warehouse platform for BI reporting in a way that meets end-user business needs

OTHER JOB DUTIES

1. Maintains and updates knowledge and skills required for success in the position by participating in professional development activities as needed or assigned.

2. Assists appropriate department staff during peak workloads and absences; provides backup assistance for other technical support staff for special projects when assigned

3. Performs related duties as assigned, temporarily

4. Regular, reliable, predictable attendance or physical presence is an essential job requirement and critical to the performance of the work

CONDITIONS

Experiences frequent interruptions; exposed to video display; may work in confined areas; may be required to work extended and/or irregular hours; required to travel to District sites; exposed to confidential information; required to bend, squat, stoop, kneel, crouch, walk, twist, climb, and/or be mobile, and lift 20 pounds and team move/lift heavy objects up to 60 pounds.

Education and Experience

Bachelor’s degree in computer science, information systems, mathematics or related field; five years of experience with business intelligence solution development and data warehousing; experience with Power BI, including DAX and data modeling, data mart and data warehouse architecture; professional experience with Azure data/analytics platforms; or any combination of experience and training which provides the applicant with the knowledge skills and ability required to perform the work

Licenses/Special Requirements

Valid Washington driver’s license with access to personal transportation

Proof of training and/or certification, required, if applicable

Fingerprints and successful WSP and FBI background clearance/sexual misconduct clearance

Knowledge, Skills, and Abilities

Knowledge and deep understanding of dimensional data modeling concepts as well as data warehouse design and lifecycle management principles.

Knowledge of basic staff management principles

Knowledge of the Kimball dimensional model principles

Knowledge of principles, practices for data discovery using raw data sources

Knowledge of source control tools and protocols, such as Git (version control system) and Visual Studio Team Services (VSTS)

Knowledge of principles, practices, and techniques of system analysis and programming languages

Knowledge of hardware and software reporting platforms and tools

Knowledge of and expertise with Structured Query Language (SQL) objects, stored procedures, views, and functions

Knowledge of Extract, Transform, and Load (ETL) product in a development role

Knowledge of business practices in multiple departments

Skill in oral and written communication

Skill in Project Management

Skill in conflict resolution

Skill in presentation and interpersonal communication

Skill in collaborating with staff to make the most informed decisions about the current state of District collaboration tools and applications

Skill in system/process orientation

Skill in developing and organizing high-quality documentation

Skill in attention to detail

Strong analytical, quantitative, problem solving, and organizational skills

Skill with both on-premises and Azure environments

Skill in designing and implementing enterprise business intelligence solutions using Microsoft BI technologies, with a focus on Power BI, SQL Server, Excel, SSIS, SSRS, and SSAS

Skill in creating BI tools and systems

Ability to take the initiative to learn and research new concepts, ideas, and technologies

Ability to create SSAS multidimensional cubes and tabular models

Ability to organize, prioritize, execute tasks, and meet deadlines with effective follow-through

Ability to work independently, exercise good judgment, and make timely decisions

Ability to take ownership of problems and/or issues and follow through with a resolution

Ability to obtain, exchange, and clarify information and communicate technical information to technical and non-technical personnel

Ability to analyze complex problems

Ability to maintain confidentiality

Ability to participate effectively as a team member

Ability to facilitate meetings and follow up with resulting action items

Ability to demonstrate reasonable, reliable, and regular attendance

Ability to multi-task

Ability to establish and maintain effective working relationships with a variety of people in a multi-cultural, diverse socio-economic setting

Ability to learn new languages as required.

This job description is not an employment agreement or contract. District administration has the exclusive right to alter this job description at any time without notice. The statements contained herein reflect general details as necessary to describe the primary functions of this job, the level of knowledge and skill typically required and the scope of responsibility, but should not be considered an all-inclusive listing of work requirements. Individuals may perform other duties as assigned including work in other functional areas to cover absences or relief, to equalize peak work periods or otherwise balance the workload.

Tacoma Public Schools does not discriminate in any programs or activities on the basis of sex, race, creed, religion, color, national origin, age, veteran or military status, sexual orientation, gender expression or identity, disability, or the use of a trained dog guide or service animal and provides equal access to the Boy Scouts and other designated youth groups. The following employees have been designated to handle questions and complaints of alleged discrimination:

• Civil Rights Coordinator: Renee Trueblood, 253-571-1252 ,civilrights@tacoma.k12.wa.us
• Title IX Coordinator: Wayne Greer, 253-571-1191, wgreer@tacoma.k12.wa.us
• 504 Coordinator, Elementary: Jennifer Herbold, 253-571-1096, jherbol@tacoma.k12.wa.us
• 504 Coordinator, Secondary: Megan Nelson, 253-571-1003, mnelson@tacoma.k12.wa.us