Sr. Data Governance Analyst

Petco San Diego , CA 92140

Posted 3 months ago

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.

Position Purpose:

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.

Supervisory Responsibility:

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.

Work Environment:

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.

See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Data Governance Lead / IT Analyst


Posted 1 week ago

VIEW JOBS 11/4/2018 12:00:00 AM 2019-02-02T00:00 Data Governance Lead / IT Analyst Location San Diego - CA, US Level Bachelor Experience 2-5 Professional Functional Area Information Technology Background Information Technology Travel Reference req5949 Introduction ASML is one of the world's leading manufacturers of lithography systems that help enable Moore's Law and the creation of increasingly powerful and capable electronic devices. At our San Diego location we are renowned for developing both deep ultraviolet (DUV) lithography light sources and next generation extreme ultraviolet (EUV) light sources. We are a multinational company with over 70 locations in 16 countries, headquartered in Veldhoven, the Netherlands. If you have a passion for technology and innovation you'll want to check us out. Be a part of ASML. Be a part of progress. This position requires access to controlled technology, as defined in the Export Administration Regulations (15 C.F.R. § 730, et seq.). Qualified candidates must be legally authorized to access such controlled technology prior to beginning work. Business demands may require ASML to proceed with applicants who are immediately eligible to access controlled technology. Job Mission At Cymer Light Source, an IT Business Intelligence Analyst (BIA) leverages their solid foundation of information management experience, best practices, understanding of the Cymer enterprise data landscape, and depth in one or more business information domains in order to drive analytics solution delivery and enable the corporate vision of empowering self-service analytics. As a Data Governance program lead, this specific BIA will lead the Data Governance program for Cymer Light Source. focused on improving data quality through processes, policies, and standards. The Data Governance Lead will facilitate and/or lead various program workstreams to address the challenges of establishing enterprise data governance policies and procedures. The Data Governance lead will manage incoming requests and facilitate prioritization within the Data Governance Steering Committee. This individual will identify process improvements to drive better communication, collaboration, and effectiveness of the Data Governance program within Cymer. This role will also facilitate the identification and management of Critical Data Elements. Job Description * Lead or contribute to the design, implementation, testing, release, and communication of business intelligence solutions, typically focused on data management and data quality * Understand and document business requirements and use cases related to information management, consumption, generation, and lifecycle in order to drive towards optimal business intelligence solutions * Define test plans and test cases for business intelligence solutions, trusted data sets, and other data-centric use cases * Understand the resources, processes and technologies that enable the management, analysis, and consumption of business data (i.e. master, transactional, reference, meta, unstructured, content, etc.) * Develop and manage business relationships with associates, project team members and senior leaders across the organization * Inform and educate IT and business areas as to decisions that impact data standards, definitions, processes, policies and tools * Collaborate with cross functional teams regarding all areas of data development, consumption, and life cycle management to ensure compliance and effective processing and controls * Partner with Cymer Analytics Community of Practice (ACoP) and leverage other channels to disseminate information regarding business information management tools, best practices, existing reports, or metadata enhancements * Data Governance program lead responsibilities: * Provide program facilitation and leadership for data governance * Manage and track data governance program goals, standards, practice, process and technologies * Define and track metrics to measure and refine the success of the DG Program * Define, communicate and help implement data governance processes * Collaborate with and connect business owners, process owners and technical teams to raise business data ownership and stewardship * Drive the identification of critical data elements and measures that support critical business activities * Organize, facilitate, and deliver updates and presentations to Data Governance Steering Committee * Engage and coordinate Data Governance core team activities, updates and communication sessions * Facilitate data governance workstreams to ensure engagement, forward progress and roadmap goals Education * BA/BS in Business, Computer Science, Information Science, Computer Engineering, Accounting, Economics, Statistics, or a related field of study from an accredited college/university. Master's/Advanced degree preferred. * 4-6 years relevant direct work experience in business analysis, business intelligence, master data management and/or data governance processes and procedures. Experience * Demonstrated planning, organizing, and prioritizing skills with attention to detail. * Able to handle and manage shifting priorities, demands and timelines while using analytical and problem solving capabilities in a high pressure environment. * Able to cooperate and engage a wide variety of resources, including upper management, project team and other departments within the organization. * Excellent problem-solving and critical-thinking skills to recognize and comprehend complex issues, policies, regulatory requirements and industry information affecting the business environment. * Proven experience defining and documenting business processes. * Proven experience with Change Management. * Working knowledge of data and value stream mapping. * Must be able to read and interpret data, information, and documents. * Must be able to learn and apply new information or skills. Personal skills Data Analysis, Problem Solving, Communications skills Context of the position To design, develop, implement, manage and support of mission critical enterprise reporting, extract, transform, load (ETL) processes and environments. Asml San Diego CA

Sr. Data Governance Analyst