The Data Integrity Analyst plays a critical role in monitoring, auditing and improving data quality across the back-office data pipeline through mapping data flows, defining and enforcing data quality rules, collecting quality metrics through reports and dashboards, producing/monitoring data integrity scorecards, defining proposals to improve quality and ensuring proper implementation of data quality during the creation and modification of data. This role will initially focus on the lead to cash process but is expected to eventually focus across multiple back-office systems and perform related audits.

Responsibilities:

Data Quality

• Defines data quality rules, thresholds, and standard metrics/quality-expectations for data elements that support critical business processes and is an active advocate for recommendations on business process improvements.
• Builds and monitors data quality dashboards/scorecards on existing Salesforce data and performs ad hoc analysis of data quality issues.
• Proposes and implements industry best practices as it pertains to quality data.
• Works closely with business systems team on the development and implementation of the controls to mitigate data quality risk as required for accurate data migration and data modification
• Analyze, de-dupe, validate, and map data prior to data imports and updates.
• Partners cross-functionally with Finance, Marketing and Sales teams to establish metrics for data quality process assessment.
• Understand intricacies of system integrations as it relates to impacts on the data involved across multiple systems.
• Identify process gaps; actively proposes, advocates for, and implements remediation as required.
• Provide complete and scalable solutions to business data problems; performs root cause analysis of the data quality issues and drives corrective actions.

Data Lifecycle

• Have a solid understanding of data lifecycle management across all systems functional areas/modules; this requires being well-versed in typical enterprise-level back office functional workflows (lead-to-opportunity-to-quote-to-order, etc.).
• Establish and enforce systems data retention policies, working with legal and data security teams.
• Exhibits diplomacy while establishing and maintaining cooperative working relationships with designated stakeholders.
• Proposes and performs data purging on regular basis as part of data lifecycle.

Audit

• Perform quarterly/annual audits of multiple internal systems across multiple data types
• Maintains & enforces the sanctions policy through audit as established by Sage
• Work with the legal department and perform data extracts as required.
• Meets & supports audits performed by external auditors by being designated contact and coordinator for data being audited.
• Ensures Salesforce data backup is performed on a regular basis.

Required Skills:

• 3+ years of industry experience focused on improving quality of the data in big data environments
• Extensive familiarity with the Salesforce platform, Salesforce reporting and dashboard, data model, and data loading/manipulation tools; DemandTools preferred
• Strong ability to apply analytic and critical thinking skills, writing skills, communication skills, consulting skills, and ability to work within a team

Preferred Skills:

• Experience building metadata repositories and data lineages using modern data discovery techniques and tools
• Experience building executive-level dashboards using Tableau, Qlik Sense, or similar tools

#LI-LH1