New York, New York, USA
36 days ago
Developer, Business Intelligence

Company Description

Uncommon Schools  is a nonprofit network of high-performing, public charter schools providing an outstanding K-12 education in historically under-resourced communities. We have proudly built schools that reflect our student population, with more than 60% of our teachers and staff across our network identifying as a person of color. Uncommon currently manages 52 schools serving more than 19,000 students in five cities: Boston, Camden, New York City, Newark and Rochester. We are proud that Uncommon graduates persist in and graduate from college at five times the rate of their peers nationally. We achieve this by offering strong academic, co-curricular, and social-emotional learning that prepares students for success in college and beyond.

Job Description

The Developer, Business Intelligence (BI) will play a key role in Uncommon’s innovation efforts to ensure that Uncommon’s Home Office, Regions, and Schools have the technology solutions required to accomplish the organization’s strategic goals. The Developer, BI will develop an understanding of needs across all levels of the organization and implement new technology and data solutions to Uncommon’s most pressing problems. The individual will work closely with other team members, outsourced senior application developers, and owners of the data sources. The Developer, BI, will be responsible for providing access to the data via reports, data extracts, and analysis tools and for coding stored procedures. The individual will need to build an understanding the K-12 data landscape (e.g. assessments, SIS, standards), and to have the ability to gather reporting requirements, design reports, and release them into production.

Product Management and Development: 

Examine and interpret complex datasets to identify trends, patterns, and insights.Synthesize and translate instructional and business data needs into creative visualizations and toolsDevelop, maintain and manage creative advanced reporting, analytics, dashboards and other BI solutions primarily in, but not limited to, Tableau, which includes other reporting tools like Superset, etcCreate detailed, interactive reports, intuitive visualizations, and dashboards that provide actionable insights and support decision-making.Develop a perspective on the best way to present statistical information to stakeholders; advocate for that perspective with stakeholders.Perform and document data analysis, data validation, data mapping/design, by accessing multiple sources, specifically data residing in source systemsProvide application analysis and data modeling design to collect data for centralized data warehouseExtract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems

Data Governance: 

Implement processes and standards for data quality, including validation, consistency checks, and error handling.Standardize data collection by developing methods for database design and validation reportsWork with data stewards to ensure data integrity and address data quality issues.Maintain a data catalog to document data sources, definitions, and metadata.Facilitate data discovery and promote transparency in data usage across the organization.Collaborate with governance teams to align BI practices with overall data governance frameworks.Assess and determine governance, stewardship, and frameworks for managing business intelligence across the organization.

Subject Matter Expert and Stakeholder Representative:

The developer is responsible for collaborating with diverse stakeholders to develop new, complex visualizations, often displaying data at multiple levels of granularity meant for different audiences. The developer also needs to be able to help stakeholders understand technical challenges in our database well enough to help them prioritize investing in holistic solutions and paying down technical debt.Partner with instructional, operational, regional, and HO teams to develop reports and address data needs to provide reporting solutionsFacilitate collaboration and communication with internal stakeholders to understand data needs, clarify requirements, and navigate and resolve competing prioritiesUnderstand and represent stakeholders’ goals and use cases to determine the future state of organizational integrationsUnderstand and champion the appropriate long-term vision for BI at UncommonEnsure user adoption of new processes by creating training materials and providing mentorship, guidance, support and performance feedback to end users of our visualizations and data setsIndependently create detailed communication and change management plans for workstreams including simple, creative ways to explain complex information for clear decision-makingAct as point of escalation for issues with visualizationsTrain IT Support team to handle common issuesCollaborate with project managers and business unit leaders for all projects involving integrations

Qualifications

Education Requirements:

Bachelor's Degree required (Computer Science, Information Systems, Business, or equivalent subject preferred)

Experience Requirements:

5-6 years of professional experience3+ years of IT or Data experience 3+ years of experience in the Business Intelligence field and expertise in data-driven dashboard/analytics design, development and implementation Coding in R, Python, and SQLExperience with Tableau, Superset, or similar visualization softwareExperience with DBT or similar data modeling platformPrevious experience in K-12 public education preferred

Travel& Schedule:

3 days in person in our central office located downtown ManhattanLocal travel is expected to school sites and other offices in NY, NJ, and MA. 

Additional Information

Our people are what make us uncommon. It’s important to us that our compensation practices align with our values and enhance our ability to attract and retain talent.  Our compensation philosophy is focused on equity and fairness, retaining our talented staff and valuing their expertise, and transparency and clarity.

Compensation for this position:  Candidates who meet all job description requirements will likely receive an offer of $100,800. The starting compensation for this role is between $95,200 to $112,000.  The starting pay will depend on various factors including but not limited to relevant professional experience, education, certifications, and tenure with Uncommon Schools.  To receive an offer at the top of the range, candidates will need significant experience beyond the job description requirements.  Because we value staff tenure in a role, we do not currently cap salary ranges for current staff members. 

Other Benefits:

19 days of paid time off in addition to three weeks of paid winter and summer org-wide holidaysExtensive, best-in-class training and development  Choice of 3 comprehensive health insurance plansPre-tax flexible spending and health saving accountsFinancial planning & wellness403(b) retirement savings program + employer match529 college savings programPublic Service Loan Forgiveness application assistanceFinancial  planning tools and assistanceDependent Care FSA, back up childcare and daycare discounts, pet care insurancePaid leave of absence Fully paid parental leaveFully paid medical leaveAdditional paid Short Term and Long Term Disability insurance Mental health and counseling support + wellness benefits

Uncommon 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 an exceptional team that reflects the diverse backgrounds and experiences of our students. We also strive to ensure an inclusive community by creating a space for meaningful dialogue about issues of race and identity for our staff and students. As an equal opportunity employer, Uncommon provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. We also ensure that individuals with disabilities receive all privileges and benefits associated with employment and are provided reasonable accommodations for the interview process and to perform core job functions. If you would like to request an accommodation, please email [email protected].

Confirm your E-mail: Send Email