Data Engineer Master Data Management
Employment Type: Full-Time
Industry: Information Technology
Data Engineer Master Data Management Jersey City, NJ As the Data Engineer, you will be responsible for the design, performance, and integrity of a new data warehouse. You will provide technical expertise in the strategy, design, implementation, and maintenance of database management systems that support the expanding the client s US Marketing function, with a focus on developing a Customer Master that contains a golden record with both PII and marketing activity. Additional responsibilities would include reporting dashboards, data hygiene, data input and output, API, and ETL technology management. What You Will Do Maintains all aspects of our customer marketing data and operational data management environment Responsible for engineering and maintaining the API interfaces for the data life cycle management Manages data integrations within company s domain technology stack Work closely with members of the Marketing and extended teams to ensure all data flows are compliant with all the services (cloud, third party, BI) and integrate with other core services Responsible for maintaining all data workflows Collaborates with teams to provide best data management practices and governance. Produce and maintain complex data workflows to meet all the quality requirements of the data management policy Designs and documents database architecture Responsible for creating and maintaining operational data store. Responsible for creating match and merge logic for customer unification. Responsible for ingestion and extraction of data using MDM tool like informatica, Amperity etc. Expertise on NoSql and Relational Databases. Expertise is Data Warehousing and familiarity with cloud offerings for warehouse. Familiar with Snowflake, AWS, EC2, lambda functions, Dynamo DB. Creates and maintains diagnoses, alerting and monitoring code. Builds database schemas, tables, procedures and permissions Develops database utilities and automated reporting Prepares written materials for the purpose of documenting activities, providing written reference, andor conveying information What You Will Need Requires technical expertise regarding data models, master data management, data warehousing, marketing attribution, and data quality improvement Requires MDM experience in creating customer master. Requires proficiency in Kafta topic and messaging queues. Requires NoSql experience and hands on JSON and AVRO. Requires expertise in handling PII and PCI data. Requires proficiency in the use of Structured Query Languages for building, maintaining and extracting data from relational databases 7+ years experience with engineering storage systems and their integration and use in various environments. Familiar with ETL processes (Python, or equivalent) and Snowflake setup and maintenance Experience with Funnel, Tealium a plus Experience with object storage tech and data management technology Experience managing databases. Proficient in database administration, management, data imports and exports, and developing reports. Experience with marketing performance measurement, CRM, customercampaign-level media reporting a plus Experience creating business requirements documents andor other application systems related documents. Experience working at companies performing complexlarge scale applications deployments, employing recognized best practices. You are a 'full stack' data person - you know how to work with large, sometimes messy data sets, no matter where or how they are stored
Loading some great jobs for you...