Data Quality Assurance Analyst

  • San Diego Association of Governments - SANDAG
  • 349 views
Full Time Government

Job Description

Office of Quality Assurance

The Data, Analytics, and Modeling Department provides SANDAG member agencies, elected officials, other organizations, and the public with information and technical resources for regional planning, funding, and policymaking efforts. The department represents a broad range of expertise from land use and transportation modeling, programming and website development, applied social research, public safety, demographics, and economics, and quality assurance. The information the department gathers, analyzes, produces, delivers, and maintains is essential to the success of SANDAG.

The Office of Quality Assurance provides independent verification of data acquired or produced by SANDAG modeling, forecasting, analysis, mapping, and visualization efforts. In all, there are 70 terabytes of data stored in 200 databases, and the data comes from over 80 sources. The current focus is on developing and implementing formalized policies, processes, and safeguards consistent with best practices and industry standards.


Data Quality Assurance Analyst Role

The Data Quality Assurance Analyst will design and perform data testing and validation functions and contribute to the enhancement of policies, processes, and documentation for various types of data acquired or produced by the agency’s modeling, forecasting, analysis, and mapping efforts. By working with a small team, and collaborating with department colleagues, the Data Quality Assurance Analyst ensures the integrity, validity, and credibility of data flowing into and out of various spatial and non-spatial databases.


Job Responsibilities

This position is best suited for a data quality assurance/quality control professional with experience in data analytics and complex query development. We anticipate career development will occur while working on the types of duties and responsibilities described below and through mentoring and close collaboration with agency executives. Examples of primary responsibilities include:

  • Analyze and validate regional economic, demographic, land use, and transportation data for use in operational, procedural, and policy decision-making activities; interpret multi-disciplinary data demonstrating a thorough understanding of issues that could affect the validity and reliability of information.
  • Design, develop, and perform robust quality assurance testing and analysis of regional data; apply analytical and problem-solving skills to identify and report data anomalies, identify root cause patterns, and facilitate resolutions to issues.
  • Develop complex queries to examine existing or prospective datasets; develop and implement test approaches, automated tests, test environment requirements, and data strategies; identify risks and problem areas and recommend standards, policies, and procedures to correct deficiencies.
  • Create and maintain documentation related to data compliance, business rules, data flows, process flows, and reporting.
  • Coordinate the preparation of metrics and statistical reports, perform audits, and complete special studies; prepare spreadsheets, charts, and graphs to support information sharing.
  • Participate in the maintenance and documentation of comprehensive computerized databases in SQL Server, Excel, and Access formats.
  • Participate on inter-departmental and interagency teams assembled for various agency projects.
  • Prepare and present written, oral, and visual reports and recommendations to various teams and upper management.


Experience and Qualifications

Numerous factors contribute to an individual’s ability to be successful in any given role. For this position, we are searching for a candidate with an aptitude for analytical thinking and problem solving who is organized, flexible, and can be relied upon to meet deadlines while working on multiple projects. Excellent communication skills, the ability to work collaboratively, and the use of sound judgment are important.

The minimum education, training, and experience qualifications include a bachelor’s degree with major course work in computer science, management information systems, regional planning, geography, demography, economics, statistics, mathematics or a related field, and one to four years of professional quality assurance, data analysis, database, and programming experience.

The following information describes the specific types of career experiences that are most relevant to this position:

  • Knowledge of quality assurance and quality control practices used for validating data and ensuring data integrity, including statistical analysis and sampling techniques, preferably for demographic and economic data.
  • Experience with data analysis and research methodologies; knowledge of data acquisition and quality control methods used for gathering and compiling various types of information; knowledge of factors that contribute to the reliability and integrity of collected data.
  • Ability to understand, simplify, statistically analyze, and effectively interpret data and report problems through written and/or graphical formats in a highly complex and data-centric environment.
  • Experience analyzing, organizing, interpreting, and exploring data with the ability to discover patterns, meaningful relationships, anomalies, and trends.
  • Experience performing complex dataset queries, to include developing and maintaining various tests and data strategies for risk identification and highest quality data standards assurance.
  • Demonstrated computer software proficiency using the Microsoft Office Suite especially Excel and Access, SharePoint or other collaboration portal systems, SQL Server or other relational database management system; knowledge of database construction, management, and retrieval methods.
    Programming experience in SQL, R, Python, Java, or other language.
  • Experience using Business Intelligence/Information Sharing software (Power BI, Tableau, etc.) to create reports and dashboards.
  • Experience participating in multi-disciplinary project teams and providing expertise regarding quality assurance and quality control practices.
  • Familiarity with the principles, practices, and objectives of regional planning and forecasting.
  • Familiarity with formalized data governance processes and procedures.
  • Demonstrated ability to establish and maintain effective working relationships with those contacted in the course of work.
  • Experience communicating highly technical information effectively, both orally and in writing; to a broad range of audiences; ability to prepare and deliver findings, presentations and recommendations regarding various analytical efforts to management, partner teams, and other audiences.
  • Excellent organizational skills and the ability to manage several concurrent projects at various stages of completion; ability to establish and maintain priorities and work independently.
  • The selected candidate can anticipate a driving record check upon hire, and approximately annually thereafter. The results of the check may determine whether the selected candidate will be permitted to drive for SANDAG business.


