30 days old

Senior Database Analyst

Consumer Reports
Yonkers, NY 10703
  • Job Code
    118793800

Overview

The Senior Database Analyst is a key member of the Customer Data Hub team reporting to the Associate Director, Customer Data Platform. Responsible for the ongoing maintenance, auditing and troubleshooting of the Customer Data Hub. Other responsibilities include performing UAT on system changes, writing/updating documentation and writing technical requirements for Customer Data Hub enhancements in support of new business processes and marketing programs. Develop and program new summarized derived data based on existing detail level data to support the on-going needs of the analytics, campaign selection, and other teams.



Responsibilities

  • Work closely with business stakeholders to understand and translate their requirements into technical specifications and processing instructions for Data Warehouse development.
  • Develops and communicates specifications to both internal staff and external vendors for highly complex projects such as the addition of whole new sources of data and changes to existing data to accommodate new business processes and marketing programs.
  • Liaise with contributing internal and external source systems, to ensure the seamless processing of the regular updates of the Customer Database. This includes adherence to standards, schedules and procedures which enable meeting service level agreements for the loading of feeds, scores, NCOA updates and overlay appends.
  • Creates automated dashboards, reports, and alerts to validate daily production loads, reviewing counts and identifying and resolving data anomalies.
  • Analyze data anomalies, determine the source of the problem, recommend and oversee implementation of sound corrective actions. Identify improved controls and procedures to avoid recurrence.
  • Responsible for analysis, design and testing activities of enhancements to the Integrated Customer Database. Develop and execute test plans, and document results.
  • Validate the quality of data enhancements made to the production database such as validating inbound/outbound files, manual fixes, and spot checking results of production change requests.
  • Update and maintain documentation for system changes in support of the data governance objectives.
  • Champions and promotes industry best practices
  • May perform other duties as required.
<br /><strong>Overview</strong><br /><br /> <p style="margin: 0px;"><span style="font-size: 12pt;">The Senior Database Analyst is a key member of the Customer Data Hub team reporting to the Associate Director, Customer Data Platform. Responsible for the ongoing maintenance, auditing and troubleshooting of the Customer Data Hub. Other responsibilities include performing UAT on system changes, writing/updating documentation and writing technical requirements for Customer Data Hub enhancements in support of new business processes and marketing programs. Develop and program new summarized derived data based on existing detail level data to support the on-going needs of the analytics, campaign selection, and other teams.</span></p> <br /><br /><strong>Responsibilities</strong><br /><br /> <ul> <li><span style="font-size: 12pt;">Work closely with business stakeholders to understand and translate their requirements into technical specifications and processing instructions for Data Warehouse development.</span></li> <li><span style="font-size: 12pt;">Develops and communicates specifications to both internal staff and external vendors for highly complex projects such as the addition of whole new sources of data and changes to existing data to accommodate new business processes and marketing programs.</span></li> <li><span style="font-size: 12pt;">Liaise with contributing internal and external source systems, to ensure the seamless processing of the regular updates of the Customer Database. This includes adherence to standards, schedules and procedures which enable meeting service level agreements for the loading of feeds, scores, NCOA updates and overlay appends.</span></li> <li><span style="font-size: 12pt;">Creates automated dashboards, reports, and alerts to validate daily production loads, reviewing counts and identifying and resolving data anomalies.</span></li> <li><span style="font-size: 12pt;">Analyze data anomalies, determine the source of the problem, recommend and oversee implementation of sound corrective actions. Identify improved controls and procedures to avoid recurrence.</span></li> <li><span style="font-size: 12pt;">Responsible for analysis, design and testing activities of enhancements to the Integrated Customer Database. Develop and execute test plans, and document results.</span></li> <li><span style="font-size: 12pt;">Validate the quality of data enhancements made to the production database such as validating inbound/outbound files, manual fixes, and spot checking results of production change requests.</span></li> <li><span style="font-size: 12pt;">Update and maintain documentation for system changes in support of the data governance objectives.</span></li> <li><span style="font-size: 12pt;">Champions and promotes industry best practices</span></li> <li><span style="font-size: 12pt;">May perform other duties as required.</span></li> </ul> <img src="https://analytics.click2apply.net/v/g25LdAt57Bb2FxaAIQnqN"> <br/><br/><br /><strong>Qualifications</strong><br /><br /> <ul> <li><span style="font-size: 12pt;">B.S. in Computer Science, Information Management, or a related discipline.</span></li> <li><span style="font-size: 12pt;">5-8 years experience managing marketing databases, CRM systems or data warehouse operations. Understanding of ETL workflow.</span></li> <li><span style="font-size: 12pt;">Experience working with relational database systems (Oracle, MS SQL Server, etc) Knowledge of one or more programming languages/libraries (Python, pandas, numpy, matplotlib, R, SAS, etc) for data explorations, analysis, and visualization</span></li> <li><span style="font-size: 12pt;">Strong hands-on data analytics skills, ability to develop complex SQL queries.</span></li> <li><span style="font-size: 12pt;">Experience with reporting, business intelligence and data visualization tools.</span></li> <li><span style="font-size: 12pt;">Understands all facets of data warehouse architecture, design, creation and data validation including applying current database technologies and tools to Database Marketing and Analysis objectives.</span></li> <li><span style="font-size: 12pt;">Must be experienced in the complete development life-cycle for a variety of data warehouses and business intelligence solutions.</span></li> <li><span style="font-size: 12pt;">Superior interpersonal, writing, communication and documentation skills are essential. Must be equally conversant in both Marketing and Information Technology terminology. </span></li> </ul><p>PI118793800</p>

Categories

Posted: 2020-03-05 Expires: 2020-04-05

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Senior Database Analyst

Consumer Reports
Yonkers, NY 10703

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast