TAJUbbRqavw n6xqqgXVz - BI and Front-End — Detroit, MI
Зарплата не указана
ОткликнутьсяJob Description
Job Title
Position Title: Application Developer - BI and Front-End
Location: Office of Strategy, Data and Accountability
Salary: $84,387 - $114,526
Reports to: Deputy Executive Director of Data Services¿
Bargaining Unit: N/A
Benefits Eligible: Yes.
Telecommuting Eligibility: Eligible for telecommuting up to 40% (2 days per week)
Position Summary
j3E JbBheQRkXTA ARFBA4eJ4 - BI and Front-End maintains the district's Power BI reporting and builds data visualizations in district web applications, for a district of more than 50,000 students. KCf role owns the district's semantic models, data access rules, and report deployment. KCf developer also leads a high-priority project to build and maintain personalized data portals for students and staff, in SharePoint and in the Hub, a single-page web application. KCf developer works with the Data Services team's data engineers, business analyst, and analyst, and with the school and central office staff who use the reports. Data engineers deliver the source data. KCf developer owns everything from the semantic model to the screen.
Minimum Qualifications
• A Bachelor's degree, preferably in a technical area, or equivalent technical experience.
• Four (4) or more years of experience building and maintaining Power BI solutions in production, including semantic models, DAX, and Power Query.
• Experience implementing and maintaining row-level security and role-based access to data for groups with different data permissions (for example, students and teachers), in a BI tool such as Power BI, in a database, or in an API that serves a web application.
• Advanced proficiency in SQL for querying and transforming large datasets with millions of rows.
• Experience administering Power BI Service workspaces, including scheduled refresh, gateways, access, and promoting changes between development and production.
• Microsoft certification PL-300 (Power BI Data Analyst) or a comparable BI or front-end development certification. (preferred)
• Experience embedding Power BI reports in SharePoint or web applications, using the Power BI JavaScript API, Power BI Embedded, or SharePoint Framework (SPFx) web parts, or building data visualizations in web applications with REST APIs and a JavaScript charting library such as D3, Vega-Lite, or Recharts. (preferred)
• Front-end development experience with JavaScript or TypeScript, HTML, and CSS, such as React or SPFx. (preferred)
• Experience managing Power BI files in version control (for example, Git with PBIP files) or with deployment pipelines. (preferred)
• Experience using AI coding assistants, practicing strong discernment when reviewing outputs, while keeping student data out of tools not approved to hold it. (preferred)
• A portfolio or examples of reports or web interfaces designed for non-technical users. (preferred)
• Experience designing reports or web pages to WCAG 2.1 or 2.2 accessibility standards. (preferred)
• Experience working in an urban public-school district. (preferred)
• Ability to define business requirements and lead communication with stakeholders, from principals and teachers to district leaders. (preferred)
• Advanced dimensional modeling experience, including star schema design, and building a shared semantic or metrics layer that several reporting tools use. (preferred)
Essential Functions
• Maintain and improve the district's existing Power BI reports, semantic models, and refresh schedules, and resolve data, access, and performance issues.
• Design, test, and maintain data access rules so each student, teacher, and administrator sees only the data they are permitted to see, in Power BI reports, the Hub, and other district web applications. Enforce the rules at the data source or API where possible, so every tool applies the same permissions. Document the access model.
• Own each district reporting solution, in Power BI or the Hub, for as long as it is in use: its accuracy, documentation, user access, refresh monitoring, and retirement when it is no longer needed. Release new work and changes through version control and staged releases.
• Gather requirements from users and build wireframes and prototypes.
• Build and manage student- and staff-facing data portals in SharePoint and the Hub, with clear navigation and current performance metrics.
• Create accurate data displays that communicate district metrics and KPIs.
• Optimize SQL queries, DAX measures, and model design so reports stay fast as data and users grow.
• Build efficient, reusable semantic models for district-wide reporting.
• Integrate reports and visualizations into SharePoint, the Hub, and other web applications, and manage embedding, authentication (Microsoft Entra ID), and licensing so they perform well for thousands of users.
• Set and apply standards for data visualization, accessibility, and user experience across district reports. Reports and portals meet WCAG 2.1 AA or higher.
• Use district-approved AI tools to speed up development. Handle student data in those tools only as the district's data agreements allow, and review AI-generated code, DAX, and SQL before release.
• Facilitate design-oriented focus groups with principals, teachers, and administrators to ensure data tools meet the practical needs of school-based staff.
• Standardize technical documentation for business rules and metric calculations to ensure transparency for both internal and external stakeholders.
• Advise the Deputy Executive Director of Data Services on the reporting and visualization roadmap, licensing, and architecture.
• Perform other duties as assigned by manager.
Security Clearance
Internal Applicants
If you are a current nmUwHWE UVkKAW SZHQszF Kn3zBM3hW YZJjqbVg employee, you do not have to submit to a new security clearance, unless your new role requires a different type of criminal background check.
External Applicants
In alignment with Michigan law, if you are hired to fill a position, you will be required to submit to a nmUwHWE UVkKAW SZHQszF Kn3zBM3hW YZJjqbVg criminal background check. Information regarding required background checks will be shared at point of hire.
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 nmUwHWE UVkKAW SZHQszF Kn3zBM3hW YZJjqbVg 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 (••••••••
DPSCD does not discriminate on the basis of race, color, national origin, sex, disability and/or religion. Contact the Civil Rights Coordinator for more information at (••••••••or ••••••••