Data Quality Engineer
Data Quality Engineer
Job Summary
The Data Quality Engineer will be responsible to 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.
Responsibilities:
- 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
Requirements:
- Bachelor's in Computer Science or a related field (hands-on experience trumps)
- 2+ years of experience as a Data Engineer or a related role
- 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
Nice to have:
- Master’s in Management Information Systems or similar
- Knowledgeable in Data Modeling and Data warehouse concepts
- Experience with visualization tools such as Power BI, Tableau, SpotFire, TIBCO, QlikView, MicroStrategy, Information Builders, and other reporting and analytical tools is a plus
Why Envoy?
- Convenient Chicago Loop location – 2 blocks from Metra trains and the CTA
- Extremely competitive benefits plan including BCBS medical coverage, employee dental and vision coverage
- A company-matched 401k plan that vests immediately
- Stock options after one year of employment
- Annual accrual of 18 days of paid time off (PTO), 2 personal days, and 10 paid holidays per year
- Paid Parental Leave Program
- Casual work environment
- In-office company-paid gym membership with LifeStart Gym
- Company sponsored lunches, happy hours, and events throughout the year
- Healthy snacks & unlimited LaCroix
- Built In Chicago's 2020 Best Places to Work
- Chicago Innovation Award Winner 2019
- ITA Industry Disrupter Winner 2019
- Monthly Product Lunch & Learns and ongoing Career Development/Training
- Growing social responsibility programs & partnerships
- Opportunity to work for an organization that changes lives every day!
Envoy Global is an equal opportunity employer regardless of race, color, religion, creed, sex, marital status, national origin, disability, age, veteran status, on-the-job injury, sexual orientation, political affiliation or belief.
EOE AA M/F/Vet/Disability