Data Engineer (Marketing)

Indiana University Bloomington

Bloomington, IN

ID: 7080758
Posted: July 2, 2021
Application Deadline: Open Until Filled

Job Description

Department Information
IU Studios is the central Marketing and Communications unit at Indiana University, and includes the University Events and Conferences teams. Our insights and technology-driven teams serve as strategic consultants throughout the university, with a central mission to create experiences that lead to a lifelong love for IU.

Job Summary
The IU Office of the Vice President for Communications and Marketing seeks a Marketing Data Engineer. Reports directly to the CRM Marketing Architect and tasked with helping evolve our usage of Salesforce Marketing Cloud (SFMC) by managing marketing data and campaigns, as well as support advanced data needs broadly across IU Studios.

Performs data management tasks, including experienced data modeling, conversion, de-duplication, migration, and identification and repair of data quality issues.
Designs, develops, and implements custom data systems and reconciliation tools, processes, rules, solutions etc. to validate data, match/merge, and upload batch lists.
Creates and tunes complex stored procedures and queries for data management and extraction.
Designs and builds out technical software mechanisms to accommodate multiple integration´s accurately based on complex rules and custom solutions.
Ensures documentation and security standards/protocols are recognized and followed.
Provides experienced troubleshooting and problem analysis/resolution for data related issues; performs experienced scripting and modifications of application and products for corrective action.
Researches and stays up-to-date with data engineering best practices and approaches; stays abreast of latest security threats and risks to proactively address potential exposures.
Specific department responsibilities:

Creates and maintains a complex data model in Marketing Cloud for use in marketing across Indiana University.
Fulfills data segmentation requests for partners to use in their email campaigns.
Translates plain-language requests into complex SQL queries and supports on-time delivery of requests.
Uses APIs to connect to Salesforce.
Performs ETL (extract, transform, load) from multiple systems and analytics tools for use in marketing campaigns.
Provides business and technical requirements to database owners and other marketing technology platform owners.
Provides data requirements for use in SFMC and guides how data is ingested into Marketing Cloud.
Establishes relationships with data stewards, data managers, development teams, and departmental and school stakeholders to understand and establish technical and operational business requirements that guide usage of data within and around SFMC.
Develops processes for ensuring data security adheres to university policies and all governmental legal requirements (HIPPA, FERPA, GDPR, CASL).
Qualifications
EDUCATION

Required

Bachelor's degree (preferably in computer science, information science, or a related field.)
Preferred

Master’s degree in Business Administration, Marketing, MIS, Informatics, Computer Science, or a related field.
WORK EXPERIENCE

Required

2 years of data management, engineering, or related experience.
Preferred

2 years of experience in database querying with SQL, frameworks, RESTful APIs, CRM, Python, and marketing automation or building data pipelines.
Experience working with semi-structured/unstructured data and Datorama.



 

Apply Now

Please mention to the employer that you saw this ad on UniversityJobs.com