Business Intelligence Developer (Assistant Director)

Job Description

Job Title

Job Title: Business Intelligence Developer

Posting Date: June 17, 2020

Closing Date: Until Filled

Salary Details: $67,229 -  $90,376

Job Type: Administrative 

Benefits Eligibility: Successful candidates will be eligible for competitive medical, dental, vision and life insurance coverage, as well as generous illness and/or vacation days.

Reports to: Deputy Executive Director of Data Services

Location: Data Assessment and Accountability

Position Summary:

As a member of the district’s Data Services team, the Business Intelligence Developer works with the Deputy Executive Director to deliver BI solutions and execute on data visualization tools on behalf of the District. The district currently relies on a set of dashboards to facilitate structured conversations around school performance. The BI developer will direct, design, and produce these dashboards. Collaborating closely with the data architect and ETL developer on the team, the BI developer will be responsible for bringing projects from structured data in a SQL database to a comprehensive solution.

The BI developer will serve as the technical visualization expert for the district, responsible for building top-tier analytical tools that will initially be school- and district-leader facing and expand to other school-based users. This role will be a great opportunity for exposure to the data trends within an urban school district representing over 50,000 students, and to build scalable solutions that support strategic decision-making and will be used by thousands of users across the District.

Qualifications

Education:

• Must possess and provide evidence of a Bachelor’s degree, and/or technical or equivalent experience in computer science, data science or business intelligence.
• Relevant BI certifications are a plus

Experience:

• More than two (2) years’ experience in BI and data visualization
• Demonstrated expertise and fluency in Power BI; should be able to design and develop Power BI reports leveraging DAX functions
• Experience working with large datasets (with millions of rows)
• Proficiency in SQL
• Proficiency in Microsoft Excel (with pivot tables, nested functions and vlookups)
• Experience compiling and maintaining technical documentation
• Advanced critical thinking ability and a working knowledge of applied statistics
• Experience in SSIS/SSRS and other tools in the Microsoft Business Intelligence Suite a plus
• A grasp of the principles surrounding the visual display of quantitative information
• Expertise and experience working in an urban public school district is a plus

Essential Functions

Under the direction of the Deputy Executive Director of Data Services, the BI Developer shall:

• 1.Participate in the full development lifecycle of BI solutions, including planning, designing, developing, testing and deploying
• 2.Produce accurate and thoughtful displays of data in dashboards that communicate school performance KPIs for audiences
• 3.Query and manipulate data using SQL within Power BI and other BI tools to achieve desired solutions
• 4.Implement BI solutions using data modeling best practices, and staying current with the latest BI technologies
• 5.Be a champion for the principles and guidelines of data visualization, keeping afloat on the discourse in the data visualization world
• 6.Engage in design-oriented focus groups with local stakeholders (principals, teachers, support staff, administrators, district teams, etc.)
• 7.Be a key contributing member and voice within the Data Services team, which stewards schooling data from data collection to the presentation of aggregated metrics for schools
• 8.Write and curate documentation internally and externally around business rules for metrics
• 9.Participate in project timeline estimation process
• 10.Perform ad hoc data analysis duties as assigned by manager

Security Clearance:

Internal Applicants

If you are a current Detroit Public Schools employee, presently employed with the district, you do not have to submit a fee related to obtaining the Detroit Public Schools security clearance, unless your new role requires a different type of security clearance.

External Applicants

If you are hired to fill a vacant position, you will be required to submit a Detroit Public Schools security clearance. At point of offer to hire, you will be responsible for a non-refundable payment of $64.50 via Visa, Master Card, American Express, Discover Card, cashier's check, or money order, payable to the DPSCD Police Department. No personal checks or cash is accepted.

Method of Application:

Applicants must apply through the online application system. Only applications submitted through the online application system will be considered for any posted position and all applications require a resume to be considered.

Successful candidates are required to submit official transcript(s) at point of offer to hire. Teaching service outside of the Detroit Public Schools Community District must be verified by the applicant's prior employer(s) prior to hire. It is the applicant's responsibility to provide all documentation (including copies) as requested.

Applicants requesting assistance during the application process should contact the Office of Human Resources via email at [email protected] or phone at (313) 873-6897.