Developer, Business Intelligence

$95,200 - $112,000/Yr

Uncommon Schools - New York, NY

Full-time - Mid Level

New York, NY

51-100 employees

Educational Services

About the position

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 of 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. In the realm of Product Management and Development, the Developer will examine and interpret complex datasets to identify trends, patterns, and insights. They will synthesize and translate instructional and business data needs into creative visualizations and tools, developing, maintaining, and managing advanced reporting, analytics, dashboards, and other BI solutions primarily in Tableau, along with other reporting tools like Superset. The Developer will create detailed, interactive reports, intuitive visualizations, and dashboards that provide actionable insights and support decision-making. They will also develop a perspective on the best way to present statistical information to stakeholders and advocate for that perspective. In terms of Data Governance, the Developer will implement processes and standards for data quality, including validation, consistency checks, and error handling. They will standardize data collection by developing methods for database design and validation reports, working with data stewards to ensure data integrity and address data quality issues. The Developer will maintain a data catalog to document data sources, definitions, and metadata, facilitating data discovery and promoting transparency in data usage across the organization. As a Subject Matter Expert and Stakeholder Representative, the Developer will collaborate with diverse stakeholders to develop new, complex visualizations, often displaying data at multiple levels of granularity meant for different audiences. They will help stakeholders understand technical challenges in the database to prioritize investing in holistic solutions and paying down technical debt. The Developer will partner with instructional, operational, regional, and Home Office teams to develop reports and address data needs, ensuring user adoption of new processes by creating training materials and providing mentorship, guidance, support, and performance feedback to end users of visualizations and data sets.

Responsibilities

• Examine and interpret complex datasets to identify trends, patterns, and insights.
• Synthesize and translate instructional and business data needs into creative visualizations and tools.
• Develop, maintain and manage creative advanced reporting, analytics, dashboards and other BI solutions primarily in Tableau and other reporting tools like Superset.
• Create 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 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.
• 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 reports.
• Work 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.
• Collaborate with diverse stakeholders to develop new, complex visualizations meant for different audiences.
• Help stakeholders understand technical challenges in our database to 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.
• Facilitate collaboration and communication with internal stakeholders to understand data needs, clarify requirements, and navigate and resolve competing priorities.
• Understand and represent stakeholders' goals and use cases to determine the future state of organizational integrations.
• Champion the appropriate long-term vision for BI at Uncommon.
• Ensure 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 sets.
• Independently create detailed communication and change management plans for workstreams including simple, creative ways to explain complex information for clear decision-making.
• Act as point of escalation for issues with visualizations.
• Train IT Support team to handle common issues.
• Collaborate with project managers and business unit leaders for all projects involving integrations.

Requirements

• Bachelor's Degree required (Computer Science, Information Systems, Business, or equivalent subject preferred).
• 5-6 years of professional experience.
• 3+ 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.
• Proficiency in coding in R, Python, and SQL.
• Experience with Tableau, Superset, or similar visualization software.
• Experience with DBT or similar data modeling platform.
• Previous experience in K-12 public education preferred.

Nice-to-haves

• Experience with data governance frameworks.
• Familiarity with educational data systems and standards.

Benefits

• 19 days of paid time off in addition to three weeks of paid winter and summer org-wide holidays.
• Extensive, best-in-class training and development.
• Choice of 3 comprehensive health insurance plans.
• Pre-tax flexible spending and health saving accounts.
• Financial planning & wellness.
• 403(b) retirement savings program + employer match.
• 529 college savings program.
• Public Service Loan Forgiveness application assistance.
• Financial planning tools and assistance.
• Dependent Care FSA, back up childcare and daycare discounts, pet care insurance.
• Paid leave of absence.
• Fully paid parental leave.
• Fully paid medical leave.
• Additional paid Short Term and Long Term Disability insurance.
• Mental health and counseling support + wellness benefits.