Job Description

Posting number: 27593

Department: Business Intelligence/Atlas Data Warehse

Job classification: Business Intelligence Developer Prin

Posting type: Open & Promotional

Categories: IT and Computers

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.

Examples of duties

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.

Qualifications

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