Data Quality Engineer

Overview

The Data Quality Engineer is responsible for designing, developing, documenting, and performing data quality checks across all data assets. 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 against data from source systems and validation of metrics and data in reports/dashboards against data in the repositories is a key responsibility to ensure data assets are consistently accurate for users. The Sr. Data Quality engineer will engage in all data related activities such as data profiling, cleansing, deduplication, standardization, and conversion.

Core Responsibilities

• Work in conjunction with Developers and Data Engineers to ensure high quality Data Deliverable
• Working with the development teams from different groups in the organization, help identify inconsistent data patterns, and how they are manifested from the source processes.
• Design, implement and use data quality assurance frameworks to support the process of identifying inconsistent data patterns.

• Perform ongoing monitoring and refinement of the Data Lakehouse.
• Maintain data standards, enforce standard development protocols, and analyze requirements to ensure technical and standard operating procedure impacts are considered.
• Limit non-standard solutions and escalate when used with documentation supporting exception requirements.
• Assist report writers and data visualization and team members with data sourcing.

Skills Qualifications

Required: 

• Strong  understanding and experience in development activities for all aspects of Software Development Cycle (SDLC). Data Vault Methodologies (nice to have)
• Excellent problem solving and critical thinking skills
• Effective communication skills with an ability to explain technical concepts to developers, product managers, and business partners. 
• Knowledge and experience with database design principles including referential integrity normalization, and indexing to support application development 

Preferred:

• Understanding of ETL methodologies and Data Quality principles, approaches, technologies, and architectures including the concepts, designs, andusage of data warehouses and data marts.

Education

Required:

• Bachelor’s degree or master’s degree in a quantitative field such as Computer Science and Information Systems, Database Management, Big Data, Data Engineering, Data Science, Applied Math, etc.
• 5+ years of professional data analytics working experience. Experience with automotive data is a plus

Preferred:

• 3+ years of experience working with large data and variety of data sources.
• Experience working in virtualized cloud environment including cloud-based IaaS/SaaS/PaaS solutions
• Experience in Power BI, and SQL

Compensation

The wage range for this role takes into account a broad array of factors that are considered in making compensation decisions, including but not limited to: skill sets; experience and training; licensure and certifications; and other business and organizational needs.  The range below applies as long as the work is performed in Connecticut; the Knights of Columbus reserves the right to adjust the wage range if the position is performed in another location.  At the Knights of Columbus, it is not typical for an individual to be hired at or near the top of the range for their role, and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is $140,900-$172,400.

Authorization to work in the United States is required

Physical Demands