Data Quality Analyst
ARCHIVED
We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.
Data Quality & ETL Validation Analyst The client's data and analytics team works across the organization to ensure investments are grounded in evidence and measurable outcomes. The team fosters a culture of data-driven decision-making by building a clear understanding of programs, the evidence associated with those investments, and by generating new insights through program evaluation and an enterprise data analytics platform. The Data Quality & ETL Validation Analyst works with the client's data team to complete the migration of a legacy data system from an on-premises server to the Google Cloud Platform (GCP) environment. Working directly with the Chief Evaluation Officer, the Data Quality & ETL Validation Analyst leverages expertise in GCP, data systems, and modernization projects to perform rigorous testing of migrated data to ensure standards and requirements are met and the data has been migrated successfully. The Data Quality & ETL Validation Analyst works directly with the client's internal technology team to perform testing.
Duties and Responsibilities:
Below is a list of responsibilities that—while not comprehensive—provides an overview of the duties of the Data Quality & ETL Validation Analyst:
- Provide user acceptance testing of newly migrated system, running queries and validating results
- Promptly communicate any issues uncovered during testing to the data and technology teams
- Monitor and provide any support needed to the technology team to ensure all identified issues are resolved in a timely manner
- Ensure data quality, reliability, and performance across the system
- Ensure all business requirements are met
- Other related duties as assigned
The Data Quality & ETL Validation Analyst reports to the Chief Evaluation Officer.
Skills and Qualifications:
- Expertise in the full data lifecycle, including data discovery, collection, management, and analysis
- Experience with relational databases, including those housed in Microsoft SQL Server, Google Cloud Platform, and BigQueryExperience interpreting and applying business rules
- Extensive experience in system user acceptance testing, interpreting business requirements, and database administration
- Strong verbal and written communication skills, as well as the ability to bridge the gap between data science, business management, and technical development and operations
- Familiarity with project management software like Jira
- Expertise querying databases and using statistical computer languages such as SQL and familiarity with R, Python, and Stata programming languages
- Strong situational analysis and decision-making abilities
- Ability to think strategically, problem-solve, juggle multiple priorities, and remain attentive to details
- Demonstrated project management and organizational skills
- Ownership of results, with a standard for excellence
- Bachelor's Degree and 2+ years' experience in database management of on-premise and cloud data systems and implementation of business requirements and best practices for user acceptance testing
- Google Cloud Professional Data Engineer certification or equivalent preferred