SQL Database Testing Analyst II

3 days ago


Irvine, United States ATTOM Data Solutions Full time
Job DescriptionJob Description

About us
As the leading authority in comprehensive real estate data, ATTOM Data Solutions provides customers a one-stop destination to make better-informed real estate and economical decisions. Recognized nationwide as a trusted industry partner, ATTOM delivers various data products that ensure the accuracy, support, and flexibility required to get the information businesses and individuals need to achieve maximum results.
ATTOM is a fully remote company, with employees located throughout the United States. Currently, we can only accept applicants located in the following states: Arizona, California, Colorado, Connecticut, Florida, Georgia, Idaho, Illinois, Kansas, Kentucky, Nevada, New York, North Carolina, Ohio, Tennessee, Texas, Virginia, and Washington.
 

About the Role
The SQL Database Testing Analyst is responsible for the creation and maintenance of system testing documentation, test case design and execution, defect reporting, and analysis of warehouse data and workflows to ensure the highest level of end-state data quality and to enhance the value that ATTOM provides to our data customers.

What you will do

· Estimate, prioritize, plan and coordinate testing activities

· Create and execute test plans from detailed requirement and design documents

· Create and execute repeatable regression test cases for all data flow processes

· Contribute to design discussions as an advocate for continuous quality improvements

· Report defects and follow through to resolution

· Work with internal teams to understand current processes and areas for efficiency gains

· Collaborate with client-facing teams to provide Tier II support to clients

· Provide data and process expertise in support of requirements development for client-driven data initiatives

· Work with product and development leads to review requirements, specifications and technical design documents to provide timely and meaningful feedback

· Oversee activities of the testing team; review test plans and results, coordinate assignments, and provide feedback as needed.

· Train testing resources on new system development and workflow enhancements as is necessary for successful testing
 

What you need to succeed

· Bachelor’s Degree in computer science or related field

· 3+ years of data analysis experience

· 3+ years of data testing experience

· Strong T-SQL skills

· Ability to read and understand stored procedures and complex queries

· Solid understanding of relational database concepts

· Familiar with SSIS or other ETL tools

· Strong communication skills, written and verbal

· Experience with delegation and coordination of multiple assignments as a team lead

· Change management and task workflow systems (Vault, VSS, JIRA, TFS)

· Prior experience with real estate data is a plus

What we offer
  • Pay range 75-85k (Final salary offered will depend on work location, job-related skills, knowledge, and experience)
  • Flexible work schedule
  • Flexible time off policy
  • Medical, dental, and vision insurance
  • Life and disability insurance
  • Employer-paid benefits
  • Employer-sponsored EAP (Employee Assistance Program)
  • Traditional 401(k) and Roth retirement plans with company match
  • Pet insurance
  • Employee referral bonus
  • Co-working/office membership through Regus
ATTOM Data Solutions is an Equal Opportunity Employer/W/M/Dis. Relocation assistance is not offered for this position.

 

Powered by JazzHR