Salary and Benefits

SANDAG rewards the efforts of its employees with a comprehensive compensation package. Competitive salaries are supplemented with a flexible offering of health, financial security, and time-off benefits to meet the work and life needs of employees and their families.

This position will be filled at the Analyst I, II, or Associate level depending on qualifications and experience of the selected candidate. Positions at the Analyst I and II level are considered entry-level; at the Associate level, employees are expected to independently coordinate more complex functions. The annual salary ranges are: Analyst I - $48,552 to $77,635 per year; Analyst II - $53,496 to $85,593 per year; Associate Analyst - $58,979 to $94,366 per year.

Our benefits include traditional health, dental, and vision insurance as well as employee assistance, wellness, and work/life balance programs. Retirement and financial security benefits are provided through a pension plan and deferred compensation program. And to support the need to rest and rejuvenate, employees are provided with a bank of paid time off in addition to paid holidays.


How to Apply

We encourage all interested candidates to apply for this position by completing a SANDAG Employment Application form. Resumes, cover letters, and work samples may be submitted in addition to the Employment Application but are not a substitute for this document.

The Employment Application can be downloaded in PDF format from the SANDAG website. Alternatively, a copy can be requested by calling (619) 699-1900 or emailing hr@sandag.org. Completed applications and related materials can be submitted via email, fax, regular mail, courier, or delivered by hand. See our Careers / How to Apply webpage for additional information.

This position is Open until Filled. The first review of applications will begin on Friday, March 8, 2019.

In compliance with the Americans with Disabilities Act (ADA), SANDAG will accommodate persons who require assistance in order to apply for a position at SANDAG. Applicants requiring an accommodation due to a disability during any stage of the recruitment and selection process, including requesting this document and related application materials in an alternative format, should make their needs known by contacting Human Resources at (619) 699-1900, (619) 699-1904 (TTY), fax (619) 699-6905, or hr@sandag.org.


Additional Application Requirement

To help us further evaluate the skills and experience of individuals interested in this position, applicants are asked to respond to the Supplemental Questions below. The information can be up to 500 words and should be submitted with the Employment Application. This is considered a required component of the application; applications received without a response will be screened out of the selection process.

Supplemental Questions

  1. Describe a project that demonstrates your experience working with different departments to assist with developing requirements and performing data QA/QC analysis. Explain your role in the project and the steps you took to ensure its success.
  2. Describe your approach to data analytics and provide an example of the techniques and tools you use to perform analysis and present the findings.


Candidate Selection and Notification

Following the first review date for applications, all candidates will receive written confirmation that their application was received. The hiring manager will begin reviewing and evaluating applications within a few days of the first review date. The best qualified candidates will be invited to continue in the selection process. All candidates will receive written notification as to the final outcome of their application.


Further Information

The SANDAG website contains a wealth of information about our various project and program areas. The Careers section of the site lists all of our current Job Openings as well as information on how to apply for positions and Frequently Asked Questions about our recruitment process.

In compliance with the Immigration Reform and Control Act of 1986, applicants hired by SANDAG must show acceptable proof of identity and evidence of authorization to work in the United States.


SANDAG is an Equal Opportunity Employer

Occupations

Data Processing, Database Administration

Education Requirements

Bachelor's Degree

Salary

Analyst I - $48,552 to $77,635 per year; Analyst II - $53,496 to $85,593 per year; Associate Analyst - $58,979 to $94,366 per year.