Extended: FY27: Extraction Transformation & Load (ETL) Analyst Programmer, 8 hrs/12 mos, Ad clo[...]

Montgomery County Public Schools; Rockville (MD); On-site; USD 55,000 - 79,000; Full time

Job summary

Montgomery County Public Schools in Rockville, MD, seeks an experienced Data Warehouse and ETL Developer to join in-person. You will design and maintain dimensional data models, develop and optimize ETL processes using SQL Server technologies (SSIS/SSRS/SSAS), and support reporting, analytics, and data quality across the enterprise.

You will translate business requirements into technical specs, monitor production loads, perform testing, and provide production support.

Qualifications

• Bachelor's degree required.
• Masters degree preferred.
• Experience designing, programming, maintaining and tuning ETL processes.
• Experience monitoring ETL production jobs and creating system requirements and test plans.
• Excellent communication and time-management skills.

Responsibilities

• Design and maintain dimensional data models.
• Develop and optimize ETL processes.
• Support enterprise data warehousing, reporting and analytics solutions.
• Translate business requirements into technical specifications.
• Perform data validation, reconciliation and testing.
• Provide production support and manage interfaces to source systems.

Education

Bachelor's degree

Master's degree

Tools

SSIS

SSRS

SSAS

SQL

Dimensional Data Modeling

Job description

Summary Description

Works closely with project management and data warehouse development teams, creates and maintains multi-dimensional data models defining the data warehouse Extraction Transformation and Load (ETL) architecture, designs and codes ETL processes, administers change controls and processes, and monitors production data loads. Translates requirements into detailed specifications, and develops and documents business processes and data requirements. Monitors ETL performance tuning production data loads, controls ETL tool releases, conducts system and acceptance testing, provides production support, implements interfaces to source systems, and balances target to source data. Physical Demands: Must operate computer work stations for sustained periods, lift and move PC equipment. Special Requirements: Some overtime, evening and weekend work required.

Job Specific Information

This is an in-person position. Experienced Data Warehouse and ETL Developer with expertise in Microsoft SQL Server technologies, including SSIS, SSRS, SSAS, and SQL. Skilled in designing and maintaining dimensional data models, developing and optimizing ETL processes, and supporting enterprise data warehousing, reporting, and analytics solutions. Proven ability to translate business requirements into technical specifications, implement data integration solutions, perform data validation and reconciliation, conduct system and user acceptance testing, and provide production support. The wage range for this position is a salary between $39.92 p/h and $57.29 p/h based position responsibilities. For information about benefits, please follow this link. https://drive.google.com/file/d/1nCKtJEqy4w4SLTzmvmVXgE8hPfOBolkb/view

Job

Information Technology

Job Grade

25

Organization

Offices

Primary Location

Rockville

Schedule

Full-time

Working Months

12

Shift

Day Job

Job Posting

Aug 27, 2026, 11:00:00 PM

Knowledge Skills Abilities

Strong technical, analytic, and problem-solving skills including: dimensional data modeling, structured batch programming, proficiency in database principles, the appropriate database platforms as they relate to database operations, software change control and data warehouse data load integrity and validation procedures. Ability to tune ETL performance, to work independently and cooperatively within a team working under severe time constraints, and to develop and implement a test plan. Requires skill in completing program and system documentation, good oral and written communication skills, and excellent time management skills. Knowledge of and the ability to meet the seven core competencies of the Supporting Services Professional Growth System (SSPGS).

Education Training Experience

Bachelors degree required. Masters degree preferred. Experience in designing, programming, maintaining and tuning ETL processes; in monitoring and troubleshooting ETL production jobs; and in creation of system requirements and test plans; familiarity with database warehouse architecture and performance issues in a large database system; with database programming tools, SQL, data modeling tools, and database access tools; excellent communication skills, and ability to learn business practices and concepts required. Other combinations of applicable education, training, and experience which provide the knowledge, abilities, and skills necessary to perform effectively in the position may be considered.

Certificate License:None