(IS/IT) - Data Management Resource II

Northbrook, IL 60062

Posted: 09/05/2023 Job Number: 37974

Job Description

Pay range is $47 - $53 per hour with full benefits available, including paid time off, medical/dental/vision/life insurance, 401K, parental leave, and more. Our compensation reflects the cost of labor across several US geographic markets. Pay is based on several factors including market location and may vary depending on job-related knowledge, skills, and experience.


At Crystal Equation, we empower people and advance technology initiatives by building trust.  Your recruiter will prep you for the interview, obtain feedback, guide you through any necessary paperwork and provide everything you need for a successful start.  We will serve to empower you along the way and provide the path for your professional journey.


(IS/IT) - Data Management Resource II

  • Guide and execute the build-out and improvement of the brand analytics and marketing analytics and enablement data ecosystem, including the marketing/customer data, promotional data and analytics data layer. Work in close collaboration with all marketing and sales support teams, including Commercial Insights, Data Strategy, Information Systems (IS), Omnichannel Strategy and Operations (OSO), and Field Analytics.
  • Provide ongoing operational support for current/active data mart functionality and drive greater efficiencies through continued analysis and improvement of analytics-ready data sets, process refinement, documentation and education. Serve as primary point of contact for all data-related support. Manage business requirements and data solution designs responsible for implementing omni-channel programs and day-to-day operations of the omnichannel and brand analytics teams.
  • Evolve data capabilities roadmap and drive adoption of future capabilities, environment enhancements and necessary process improvements. Partner with AWS infrastructure team and Information Systems (IS) to maintain and expand database capabilities by ensuring the analytics vision is supported while defining business and user requirements, release roadmaps, and stakeholder coordination.
  • Manage and maintain customer and customer engagement data sources, derived analytics-ready data, including those required to build customer 360 database. Establish and maintain standards, business rules, and processes for data sourcing, on-boarding, and ingestion. Partner with IS on data utilization for and integration with analytics and marketing automation capability. Define and document business rules that translate campaign requirements into technical specifications. Support implementation, execution and ongoing assessment of analytics-derived recommendations, including target lists, next best action suggestions, and alerts, by applying appropriate business/ compliance rules, developing tools to support effective communications/ reporting to key stakeholders, and partnering internal and external stakeholders to manage data loading to/from our production systems.

Required skills:
  • Master’s degree or the foreign equivalent in Computer Science, Computer Information Systems, or related field, and 24-36 months of experience in the same or closely similar role.

Alternate Requirements:
  • Bachelor’s degree or the foreign equivalent in Computer Science, Computer Information Systems, or related field, and 48-60 months of experience in the same or closely similar role.

Three (3) or more years of experience operating in a matrix environment, and involving all of the following:
  • Handling commercial data management, including data modeling, data extraction, data transformation, data load, data validation & reconciliation, and data centralization from multiple relational databases.
  • Managing the design, implementation, and execution of robust data integration processes and data flows between the data warehouse and source/target systems.
  • Handling project management including planning, task prioritization, objective setting, meeting management, and documentation.
  • Data management across the following systems and tools: java, Talend ETL, AWS, Redshift
  • Proficiency in SQL and working knowledge of R and/or Python

Meet Your Recruiter

Scott Brasel

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.