Data Quality Engineer II

Primary responsibility and activity for the assessment, improvement, implementation, and support of data quality initiatives across the Novant Health data platform. Assesses the current state of the Novant Health data platform for improvement opportunities within the six dimensions of data quality. Works within and beyond area of control to implement improvement approaches. Engages with team to quantify and articulate the business impact of data quality issues. Analyzes business requirements and translates to technical requirements. Collaborates with Enterprise Architects, Data Platform Integration, other teams, and third-party vendors. Applies knowledge to analyze, evaluate, and architect possible solutions; and presents recommendations to DPS management and business stakeholders. Solutions architecture comprises end-to-end processes, including the application and integration of data quality rules into existing and new processes, which deliver data to consumer layers and downstream systems. Collaborates with various business and technical teams to gather requirements around data quality rules. Configures data quality rules per requirements, following standards and design patterns, applying defensive programming for any code optimization needed. Applies problem-solving skills to address technical issues around the solution, and liaisons with vendors to diagnose and resolve potential defects. Works with Business Analysts and subject matter experts on processes to enable and ensure data quality within the data platform. Leverages profiling methods to properly identify data irregularities and inaccuracies. Creates and executes data quality mappings that will cleanse, de-duplicate, and otherwise prepare project data. Implements data quality processes leveraging Address Verification engine capabilities; including transliteration, parsing, standardization and enrichment for both batch and single request modes. Deploys mappings that will run in scheduled, batch, or real-time environments. Documents all mappings, mapplets, and rules in detail and provides documentation to team members and leadership. Utilizes the data quality tool to design and develop custom objects and rules. Designs matching plans, assists in defining best matching algorithms, configuring identity matching and analyzing duplicates. Develops profiles and scripts for the execution and testing of mappings and workflows to implement data stewardship and exception processing. Creates human task workflows and data quality scorecards to support data remediation. Proficient at writing SQL queries and validating the results of data loads. Develops, monitors, supports, and optimizes data quality scorecards and exception workflows. Tunes processes to meet SLAs for downstream systems. Maintains documentation to assist in troubleshooting production issues and to optimize the support of production processes. Implements best practices, following policies and change management procedures. Develops subject matter expertise of Novant Health’s data quality processes and how it impacts upstream and downstream solutions.

The following qualifications are the minimum necessary to adequately perform this job. However, an approved equivalent combination of experience, education and training which provides the necessary knowledge, skills and abilities could be acceptable, subject to any licensure/certification/legal and/or regulatory requirements.

Come join a remarkable team where quality care meets quality service, in every dimension, every time.

#JoinTeamAubergine #NovantHealth Let Novant Health be the destination for your professional growth.

At Novant Health, one of our core values is diversity and inclusion. By engaging the strengths and talents of each team member, we ensure a strong organization capable of providing remarkable healthcare to our patients, families and communities. Therefore, we invite applicants from all group dynamics to apply to our exciting career opportunities.

• Education: High School Diploma or GED, required. 4 Year / Bachelors Degree, preferred. 
• Experience: Minimum three years in a data quality engineering or developer role. Strong experience using data quality tools, such as Informatica IDQ. Knowledge of the capabilities and constraints of data quality product. Proficient in the development and optimization of Microsoft SQL queries, required. 
• Additional Skills (required):
  • Ability to work under deadlines and heavy workloads with minimal supervision.
    
  • Ability to translate business needs into technical solutions.
    
  • Values team collaboration.
    
  • Possesses a thorough understanding of business and technology disciplines.
    
  • Knowledge of end-to-end processes for producing trusted data.
    
  • Knowledge and experience with development and best practices using Novant Health’s data quality tools.
    
  • Knowledge and understanding of the six dimensions of data quality.
    
  • Proficient in writing SQL queries to identify data issues, data fixes, and validate new and existing data.
  • Ability to perform research, data collection, quality assurance, analysis and problem solving.
    
  • Utilization of change management processes and agile methodology.
• Additional Skills (preferred):
  • Experience with integrating data with Microsoft Azure.
    
  • Understanding the processes required to integrate Novant Health’s data quality tools with other products, such as Informatica’s Enterprise Data Catalog (EDC) and Business Glossary (Axon).
    
  • Proficient in cleansing and de-duplicating healthcare data is preferred.
    
  • Experience with electronic patient medical record systems and their reporting databases, such as Epic and Clarity.
    
  • Experience with implementing Master Data Management systems, such as Informatica MDM preferred. Understanding of agile framework and methodology.

It is the responsibility of every Novant Health team member to deliver the most remarkable patient experience in every dimension, every time.

• Our team members are part of an environment that fosters team work, team member engagement and community involvement.
• The successful team member has a commitment to leveraging diversity and inclusion in support of quality care.
• All Novant Health team members are responsible for fostering a safe patient environment driven by the principles of "First Do No Harm".