Apply on Employer Site

Montgomery County Public Schools · 4 weeks ago

Immediate: Senior Business Intelligence Developer, Department of Student and Data Systems, 8 hours/12 months, Ad closes on 1/9/2026

Rockville

Full-time

Onsite

Senior Level

5+ years exp

Montgomery County Public Schools is seeking a Senior Business Intelligence Developer to support the development and maintenance of relational and multi-dimensional databases. The role involves working closely with various teams to develop business intelligence solutions, ensuring the security and integrity of enterprise databases, and troubleshooting database issues.

Education

Responsibilities

Develops, implements, maintains relational and multi-dimensional databases and supports Business Intelligence solutions

Participates in developing data models to define enterprise data architecture, administer change controls, and monitor production data loads

Works closely with project management, applications development, System and database administration team, and data warehouse development team

Develops policies and procedures to ensure the security and integrity of the school district's enterprise databases

Develops data transfer programs and processes between disparate systems

Responsible for developing business intelligence dashboards and reports

Troubleshoots and resolves database performance, database capacity, tuning, and other distributed data issues

Works with system administrators for the configuration and selection of database server equipment

Qualification

ETL developmentSQL developmentBusiness IntelligenceDatabase designData modelingMicrosoft SSISMicrosoft SSRSJavaScriptPythonErwin data modelingProblem solvingCommunication skillsInterpersonal skillsOrganizational skills

Required

Highly skilled in relational data modeling, database design, structured programming, object design, and data integrity and validation procedures

Knowledge of relational database theory and techniques, dimensional modeling, and data warehouse solution/design concepts

5 or more years of experience in Extraction, Transformation and Loading (ETL) development using Microsoft SSIS or similar software

Hands-on experience in reports development using Microsoft SSRS or similar software

Knowledge of SQL development tools, JavaScript, Python, and Erwin data modeling tool

Strong quantitative, analytical, communication and interpersonal skills, and the ability to work in a team-oriented environment

Solid problem solving, negotiations, and organizational skills required

Ability to acquire knowledge of and meet the seven core competencies of the Supporting Services Professional Growth System (SSPGS)

Bachelor's degree required

Requires five years of experience with SQL and PL/SQL in SQL Server 2012 or above

Proficient in all stages of Business Intelligence work which includes, but not limited to, developing dimensional data models, writing SQL queries, and building data transfer programs, reports and dashboards using Microsoft technology