Remote Data Management Resource II (Brand/Omnichannel Analytics Data Engineering)
1 Astellas Way Northbrook, IL 60062 US
Brand/Omnichannel Analytics Data Engineering
- 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 the company's production systems.
Masters 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: Bachelors 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:
a) Handling commercial data management, including data modeling, data extraction, data transformation, data load, data validation & reconciliation, and data centralization from multiple relational databases.
b) Managing the design, implementation, and execution of robust data integration processes and data flows between the data warehouse and source/target systems.
c) Handling project management including planning, task prioritization, objective setting, meeting management, and documentation.
d) Data management across the following systems and tools: java, Talend ETL, AWS, Redshift
e) Proficiency in SQL and working knowledge of R and/or Python
Although this hasn't been an issue at The Planet Group, the staffing industry has seen an increase in people falsely representing themselves as recruiters to gather personal information from job seekers. For your safety, do not provide sensitive data to anyone you have not spoken with thoroughly and never provide banking information during the application process. Candidate safety is a top priority at The Planet Group.