This role is responsible for manage, maintain and lead in utilizing the Corporate Customer Data Mart (CCDM), which houses customer-centric data. The individual is responsible for:
· Enhancing the database with complete and accurate customer-focused data and manage the data integrity.
· Taking the lead in utilizing, maintaining and upgrading the marketing databases, business intelligent tools and infrastructure necessary to support direct mail campaigns, customer and business analysis.
· Providing guidance and direction to database vendor-partners in developing and maintenance of CCDM.
· Acting as a primary Corporate Marketing liaison to the IT and Legacy systems.
· Implementing security and backup of the CCDM and preventing non-authorized access to customer data.
· Providing end-to-end data solutions and data processing to support analytics and modeling, marketing campaigns, results tracking and reporting.
This role requires exceptional project management skills, strong analytical skill, experience in advanced SAS programming and business intelligent tools, knowledge of data model and database management including design and development in mid-tiered server and PC environment.
Major Responsibilities:
(List only major job functions. Assign approximate
percentage of time spent on each function. Must = 100%)
Percentage
Manage the development and maintenance of Corporate Customer Data Mart (CCDM) - Develop task-based project plan, set timelines and consistent monitor adherence to milestones and deadlines for database marketing projects. Continue developing and enhancing Corporate Customer Data Mart (CCDM) for accuracy and completeness. Conduct front-end assessment, analysis, business requirements definition and functional design processes that reflect needs of the Corporate Marketing. Establish metadata including data dictionary and transformation rules to ensure consistent data usage. Ensure the CCDM is properly updated on schedule. Identify database system processes, industry best practices and recommend integration into database operations. Represent CK&D in weekly status meetings with IT and database external-vendor.
40%
Manage the data processing to support marketing campaigns - Develop and implement campaign data flow processes, campaign tracking procedures, and sales results reporting applications. Partner with campaign management team in developing campaign requirement specifications, producing technical specifications for list selection, manage and/or perform list selection programming, score customers based on predictive models. Track sales, leads, and results for marketing campaigns. Provide data analysis and sizing opportunity during campaign planning stages. Recommend and implement tracking infrastructure for campaigns.
25%
Develop end-to-end solutions of data needs to support advanced analytics teams and others users in Corporate Marketing - Develop data solutions to support analytics team and modelers, market research and other users of Corporate Marketing Determine best source data from CCDM, legacy systems and/or data warehouse to solve business problems. Facilitate the update of demographic, competitive and industry data from external source including documenting its data source. Recommend platform or data organization to best suit needs of analytical team. Manage data integrity. Evaluate, select and implement software for analytics and campaign management teams. Implement business intelligent tools; administer and provide expertise for other Corporate Marketing users in accessing marketing databases.
15%
Manage database production environment and manage hardware and software budget - Recommend, develop, and coordinate with IT to implement technology solutions and infrastructure changes required to support campaign and analytic needs. Examine, optimize and implement data usage practices, data storage and application environments. Develop and implement security practices in accessing customer-data. Develop backup and disaster recovery for CCDM and other data used by analytical team. Project and manage hardware and software licenses and expenditures to meet budget. Review and assist in contract negotiation with external vendors.
10%
Supervise consultants and data analysts. Prioritize assignments; provide adequate resources, review tasks, and sign-off on work performed by data analysts and consultants. Train new CK&D team members on accessing and using Corporate Customer Data Mart to ensure consistency in data usage, results reporting and communications to the field force.
5%
Projects as requested by manager
Sponsorship and a relocation allowance are available if needed.
Salary range to $125,000 +/- plus benefits
Experience: · Bachelors or Master (preferred) in computer science, mathematics, economics or marketing
· 7+ years of managing vendor partners including delivery of marketing database, campaign management, reporting tools, analytic mart, and end-to-end database maintenance services.
· 5+ years data management including data modeling, database design, development and/or data analysis
· 4+ years SAS programming including advanced macro programming, advanced SQL
· 3-5 years experience within Database Marketing department
· Proven experience in project management in technology development environment
· Strong experience in developing end-to-end data solutions for analytic and reporting areas and prepare data for use with query tools.
· Strong experience in direct marketing and list processing
· Mid-tiered server experience: UNIX or Microsoft Server experience is preferred
· Experience of business intelligent tools such as Business Objects, Cognos, or other OLAP tools.
· Strong knowledge of DBMS Oracle and DB2
· Knowledge of encryption (PGP, SSH, SFTP, Tunneling)
· Professional designations such as SAS Programming Certification, Project Management Certification, etc.
To Apply to this job go to http://www.GadBall.com or click here
Friday, December 07, 2007