Business Intelligence Developer Principal

Seattle Public Schools; Washington; On-site; USD 120,000 - 170,000; Full time

Job summary

Seattle Public Schools seeks a principal expert to design and implement current and future data warehouse, BI, and data migration strategies. You will lead architectural design of data warehouses, data marts, and reporting solutions to support students, teachers, and schools.

The role drives projects to completion and promotes data-driven decision-making across the district. Ideal candidates bring extensive SQL/ETL expertise, full SDLC experience, and ability to mentor staff while engaging with

Qualifications

• Ten years of experience in analytical or technological industries; fifteen years of technical experience preferred; management skills a plus.
• BS Degree in Computer Science, Business Administration or related major; Master's Degree in Computer Science, Business Administration or related major; equivalent experience considered.
• Strong knowledge of BI / Data Warehouse development processes and best practices.
• Ability to lead BI team and mentor staff; experience with data governance and data quality.
• Experience with data warehouses, data migrations, data marts, and reporting solutions.

Responsibilities

• Act as principal expert in developing and implementing BI and data warehouse requirements using SQL, ETL, BI tools, and reporting tools.
• Lead full life-cycle development and maintenance of data warehouse, ETL, and BI solutions.
• Provide leadership to technical staff and recommend BI reporting packages.
• Collaborate with customers to identify and scope business opportunities and design against district architecture.
• Document business requirements, verify solutions, and design reporting formats and data delivery methods.
• Monitor data quality and address root causes with cross-functional teams.
• Develop new capabilities and architectures for client portal and ad-hoc BI capabilities.
• Lead and mentor BI team, and ensure SDLC standards for data warehouse development.

Skills

SQL

ETL

BI tools

Data warehousing

Leadership

Requirements gathering

Data quality monitoring

SDLC best practices

Education

BS in Computer Science / Business Admin

Master's in Computer Science / Business Admin

Tools

BI reporting tools

Database programming

Job description

Responsible for providing principal level expertise in the design and technical implementation of current and future data warehouse, business intelligence solutions and data migration strategies to support District use of data to support the needs of students. teachers and schools. Manages the design database architectures, data warehouses, data migrations, data marts, business intelligence packages, and implements user reporting / data access solutions based upon business requirements, content/business knowledge and best practices. Drives projects to completion on schedule with less senior team members and district staff. Ensures that the use of data warehouse and business intelligence tools inform and enhance business decision-making capabilities.

55%

• Act as the principal level expert in developing and implementing new business intelligence and data warehouse requirements through the use of SQL, ETL, business intelligence tools, and database programming and reporting tools.
• Full life-cycle development and maintenance of data warehouse, ETL, and BI solutions.
• Provide leadership to technical staff and make recommendations on BI reporting packages.

15%

• Work with customers to identify and scope their business opportunities; design and develop against an overall architecture in support of the District's strategic plan direction and anticipated needs for data.
• Participate with the data warehouse technical team in documenting and verifying business requirements, identifying effective solutions to include and present data reporting techniques, identify risks and constraints, and design reporting formats/ data delivery methods.

10%

• Utilize expertise and advanced data analyst skills to monitor data quality; identify root cause problems in data quality and work with other technology and business staff to develop plans to avoid or mitigate data quality issues.

5%

• Develop new capabilities and architectures that capitalize on the development of client portal, and ad-hoc BI capabilities.
• Review and recommend different options to deliver data to end users in a secure, highly useable way.

5%

• Gather and study structured data from technology applications and data warehouses, and provide expertise and insight to assist with business decisions regarding product and interface design to ensure support of data use.

5%

• Develop, maintain and lead the BI team in following best practice in SDLC for data warehouse development work including standards in requirements and ETL documentation, testing, etc.

5%

• Acts as back up to the BI Manager and may have input into performance evaluations.

OTHER FUNCTIONS:

• Performs related duties consistent with the scope and intent of the position.
• Respond to ad-hoc query requests to support urgent and unanticipated business needs.

DISTRICT-WIDE CORE COMPETENCIES:

Collaboration

