Data Integration Architect V

The Data Integration Architect (Marketing Data Solution Lead) is responsible for the creation, maintenance and management of Enterprise marketing data solutions / enablers and their lower level components.

Responsibilities

• Lead the development of enterprise data integration / ETL architecture strategy and set direction for the organization


• Serve as an expert in integration industry best practices especially pertaining to integration and ingestion techniques


• Document, implement and maintain the extraction / transformation / loading (ETL) reference architecture


• Provide recommendations on ETL solutions, tools and approaches to advance and evolve capabilities to align with growing data solutions and services


• Mentor, train and develop others on the concepts of data integration and ETL architecture and best practices


• Track integration architecture roadmap, quality action items, issues, and priorities


• Audit project level adherence to integration architecture (e.g. solution architecture reviews, code reviews) to ensure that practices and standards are met


• Participate in marketing and sales data and analytics projects, and work with stakeholder groups to ensure successful solutions


• Work with 3rd parties to support business needs and projects


• Manage syndicated databases including restatements, custom aggregates, PPG, alignment, impact analysis to downstream deliverables, etc.


• Deep knowledge and experience in building and socializing Data Products using different technologies


• Develop specific metrics for quality and consistency and review of data

• Bachelor’s Degree in the field of computer science, information systems, or computer engineering


• 7-10  years of experience delivering data and analytics solutions for marketing and sales functions


• Working knowledge of modern cloud data warehouse solutions


• Knowledge of Azure ecosystem of technologies and all related information management components (ADF, ADLS, Databricks, Azure ML etc.)


• Knowledge of Snowflake system and it’s capabilities as utilized in Marketing / Sales domain


• Expert knowledge of Syndicated data platforms (IRI/Nielsen) and it’s capabilities as utilized in Marketing / Sales domain


• Knowledge building dashboards, reports and data models for advanced analytics


• Experience in a combination of data management, data warehousing and business intelligence architecture roles


• Experience with implementing enterprise data integration


• Experience with ETL and data analysis tools