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.
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).
Bachelor's degree (preferably in computer science, information science, or a related field.)
Master's degree in Business Administration, Marketing, MIS, Informatics, Computer Science, or a related field.
2 years of data management, engineering, or related experience.
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.
Combinations of related education and experience may be considered.
Proficient communication skills.
Maintains a high degree of professionalism.
Demonstrated time management and priority setting skills.
Demonstrates a high commitment to quality.
Possesses flexibility to work in a fast paced, dynamic environment.
Seeks to acquire knowledge in area of specialty.
Highly thorough and dependable.
Demonstrates a high level of accuracy, even under pressure.
Possess strong technical aptitude.
Ability to quickly troubleshoot and resolve problems and find creative, scalable technical solutions.
Excellent collaboration and team building skills, including the ability to effectively communicate and exchange information.
Working Conditions / Demands
This role requires the ability to effectively communicate and to operate a computer and other standard office productivity equipment. The position involves sedentary work as well as periods of time moving around an office environment and the campus. The person in this role must be able to perform the essential functions with or without an accommodation.
Due to the COVID-19 pandemic, there may be differences in the working conditions as advertised in our standard job postings (e.g., the ability to travel from one campus to another, etc.). If you are invited for an interview, please discuss your questions or concerns regarding the working conditions at that time.
This posting is scheduled to close at 11:59 pm EST on the advertised Close Date. This posting may be closed at any time at the discretion of the University, but will remain open for a minimum of 5 business days. To guarantee full consideration, please submit your application within 5 business days of the Posted Date.
If you wish to include a cover letter, you may include it with your resume when uploading attachments.
Beginning with the fall 2021 semester, all Indiana University students, faculty, and staff will be required to be fully vaccinated for COVID-19 as a condition of enrollment / employment.To learn more about this requirement, view ourCOVID-19 vaccine information page .
Equal Employment Opportunity
Indiana University is an equal employment and affirmative action employer and a provider of ADA services. All qualified applicants will receive consideration for employment without regard to age, ethnicity, color, race, religion, sex, sexual orientation, gender identity or expression, genetic information, marital status, national origin, disability status or protected veteran status. Indiana University does not discriminate on the basis of sex in its educational programs and activities, including employment and admission, as required by Title IX. Questions or complaints regarding Title IX may be referred to the U.S. Department of Education Office for Civil Rights or the university Title IX Coordinator. See Indiana University's Notice of Non-Discrimination here which includes contact information .
Campus Safety and Security
The Annual Security and Fire Safety Report, containing policy statements, crime and fire statistics for all Indiana University campuses, is available online . You may also request a physical copy by emailing IU Public Safety at firstname.lastname@example.org or by visiting IUPD.
About Indiana University Purdue University Indianpolis - IUPUI
Founded in 1820, Indiana University is the state’s public university system, comprised of two core campuses—IU-Bloomington and IUPUI—and six regional campuses located throughout the state. Combined, the total student population is more than 114,000 undergraduate, graduate and professional school students. IU is one of the largest employers in the state, with over 20,000 faculty and staff. Indiana University is an equal employment and affirmative action employer and a provider of ADA services. Diversity and inclusion remains a core commitment to IU’s mission to cultivate an educational environment that supports equal access, participation and representation on all of its campuses and that provides educational and career opportunities for all.