Skip to Main Content

Maryland Longitudinal Data System Data Quality Analyst

IT Systems Technical Specialist

Recruitment #23-004488-0018

Go Back View Benefits

Introduction



The Maryland Longitudinal Data System (MLDS) Center develops and maintains a data system that contains student data from all levels of education and workforce data in order to provide analyses, produce relevant information, and inform choices to improve student and workforce outcomes, while ensuring the highest standards of system security and data privacy.

GRADE

State Salary Grade 19
Salary Range: $69,159 – $111,505 
*State Salary Guidelines apply for current State employees.

STATE OF MARYLAND BENEFITS

LOCATION OF POSITION

Nancy S. Grasmick Education Building
200 West Baltimore Street
Baltimore, MD 21201

Main Purpose of Job

The MLDS Center serves the needs of the State of Maryland by developing and maintaining a data system that contains student data from all levels of education and workforce data in order to provide analyses, produce relevant information, and inform choices to improve student and workforce outcomes. This position plans, designs and develops improvements and new system applications across the entire MLDS enterprise for database integration and data warehouse management technology.    

POSITION DUTIES

Quality Assurance and Testing Duties:
  • Create detailed, comprehensive and well-structured test plans and test cases to perform Qualitative Analysis of MLDS center Data. 
  • Liaise with internal teams (e.g. developers and database administrators) to identify test requirements, developing test strategies and methods.
  • Design, develop and execute manual/automation scripts using agency tools or custom code. 
  • Develop and apply testing processes for new and existing data flows to meet MLDS center needs. 
  • For all data loaded into MLDS databases, perform data validation to ensure the data transformation and loading is successful and accurate.
  • Perform qualitative testing on ODS, EDW and DataMart. Monitor debugging process results. Track quality assurance metrics, like open defect counts, bugs, accuracy and completeness.    
ETL Duties:
  • Coordinate with other ETL developers and data analysts to ensure organized, consistent, and accurate ETL processes are developed and followed.
  • Design, develop, and implement ETL mappings using Oracle tools and Informatica cloud.
Other Duties:
  • Create reports, data sets and manage metadata, especially as necessary for end users to effectively understand the system and the organization of the data structure. Stay up-to-date with new testing tools and test strategies.
  •  Performs other assigned duties relating to the analysis and documentation of the MLDS databases.

MINIMUM QUALIFICATIONS

EDUCATION:  Bachelor’s Degree from an accredited college or university in Computer Information Technology, Management Information Systems, Computer Science or other information technology related fields to include coursework in database management systems and writing SQL code.
EXPERIENCE:  Two or more years of experience in testing, qualitative data analysis and data quality assurance is required. Experience in writing comprehensive data testing plans on Structured data in ODS, EDW and Data Marts.
Notes: 
  1. Candidates may substitute graduation from an accredited high school or possession of a high school equivalency certificate and thirty credit hours from an accredited college or university in Computer Science, Computer Technology, Management Information Systems or other information technology-related field to include coursework in database technology, writing code like SQL, PL/SQL and other Relational Database Management system (RDBMS) coding technologies for four years of the required experience.
  2. Candidates may substitute graduation from an accredited high school or possession of a high school equivalency certificate and two year of experience in database technology, writing code like SQL, PL/SQL and other Relational Database Management system (RDBMS) coding technologies for four years of the required experience.
  3. Candidates may substitute U.S. Armed Forces military service experience as a commissioned officer in the Computer Systems Operations classifications or Computer Systems Operations specialty codes in the Information Technology field of work on a year-for-year basis for the required experience.

DESIRED OR PREFERRED QUALIFICATIONS

Preference will be given to applicants who possess the following preferred qualification(s). Please include clear and specific information on your application regarding your qualifications.
  • Expertise in Qualitative Data analysis and data quality assurance. 
  • Knowledge of developing detailed business requirements and including identifying necessary data elements to support various business functions.
  • Knowledge of Oracle tools and Informatica cloud and components of organized, consistent, and accurate ETL processes.
  • Knowledge of the principles and practices of information systems planning, analysis, design, system development life cycle, programming, budgeting, operations and maintenance.
  • Skill in creating, implementing, and maintaining data quality standards for databases and reports. 
  • Skill in preparing narrative reports and feasibility studies of information technology and business functions. 
  • Skill in applying inductive and deductive reasoning to reach logical solutions to data issues.
  • Ability to create and maintain documentation on interagency data file transfer protocols.
  • Ability to establish and maintain quality assurance standards. 
  • Ability to understand complex information technology principles, theories and solutions.
  • Ability to communicate effectively and to establish and maintain effective working relationships with peers, users, and industry specialists.

LICENSES, REGISTRATIONS AND CERTIFICATIONS

NOT APPLICABLE.

SPECIAL REQUIREMENTS

Applicants must consent to State and FBI (CJIS) background check as a routine procedure for all employees.

SELECTION PROCESS

Please make sure that you provide sufficient information on your application to show that you meet the qualifications for this recruitment. All information concerning your qualifications must be submitted by the closing date. Successful candidates will be ranked as Best Qualified, Better Qualified, or Qualified. The resulting list of qualified candidates will be in effect for at least one year.

BENEFITS

FURTHER INSTRUCTIONS

Applicants must complete the MD State Government online application for employment and submit their professional resume. The application and resume must clearly demonstrate that the applicant satisfies the minimum qualifications for the position. Applications must be complete to be considered including all related job duties, even if those are also listed on an attached resume. Additional required materials may be uploaded with the online application, submitted to the fax number, or mailed to the address listed.

If you are unable to apply online, paper applications can be obtained from the link below and be faxed to 410-333-8950 or mailed to MSDE Office of Human Resources, 200 W. Baltimore Street, Baltimore, MD 21201. If there is a supplemental questionnaire, this must be completed and sent in with your paper application. Postmarks will not be accepted.  

Inquiries can be made to 410-767-0019, TDD 410-333-3045. Appropriate accommodations can be made for individuals with disabilities. If you have difficulty with your user account or have general questions about this online application system, please contact the MD Department of Budget and Management, Recruitment and Examination Division at 410-767-4850. TTY Users: Call via Maryland Relay.

Proof of eligibility to work is required in compliance with the Immigration Reform and Control Act. Any misrepresentation of academic or experience requirements for this position may result in non-selection or termination of employment.

As an equal opportunity employer, Maryland is committed to recruiting, retaining, and promoting employees who are reflective of the State’s diversity. Individuals with disabilities and bilingual candidates are encouraged to apply. We thank our Veterans for their service to our country. All application materials must be received in our office by the Closing Date.

Appropriate accommodations for individuals with disabilities are available upon request.



Powered by JobAps