Data Quality Engineer

by J.D.Power/Autodata Division

Location: London, ON
Date Posted: Jun 19, 2022
J.D.Power/Autodata Division

Job Description

 
Data Quality Engineer

 

The Role: 

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. Principle responsibilities are to making data assets consistently accurate for users.

 

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.
  • Write DB scripts to validate data in the data repositories against the data in the source systems
  • Track, monitor and document testing results
  • 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 with minimal supervision

Other key activities:

  • Collaborate with Product Managers, developers and data engineers to elicit, document, and translate business requirements for data needs into technical requirements while contributing to a unified system architecture and minimizing technical debt
  • Promote and support the infrastructure of reporting, analytics, and data sourcing strategy; this includes developing and advancing standards and best practices and recommending infrastructure changes when appropriate
  • Perform ongoing monitoring and refinement of data platform
  • Design and implement solutions to improve data platform
  • Collaborate on and learn new technologies
  • Maintain, expand, and improve ETL processes
  • Maintain data standards, enforce standard development protocols, and analyze requirements to ensure technical and standard operating procedure impacts are considered
  • Troubleshoot and performance tune data management code
  • Limit non-standard solutions and escalate when used with documentation supporting exception requirements
  • Perform other duties as assigned
  • Work team approach:

  • Work on a highly collaborative agile team
  • Coordinate work with Database Administrators and System Engineers, as needed
  • Assist report writers and data visualization team members with data sourcing
  • Participate in technical reviews and provide detailed feedback for process improvement
  • Collaborate with the Decision Services team, other members of Information Services, and cross-functional business stakeholders to translate business requirements into technical specifications
  • Effective communication skills with an ability to explain technical concepts to developers, product managers, and business partner
  • Excellent problem solving and critical thinking skills
  • Ability and desire to work with a team of people solving complex problems that often require independent research with minimal supervision
  • Self-starter able to make an impact with little guidance
  • Understanding of agile processes
  • Outstanding attention to detail and ability to meet deadlines
  • Self-starter with the ability to multitask in a dynamic work environment
  •  Qualifications:

  • 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.
  • 5+ years of experience with database software (SQL, Google Bigquery, etc), in writing complex SQL queries and stored procedures and ETL in Python.
  • 2+ 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.
  • Understanding of ETL methodologies and Data Warehousing principles, approaches, technologies, and architectures including the concepts, designs, and usage of data warehouses and data marts.
  • Knowledge of data warehousing, OLAP, multi-dimensional, star and snowflake schemas
  • Knowledge and experience with database design principles including referential integrity, normalization, and indexing to support application development.
  • Strong understanding and experience in development activities for all aspects of Software Development Life Cycle (SDLC).
  • J.D. Power is a global leader in consumer insights, advisory services and data and analytics. A pioneer in the use of big data, artificial intelligence (AI) and algorithmic modeling capabilities to understand consumer behavior, J.D. Power has been delivering incisive industry intelligence on customer interactions with brands and products for more than 50 years. The world's leading businesses across major industries rely on J.D. Power to guide their customer-facing strategies. 

    Company Mission 

    J.D. Power is clear about what we do to ensure our success into the future. We unite industry leading data and insights with world-class technology to solve our clients’ toughest challenges.  

     

    Our Values 

    At J.D. Power, we strive to be Truth Finders, Change Makers and Team Driven - the distinct behaviors that, together, define our unique culture.  

     

    Truth Finders - At J.D. Power, we are proud of the unbiased data and findings we provide. As individuals, each and every member of our team is dedicated to living this same objectivity and embodying the highest ethical and professional standards – the only ‘favorite’ we have is the truth.  

     

    Change Makers - At J.D. Power, we never stand still. We constantly seek better ways – innovating and evolving in everything we do to support our colleagues and our clients alike – and all in service of delivering data and insights that drive meaningful business impact.  

     

    Team Driven - At J.D. Power, we are one team and we are activated. Regardless of individual role, every member of our team is dedicated to supporting their immediate colleagues and our broader J.D. Power family to deliver on our collective purpose and make us greater than the sum of our parts. 

     

    At J.D. Power, these values are more than words. We bring these values to life throughout our organization through our employee event series — J.D. Power Values Days. Each quarter, we celebrate one of our core values and hold an annual event to celebrate our combined values at the end of the year. 

     

    We are dedicated to leveraging comprehensive and equitable practices which contribute to the overall success of the company and its employees. We invite you to learn more about our DE&I efforts.  

      

    J.D. Power is an equal opportunity employer and compliant with AODA/ADA legislation.  If you require accommodations during the recruitment and selection process, please specify. 

     

    To all recruitment agencies: J.D. Power does not accept unsolicited agency resumes and we are not responsible for any fees related to unsolicited resumes. 



    Apply for this Job