What are the responsibilities and job description for the Extraction Transformation & Load (ETL) Analyst 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:
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.
CERTIFICATE LICENSE:
None
EDUCATION, TRAINING, and 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.
Please note that candidates will be expected to complete in-person written technical assessment at Rockville, Maryland office as part of the hiring process.
