Petco San Diego , CA 92140
Our vision at Petco is Healthier Pets. Happier People. Better World. We're making things better for pets, people and the planet through our Think Adoption First philosophy, the Petco Foundation and other important initiatives that focus on putting animals first, educating pet parents and reducing our carbon footprint. The journey starts with knowledgeable, passionately engaged associates who are proud to recommend Petco as a place to work, who believe in our Vision and who are committed to delivering a superior customer experience.
From our retail stores and our network of Distribution Centers to our Corporate offices, you'll work with others who share your values and commitment. We seek individuals who are passionate about animal welfare, have great people skills and are driven to grow and advance in their careers with us. Our ongoing growth is creating exceptional opportunities for professional development and personal enrichment throughout our organization.
The Sr. Data Governance Analyst will be for our San Diego, CA location and will be responsible to efficiently acquire, cleanse/scrub, convert, and migrate data obtained from various sources, e.g., Siebel CRM, OBIEE, UCM, MDM in order to help drive key marketing program initiatives; and to coordinate the standardization and maintenance of metrics across multiple analytic systems.
Customer Identity Master Stewardship
Perform data extraction, mining, analysis, conversion/transformation for loading into other systems to perform data quality analysis
Identify, analyze and interpret trends or patterns for the Company by querying large and complex data sets in SQL
Bring in best practices as well as being first line of support and grow to be an 'industry expert' in the customer data quality space
Ensure a continual global understanding of data flows within core and spoke systems
Identify, define and efficiently address user needs in the establishment of practices and processes for data storage and management in the systems
Develop, define and implement data governance policies and procedures with regards to management, accessibility, and updates (e.g. NCOA, householding, data append strategy)
Acquire business data for purposes of cleansing and migration to Siebel CRM and UCM and related databases and tools; coordinate data cleansing efforts with the business
In collaboration with the IT Department, develop logic and scripts to validate and load data from source to target systems
Develop and run testing and validation plans
Deliver analysis and status reports
Systems maintenance and enhancements
Act main conduit between business users and IT groups to facilitate issues resolution, new enhancement for the Siebel Customer Master.
Ensuring that the business has an 'advocate' and expert to get to the end goal.
Being the keeper of the prioritized list
Diagnose incidents and data questions via SQL access to database - front end Siebel and Reltio data mining experience a plus
Ensure that all impacted systems (both Siebel and spoke systems in a process) are reviewed, modified and tested accordingly and all system/application changes are documented appropriately
Provide expertise and guidance in the future project implementations within the Siebel suite
Act as the voice of the business in capturing business requirements and champion them with the IT and Software providers- maintain scope to industry 'best practice'
Customer Data Quality
Collaborate as part of a data governance body to develop consistent data definitions
Set clear data quality and integrity expectations and ensure compliance
Establish and maintain customer data metric definitions
Partner with IT to resolve any variance from the agreed calculations
Work with IT during the system development and provide requirements and business information that may impact data
Drive processes that ensure customer data across systems is consistent and accurately reflect the agreed upon definitions
Other Duties and Responsibilities
Interact professionally and effectively through verbal and written communication with all professional contacts and represent the company interests
Perform other related duties, tasks and responsibilities as required, assigned or directed.
None, but the incumbent works cross-functionally within the entire organization, requiring the ability to functionally manage up and down; also works closely with/but not reporting to Petco IT resources.
The majority of job duties are conducted while seated indoors at a computer terminal, with little or no exposure to hazards.
Bachelor's Degree or equivalent, preferably in Marketing, Statistics, Business, Economics or related field.
Requires 4 - 6 years technology and business systems analyst experience, preferably in Marketing CRM or Digital Marketing space.
Must have a minimum of 4 years data, BI, master data management and/or customer database experience; working knowledge of Siebel CRM data model preferred.
Requires a minimum of 4 years experience working with data in several different formats (Database, flat files, Office, etc.).
Requires a fundamental understanding of CRM and ERP related business processes, as well as the ability to grasp and learn the specifics to our business.
Demonstrated proficiency with SQL and related tools in an Oracle environment (Toad, SQL Dev, etc).
Experience utilizing Microsoft tools (Excel, Access, etc.) is mandatory, as are the skills to effectively extract (mine), analyze, cleanse and manipulate data.
Requires a solid understanding of relational data structures and modeling, the ability to query data and document data flows as well as translate that into useable documents for the business.
Must be able to articulate patterns observed in data into meaningful and actionable set of KPI's to monitor the health of Petco data quality. skillfully interpret data from both technical and business perspectives.
Must possess advanced communication and interpersonal skills and be comfortable working within large groups.
Self-starter with partiality towards proactive discovery, a passion for customer data, ability to work cross-functionally, relentless focus on the details, and strong experience with BI and data tools.