Develops cooperation and teamwork while participating in a group, working toward solutions which generally benefit all involved parties.

• Is seen as a team player who encourages efficient and effective collaborations.
• Works skillfully in difficult situations with both internal and external groups.
• Represents his/her own interests while being open-minded to other groups.
• Builds respectful and productive relationships internally and externally.

Getting Results(Action Oriented)

Performs work with energy and drive; values planning, but will take quick, decisive action when an opportunity presents itself.

• Demonstrates a strong sense of urgency about solving problems and getting work done.
• Focuses on achieving the goal even in the face of obstacles.
• Assumes responsibility for starting and finishing work with minimal supervision.
• Strives for new levels of performance.

Decision Quality & Problem Solving

Uses analysis, wisdom, experience and logical methods to make good decisions and solve difficult problems with effective solutions; appropriately incorporates multiple inputs to establish shared ownership and effective action.

• Weighs the consequences of options before making a decision.
• Applies appropriate criteria to situations for the purpose of making decisions.
• Displays self-confidence in own judgment.
• Focuses in the facts and solutions instead of opinions and problems.

Integrity

Is widely trusted; is seen as a direct, truthful individual; presents truthful information in an appropriate and helpful manner; keeps confidences; admits mistakes; doesn't misrepresent him/herself for personal gain.

• Deals with people and situations in an honest and forthright manner.
• Represents information and data accurately and completely.
• Represents the confidentiality of information and concerns shared by others.
• Takes ownership if a mistake is their own and does not blame others.

Accountability

Holds self and others accountable for measurable high-quality, timely and cost-effective results; determines objectives, sets priorities and delegates work; accepts responsibility for mistakes; complies with established control systems and rules.

• Takes responsibility and action as if the risks (financial or otherwise) are his or her own.
• Holds individuals and team accountable for their actions and results.
• Initiates action even if outcome is uncertain and is willing to accept the consequences of failure.
• Aligns own activities and priorities to meet broader organizational needs.
• Demonstrates courage and confidence in his or her own ability.

KNOWLEDGE, SKILLS AND ABILITIES:

• Effective strategies, technologies, methodologies and practices that will enhance the district's mission in supporting and improving the operational processes of the school district.
• Strong knowledge of Business Intelligence / Data Warehouse Development Process, best practices and methods.

• Understanding datase methodology, data analysis, advanced SQL queries, ETL and business intelligence application required.
• Provides leadership in business intelligence, team building; problem-solving; evaluating, assessing and improving the effectiveness of programs and procedures.
• Proficient with the design of database architectures, data warehouses, data migrations, data marts, business intelligence packages, and implementing user reporting solutions based upon business requirement and content knowledge.
• Must have intermediate project management skills to drive projects to completion on schedule with less senior and peer team members and mid-level business professionals.
• Mentoring/coaching skills to provide support and guidance to less senior technical and business staff
• Strong facilitation skills
• Data analyst skills to determine root cause problems for data integrity and data quality issues identified through QA or by business report owners.
• Strong interpersonal, presentation, and consultative skills. Excellent written and verbal communication skills.
• Analyze problems and recommend and implement solutions.
• Take individual initiative; accept responsibility and be held accountable.
• Coordinate multiple projects simultaneously.
• Adapt to and innovate change and remain flexible.
• Establish and maintain effective working relationships with District staff.
• Ability to gain access to key decision makers.
• Ability to be seen as peer to decision makers and influences, including executives.

EXPERIENCE/EDUCATION:

A typical way to obtain the knowledge and abilities would be:

Ten (10) years of experience in analytical or technological industries; Intelligence or closely related area; fifteen (15) years of technical experience preferred, management skills a plus; BS Degree in Computer Science, Business Administration or related major; Master's Degree in Computer Science, Business Administration or related major; additional applicable experience may be substituted for the education on a year-for-year basis; or an equivalent of education and experience.

Any equivalent combination of education, experience and training that provides the relevant knowledge, skills and abilities to perform the work will be considered.

CLEARANCES:

Criminal Justice fingerprint and background check