Data Quality Engineer

Location: 

New Haven, CT, US, 06510

Category:  Information Technology

Feel Good About Doing Good

The Knights of Columbus is a tax-exempt Catholic fraternal benefit society that provides financial security to members and their families through our life insurance, long-term care insurance, disability income insurance, investment and annuity products. Charity is at the core of our missions: our profits are donated to help those in need and to support our faith - $1.73B over the past ten years.

 

While we have many employees who are not Catholic, we follow the Church’s teachings in our investment strategies and our employee benefits. As part of our religious mission, we support the pro-life cause by contributing to the March for Life and pregnancy resource centers, we oppose assisted suicide and euthanasia, we are evangelists for the Catholic faith, and we help Christians who are facing religious persecution in the Middle East.  We all work together to support our two million members as they volunteer to help others in their parishes and communities around the world.

 

Share Your Talent. Live Your Purpose.

We are a growing and purpose-driven community of professionals. Join us to discover how you can meet your goals and ours!

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.
  • Analyze complex data systems to develop automated and reusable solutions for extracting requested information while assuring data validity and integrity.
  • Perform tasks spanning the full lifecycle of data management activities including but not limited to defining completeness, accuracy, and consistency specifications by data element, writing scripts, and developing tools to monitor quality, developing impact analysis, building data lineage to downstream reporting and analytics, building defining and implementing controls for key data quality measures, and producing interactive data quality dashboards.
  • Derives data management structures and metadata to support consistency of information retrieval, combination, analysis, pattern recognition and interpretation, throughout the organization.
  • 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

KofC Cares

Our mission is focused on family and faith, and we support our employees in seeking a balanced life.

 

Employee benefits include:

 

Time Away: 13 paid holidays per year in addition to vacation and paid sick leave, and flexible workweek schedules.

 

Professional Development: Certifications, designation, and tuition reimbursement.

 

Retirement Benefits: 401(k) retirement savings plan with matching company contributions, and cash balance retirement plans fully funded by the company.

 

Health and Wellness:

 

  • Short-term disability and term life insurance fully paid for by the company;
  • Up to 12 weeks of childbirth leave under STD policy.
  • One week of fully paid parental leave for all new parents, including adoptive and foster parents.
  • A variety of health insurance options, including premium-level family coverage and a pre-tax Health Savings Account with employer contributions. The Order's health plans do not cover abortion, sterilization, or contraception, and the Order has helped advocate for other employers who do not want to provide coverage.
  • Long-term disability insurance;
  • Dental insurance;
  • Vision insurance;
  • Health club membership reimbursement;
  • Employee Assistance Program

 


Nearest Major Market: New Haven
Nearest Secondary Market: Hartford