GSPOksMRSt


  • Logistics Analyst

    4 days ago


    Irvine, United States Plaxonic Technologies Full time

    **Role: - Logistics Analyst** **Location: - Irvine, CA (Onsite)** **Duration: - Long term contract** **Requirements**: - 3+ years using MS Excel, SQL, Python, Jira and Atlassian Products - Experience in Supply Chain or Manufacturing Product Lifecycle Management departments - Experience working with engineering leads to establish acceptance criteria...

  • Quality Analyst

    4 weeks ago


    Irvine, United States Smart Energy Water Full time

    Quality Analyst Apply now SUMMARY SEW Testing team leverages manual & automatic testing to ensure a great product quality during product development and implementation. SEW Testing team is most important arm in company to ensure we identify all the defects and issues before our products being used by end users. We are now looking for a...

  • remote sql dba

    2 weeks ago


    Irvine, California, United States Insight Global Full time

    Job Description Insight Global is searching for a SQL DBA to manage our client's SQL Server, MySQL, MariaDB and Oracle database systems. You will be required to install and maintain database software, create and administer databases including and not limited to -- performance tuning, storage management, backup and recovery, database security, operational and...

  • Logistics Analyst

    2 weeks ago


    Irvine, United States Plaxonic Technologies Inc. Full time

    **Role - Logistics Analyst** **Location - Irvine, CA (Onsite)** **JOB DESCRIPTION** Hours per day - 8 hours usual hours M-F, 8 AM to 5 PM (1 hour non-billable lunch) - Experience in Supply Chain or Manufacturing Product Lifecycle Management departments -Experience working with engineering leads to establish acceptance criteria for development work and...


  • Irvine, United States Global Financial Data, Inc Full time

    As a Database Administrator, you will be a vital part of our team responsible for managing and optimizing our database systems. Your premium skills in MySQL, performance tuning, and scripting will be valuable in maintaining high availability and enhancing database performance. Additionally, your relevant skill in database design will contribute to the...

  • PL/SQL Developer

    3 weeks ago


    Irvine, United States Diverse Lynx Full time

    Role- PL/SQL Developer Location- Irvine, CA (Onsite) Duration- Full time Job Description : Strong SQL and PL/SQL skills Good analytical skills in debugging PL/SQL code. Review of AWR reports and provide recommendations for Database performance tuning. Knowledge on USGAAP Standards of GL accounting and GL setup/transaction processing. Java...

  • PL/SQL Developer

    2 months ago


    Irvine, United States Diverse Lynx Full time

    Role- PL/SQL Developer Location- Irvine, CA (Onsite) Duration- Full time Job Description : Strong SQL and PL/SQL skills Good analytical skills in debugging PL/SQL code. Review of AWR reports and provide recommendations for Database performance tuning. Knowledge on USGAAP Standards of GL accounting and GL setup/transaction processing. Java...

  • Pl/SQL Developer

    2 weeks ago


    Irvine, United States Diverse Lynx Full time

    Roles & Responsibilities: Strong SQL and PL/SQL skills Good analytical skills in debugging PL/SQL code. Review of AWR reports and provide recommendations for Database performance tuning. Knowledge on USGAAP Standards of GL accounting and GL setup/transaction processing. Java Knowledge is plus. Diverse Lynx LLC is an Equal Employment Opportunity employer....

  • Logistics Analyst

    1 week ago


    Irvine, United States Premier Solution Full time

    **Responsibilities**: - Execute the Channel Planning and Analytics strategic plan which will support better service levels with less inventory and optimized safety stocks. - Own master data and inventory parameters for Service Center materials to support stocking to meet the demand forecast, provide excellent fill rates, reduce down-time, and deliver cost...

  • Test Analyst, Wow

    4 weeks ago


    Irvine, United States Blizzard Entertainment Full time

    **Team Name**: Quality Assurance **Job Title**: Test Analyst, WoW **Requisition ID**: R023193 **This role is anticipated to be a hybrid work position, with some work on-site and some work-from-home. The potential home studio for this role is Irvine, CA or Austin, TX. **Team Introduction**: The concept of “Blizzard polish,” that is, the infinite care...

  • Data Analyst

    1 week ago


    Irvine, United States Strategic Employment Partners (SEP) Full time

    We are working with one of the premier software as a service company in Orange County. They are located in the heart of Irvine and are currently looking to add their next Data Analyst. You will be joining an established team, using SQL and related technologies, with a clear growth path for advancement within the company!Desired Skills:Ideally 3+ years using...

  • Data Analyst

    1 week ago


    Irvine, United States Strategic Employment Full time

    Job DescriptionJob DescriptionWe are working with one of the premier software as a service company in Orange County. They are located in the heart of Irvine and are currently looking to add their next Data Analyst. You will be joining an established team, using SQL and related technologies, with a clear growth path for advancement within the company!Desired...

  • Data Analyst

    5 days ago


    Irvine, United States Strategic Employment Full time

    Job DescriptionJob DescriptionWe are working with one of the premier software as a service company in Orange County. They are located in the heart of Irvine and are currently looking to add their next Data Analyst. You will be joining an established team, using SQL and related technologies, with a clear growth path for advancement within the company!Desired...

  • Data Analyst

    1 week ago


    Irvine, United States Strategic Employment Partners (SEP) Full time

    We are working with one of the premier software as a service company in Orange County. They are located in the heart of Irvine and are currently looking to add their next Data Analyst. You will be joining an established team, using SQL and related technologies, with a clear growth path for advancement within the company!Desired Skills:Ideally 3+ years using...


  • Irvine, United States Robert Half Full time

    Robert Half is looking for a experienced BI Analyst with a minimum of 5 years of direct experience. Data Retrieval and Management:and execute SQL queries to retrieve data from SQL Server databases.efficient and effective data retrieval processes that support business intelligence and reporting needs.database connections and optimize query performance to...


  • Irvine, United States City of Irvine California Full time

    The Irvine Police Department is seeking a detail-oriented and dynamic professional who wants to make an impact in writing grant proposals as a Management Analyst II. The ideal candidate has knowledge of Public Safety, experience writing grant proposa Management, Analyst, Technology, Reports, Proposal


  • Irvine, United States EverBank N.A. Full time

    **Bank Fraud Analyst II** The Bank Fraud Analyst II participates in investigations regarding the control, detection and analysis of frauds to eliminate any eventual possibility of financial or image loss to the company. Working under general supervision, this role identifies potential fraud cases and takes appropriate action. **Key Responsibilities and...

  • Test Analyst, WoW

    1 month ago


    Irvine, California, United States Blizzard Entertainment Full time

    Team Name:Quality AssuranceJob Title:Test Analyst, WoWRequisition ID:R023193Job Description:This is a unique opportunity for an experienced World of Warcraft (WoW) player to join our WoW QA team We're looking for a candidate who is as passionate as we are about WoW to improve and influence the game. As a Test Analyst, you will contribute to the testing...


  • Irvine, United States Teknosys Full time

    We are looking for PL/SQL Developer with Postgre SQLExperience : 8 to 10 yearsLocation: Pleasanton, CA Work mode: onsiteNeed candidates on Teknosys W2Skills requiredOracle T-SQL SSRSSSASSSISETLPL/SQLPostgre SQL Database objects


  • Irvine, United States Virtual Full time

    Senior Financial Analyst Consultant (Contract/Consulting Engagement) Location: Irvine, CA Vaco Resources is seeking a highly skilled Senior Financial Analyst Consultant to join our client’s dynamic team in Irvine, CA. This contract-based role is an exceptional opportunity for a seasoned professional who excels in financial modeling, forecasting, and...