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 & Marketing seeks a Marketing Data Engineer. Reports directly to the CRM Marketing Architect and tasked with managing data in Salesforce Marketing Cloud, as well as supports advanced data needs broadly across IU Studios.
Department Specific Responsibilities
Fulfills advanced data segmentation requests for partners to use in their email campaigns by translating plain-language requests into complex SQL queries and supports on-time delivery of requests.
Performs ETL (extract, transform, load) from multiple systems and analytics tools for use in marketing campaigns.
Performs data management tasks, including data modeling,, de-duplication, migration, and identification and repair of data quality issues.
Serves as subject matter expert for technical solutions within and connected to Salesforce Marketing Cloud, including APIs.
Designs, develops, and implements custom data systems and reconciliation tools, processes, rules, solutions etc. to validate data, match/merge, and upload batch lists.
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 and exported from 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.
General Responsibilities
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 integrations 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.
Qualifications
EDUCATION
Required
Bachelor's degree preferably in computer science, information science, or related field
Preferred
Master's degree in Business Administration, Marketing, MIS, Informatics, Computer Science, or a related field.
WORK EXPERIENCE
Required
2 years data management, engineering, or related experience
Preferred
2 years of experience in database querying with SQL, frameworks, APIs, CRM, Python, and marketing automation or building data pipelines.
Experience working with Salesforce Marketing Cloud or marketing automation platforms.
Combinations of related education and experience may be considered
SKILLS
Required
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
Preferred
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.
New employees will be provided with information regarding Indiana University's COVID-19 vaccine policy, which includes the opportunity to request an exemption. To learn more, view our COVID-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 based on individual qualifications. Indiana University prohibits discrimination based on 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 iups@iu.edu or by visiting IUPD.
About Indiana University Purdue University Indianapolis
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.
