Data Engineer - Indiana University (Bloomington, IN) . Work independently and as Lead of the enterprise CRM Data Integrity Service Center, participating in all aspects of data audit, reconciliation, analysis, and entry/processing related to the vended applications included in the IU Salesforce CRM platform. Duties include: review university source integrated data to identify potential duplicate records; conduct research on external organizations; reconcile duplicate records through merging of primary entity and ancillary relationship data; complete research/analysis of external organization business structures to determine and establish record hierarchies based on established university standards; respond to user requests to establish new organization records following all established process guidelines and parameters; respond to user requests for related analytic reports based on submitted criteria for the purpose of data driven decisions that impact and guide university business practices; and, assist with development and data verification of executive summary reports that include select aggregated data related to external organizations and points of contact.

Qualifications

Reqs Bachelor's degree in Computer Science, Business Systems, or closely related field. Requires 1 year experience with: using Salesforce CRM, specializing in the creation of custom reports and data visualizations through the Salesforce reporting and dashboard features; designing and developing interactive dashboards using Power BI in conjunction with ArcGIS, proficient in translating complex data into visually compelling representations on geographic map views; utilizing Excel VBA programming to create custom tools for automating data integration and manipulation tasks, resulting in streamlined daily operational workflows; utilizing Denodo, showcasing a robust command of SQL, including the creation of intricate queries featuring multiple subqueries, complex joins, aggregations, and hierarchical queries, primarily employed for generating de-duplication reports. May permit telecommuting. Apply at jobs.iu.edu, reference Job # 316745

Work Location

Bloomington, Indiana

Benefits Overview

For full-time staff employees, Indiana University offers a wide array of benefits including: Comprehensive medical and dental insurance Health savings account with generous IU contributions Healthcare and dependent care flexible spending accounts Basic group life insurance paid by IU Voluntary supplemental life, long-term disability, critical illness, and supplemental accidental death & dismemberment insurance Base retirement plan with generous IU contributions, subject to vesting Voluntary supplemental retirement plan options Tuition subsidy for employees and family members taking IU courses 10 paid holidays plus a paid winter break each year Generous paid time off plans Paid leave for new parents and IU-sponsored volunteer events Employee assistance program (EAP) Learn more about our benefits by reviewing the IU Benefit Programs Brochure .

Job Classification

Career Level: Career

FLSA: Exempt

Job Function: Information Technology

Job Family: Data Analysis & Engineering Click here to learn more about Indiana University's Job Framework.

Posting Disclaimer

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.

Equal Employment Opportunity

Indiana University is an equal opportunity employer and provider of ADA services and prohibits discrimination in hiring. See Indiana University 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.

Contact Us

Request Support Telephone: 812-856-1234

Apply for Job Staff Positions Sign In New User Enable Screen Reader Mode