The Data Quality Engineer will be responsible for designing, developing, documenting and performing data quality checks across all data assets developed at Envoy. That includes ETL jobs, reports, dashboards and data pipelines. The primary goal for this role is to ensure high quality of data delivered to internal stakeholders and customers. Validation of data in data repositories (DW, Data Marts) against data from source systems and validation of metrics and data in reports/dashboards against data in the repositories is a key responsibility. Essentially, making data assets consistently accurate for users.
As the successful candidate, you will be required to:
- Design, develop and maintain data quality assurance framework
- Work in conjunction with BI and Data Engineers to ensure high quality Data Deliverable
- Design and develop testing frameworks to test ETL jobs, BI reports and Dashboards and other data pipelines
- Write SQL scripts to validate data in the data repositories against the data in the source systems
- Write SQL scripts to validate data surfacing in BI assets against the data sources
- Ensure data quality by checking against our ODS and the front-end application
- Track, monitor and document testing results
To be eligible for this role, you should possess the following:
- Demonstrated ability to write complex SQL/TSQL queries to retrieve/modify data
- Ability to work in an Agile environment
- Ability to learn new tools and technologies and adapt to an evolving tech-scape
Envoy Global is an equal opportunity employer and will recruit, hire, train and promote into all job levels the most qualified applicants without regard to race, colour, religion, sex, national origin, age, disability, ancestry, sexual orientation, gender identification, veteran status, pregnancy, or any other protected classification.
Follow Cutshort