What are the responsibilities and job description for the Senior Business Intelligence Developer position at Montgomery County Public Schools?
Job Details
This position requires the candidate to work primarily on-site in Rockville, with some flexibility for remote work as needed.
SUMMARY DESCRIPTION:
Under general supervision, 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.
CERTIFICATE LICENSE:
DBA/Business Intelligence certification preferred..
KNOWLEDGE, SKILLS, and ABILITIES:
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).
EDUCATION, TRAINING, and EXPERIENCE:
Bachelor's degree required. Master's degree preferred. College course work in data processing, and specialized training in relational database management systems, including data warehouse development, database administration, performance tuning, troubleshooting, and programming in a networking environment. Requires five years of experience with SQL and PL/SQL in SQL Server 2012 or above. Experience in Oracle 10g or above is a plus. 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 Experience with Analytics and OLAP cube development specifically with Microsoft SSAS and MDX development desirable. Other combinations of applicable education, training and experience that provide the knowledge, abilities, and skills necessary to perform effectively in the position will be considered.
Please note that candidates will be expected to complete in-person written technical assessment at Rockville, Maryland office as part of the hiring process.
