Senior Developer, Business Intelligence

  • Full-time
  • Hiring Start Time: Immediate Start (Home Office)
  • HO Team: Information Technology and Data Management

Company Description

Uncommon Schools is a nonprofit network of successful charter public schools that are closing the academic achievement gap and preparing students from historically underserved communities for success in college and beyond. Uncommon currently manages 57 schools serving more than 20,000 students in six cities: Boston, Camden, New York City, Newark, Rochester, and Troy. Uncommon graduates persist in and graduate from college at rates far higher than their peers. We believe that every child deserves an outstanding education, and we are committed to working beyond the walls of our schools to achieve that goal through our professional development workshops, books, and district partnerships.

Job Description

The Sr. Developer, Business Intelligence (BI) will be the backbone of Uncommon Schools’ innovation efforts to ensure that Uncommon Schools’ Home Office, Regions and Schools have the technology solutions required to accomplish the organization’s strategic goals. The individual in this role will acquire a deep understanding of needs across all levels of the organization and implement new technology and data solutions to Uncommon Schools’ most pressing problems. The Sr. Developer, BI will work closely with other team members, outsourced senior application developers, and owners of the data sources. The Sr. Developer, BI will provide access to the data via reports, data extracts, and analysis tools. To be successful, the individual in this role will need to have or gain an understanding of the education data landscape (e.g. assessments, SIS, standards), and have the ability to gather reporting requirements, design reports, and release them into production.

Product Management and Development: 

  • Partner with instructional, operational, regional and HO teams to develop reports and address data needs to provide reporting solution
  • Facilitate collaboration and communication with internal partners to understand data needs, clarify requirements, and navigate and resolve end user needs that are in tension
  • Synthesize and translate instructional and business data needs into creative visualizations and tools
  • Develop, maintain, and lead complex reporting, analytics, dashboards and other BI solutions primarily in, but not limited to, Tableau, which includes other reporting tools like Power BI, etc.
  • Perform and document the details of data analysis, data validation, data mapping/design, by accessing multiple sources, specifically data residing in source systems
  • Provide application analysis and data modeling design to collect data for centralized data warehouse
  • Extract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems

Management: 

  • This position directly manages up to 2 Full Time Employees
  • Oversight and Professional Development: Guide and review team member work products, and support the team members individual growth within Uncommon Schools and the K-12 education and technology space
  • Facilitate problem-solving for the team: identify trends and issues within our BI implementations and practices, and drive ongoing efforts for product and process improvements that make progress toward the long term vision of IT at Uncommon Schools
  • Train team members in Business Intelligence and IT methodologies and standards around BI implementations (especially using Tableau server)

Qualifications

Required:

  • Bachelor’s degree required
  • 5+ years of experience in the Business Intelligence field and expertise in data driven dashboard/analytics design, development and implementation
  • Outstanding strategic, analytical and critical thinking skills and good attention to detail 
  • Strong written and verbal communication skills 
  • Strong end-user orientation; deep concern and empathy for users and internal partners 
  • Demonstrated ability to be self-directed and take initiative 
  • Excellent organization, time management, and tenacious follow-up skills; ability to prioritize
  • Demonstrated ability to collaborate effectively and establish credibility with internal/external developers and vendors 
  • Ability to be diplomatic while influencing another’s perspective 
  • Detailed understanding of how to interpret customer business needs and translate them into application and operational requirements 
  • Demonstrated ability to learn new tools, systems and processes quickly 
  • Solid work ethic and dedication to high standards of excellence coupled with an enthusiastic approach to one’s work

Technical Skills Required:

  • Understanding of SQL, relational databases & normalization
  • High level proficiency in Excel (macros, pivot tables, etc.)
  • Expertise in developing, maintaining, and supporting dashboards & underlying analytics, preferably with a solid understanding of Tableau server administration/architecture
  • Proficient in the use of query and reporting analysis tools
  • Storyteller capable of delivering creative design and interactive data visualizations
  • Understanding of data warehouse concepts along with knowledge of SQL to write complex, optimized queries across volumes of data
  • Product Management and Production Control experience
  • Experience with mentoring/training junior developers and Power Business users
  • Experience with creation and maintenance of documents, knowledge/support articles for varying level of user groups

Preferred:

  • Certification in Tableau preferred
  • Previous direct management experience preferred
  • Previous experience in K-12 public education strongly preferred
  • Hands-on experience of RDBMS systems
  • Exposure to R development helpful
  • Solid understanding of multiple scripting/programming languages
  • Experience with stored procedures and views in MS SQL or PostgreSQL database a plus
  • Familiarity with API integrations
  • Experience with insourced and outsourced development teams adhering to the same coding standards and style guides
  • Experience designing, implementing and leading training for a range of audiences (technical, power user, and end user)
  • Preference will be given to candidates with: End-to-End Tableau development experience from Tableau data model publication, interactive dashboard design/development to deployment/maintenance. Hands-on skills with use of action filters, user filters, calculations and Level-of-Detail (LOD) expressions
  • Experience tuning the performance of Tableau Server dashboards to minimize the data and rendering refresh cycles and optimize the end user experience

Additional Information

Uncommon Schools offers salaries commensurate with experience and a very generous benefits and vacation package. All staff members receive extensive professional development and are equipped with a laptop computer and all necessary supplies.

Uncommon Schools believes in the importance of being a diverse, equitable and inclusive organization that enables our students and staff to thrive. We are committed to building a talented team that reflects the diverse backgrounds and experiences of our students. At the same time, we work to ensure an inclusive community through creating a space for meaningful dialogue about issues of race and identity for our staff and students. As an equal opportunity employer, we hire without consideration to race, religion, creed, color, national origin, age, gender, sexual orientation, marital status, veteran status or disability.