Data Quality Assurance Analyst

  • location: Roseville, CA
  • type: Temp to Perm

description

Our client in the Sacramento Area is looking for a Data Quality Assurance Analyst.

Overview:

This role will be responsible for report testing and data validation including

(a) test script development & maintenance

(b) baseline & regression testing

(c) issue resolution tracking,

(d) analytics' report and information support for all departments.

The position will develop and oversee the business intelligence data validation; maintain the issue tracking and testing documentation; and ensure standards adherence in calculations, report formats and documentation.

DUTIES:

  • Develop test plans/cases for validating reporting / data functional, performance and business requirements.
  • Document test findings: debug reports, test summaries, product evaluations to determine report / information release readiness
  • Partner with the BI team and associates in Compliance, Operations, Sales as well as other departments to flush out report issues against the business requirements and the department's standards
  • Subject-matter expert (SME) on data definitions and reporting standards

    • Maintains the data definitions and reporting standards for the department
    • Ensures adherence to these definitions / standards in the information generated by the department (i.e. how are standard calculations performed)
  • Drive improvements in the analytics department including enhancing reports' speed and capabilities, streamlining processes, deploying new tools and other activities
  • Acquire a deep understanding of the reporting data to facilitate testing, establishing baseline data sets, and assist in development
  • Conduct frequent audits to ensure that the reports continue to perform to spec and underlying data in line with expectations
  • Support analytical information needs via other duties and special projects as required

REQUIREMENTS:

  • 7+ years of quality testing work (very strong knowledge of test script development; baseline development; unit & regression testing; and quality standards adherence)
  • 3+ years of testing for reporting / information development environments
  • Mastery of Microsoft Excel is required (including but not limited to: advanced formulas, nested statements, and data manipulation centered on date and time data)
  • Outstanding capability in documentation, especially in using MS Word, Confluence or other documentation tool
  • Maintains high standards when identifying issues and seeking resolutions
  • Exceptionally detailed orientated and cross-checks work to user specifications
  • Advanced problem solving and analytical skills
  • Ability to quickly understand business requirements and ensure the information output is meeting/exceeding user requirements
  • Seeks alternative ways to solve problems (can arrive at solutions via alternate routes)
  • Excellent written and verbal communication skills, with the ability to clearly explain technical issues to a non-technical audience
  • Exposure to T-SQL (simply query writing)
  • Proficient working independently-with little direction-and as a supportive team member
  • Comfortable working with business partners across the organization
  • Accustomed to fast-paced environments with simultaneous, high-priority tasks
  • Working knowledge of MS Office (including Excel, Outlook, PowerPoint, Visio, & Word)
  • B.S. degree in Computer Science, Information Systems, Decision Sciences, or a related business degree and / or equivalent experience

Nice to have:

  • Working in a Software Development Lifecycle (SDLC) environment and using related tools
  • Proficiency with T-SQL, specifically table structures, stored procedures, queries and joins
  • Issue tracking software (ServiceDesk, JIRA, etc)

get jobs in your inbox.

sign up
{{returnMsg}}

related jobs

    Customer Service

  • location: Roseville, CA
  • job type: Temp to Perm
  • salary: 16 per hour
  • date posted: 1/25/2018


    Administrative Assistant

  • location: Roseville, CA
  • job type: Temp to Perm
  • salary: 13 - 20 per hour
  • date posted: 2/1/2018