Salesforce Data Integration Specialist

Position Details Long Classification Title Information Technologist IV Campus Location Durham Department UNH CRM Tools Summary of Position This position will design, implement, and support data integration solutions related to Salesforce and associated systems for the University System of New Hampshire. In this role, this position will serve as an application administrator and design data integration solutions, systems, and processes to support the needs of our business users and will maintain the technical components of data feeds and related applications. Responsibilities include data extraction and integration, data transformation, automation of processes, security design and implementation, system administration and maintenance, upgrades, and documentation. This position will work under the Director of Enterprise CRM Services and will work closely with colleagues in the Enterprise Technology & Services organization. Acceptable minimum level of education Bachelor’s Acceptable minimum years of experience 5-7 years Additional Job Information The Salesforce Data Integration Specialist will enjoy the option of a hybrid schedule with a combination of on-campus and remote work or a full-time remote work option for those living outside New England. Posting Number PS2920FY22 Other minimum qualifications Bachelor’s degree and six years of experience in information technology field, Master’s and four years, or combination of education and experience equal to ten years.Experience synchronizing data with external systems using data integration tools such as Informatica, Dell Boomi, Axiom and/or writing API calls, scheduling and automation of processes.Strong data management skills required, including experience with data consolidation and de-duplication. Experience with data migration, third-party deduplication tools, and ETL required. Proven experience designing data mappings and transforming data.Database skills and strong knowledge of database structure and relationships.Experience with security design and configuration, testing and assuring data integrity. Experience in applying best practices through all phases of the project lifecycle. Strong attention to detail.Strong analytical skills, including a thorough understanding of how to interpret business needs and translate them into application and operational requirements. Proven ability to design, optimize business processes and integrate business processes across disparate systems. Experience writing technical and end user documentation, including scopes of work, specifications, and documents representing the functional needs of end-users on technical projects.Demonstrable experience troubleshooting complex technical issues.Proven ability to successfully juggle multiple projects, deliverables, and deadlines at once. Excellent oral and written communication skills, including the ability to interact effectively with diverse groups, such as executives, managers, and subject matter experts. Ability to facilitate complex discussions. Additional Preferred Qualifications Salesforce experience preferred, including understanding of Salesforce standard data architecture, and providing technical support for Salesforce implementations. Experience deploying solutions in a Higher Education environment. Salesforce Administration Certification(s). Experience with TargetX, Demand Tools, and Master Data Management tools.Experience in the facilitation of requirements gathering sessions.Experience in project management.Ability to work both independently and in a collaborative, team-oriented environment. Quicklink for Posting https://jobs.usnh.edu/postings/44995 Percent Time Information (FTE) 1.00 Grade 26 EEO Statement The University System of New Hampshire is an Equal Opportunity/Equal Access/Affirmative Action employer. The University System is committed to creating an environment that values and supports diversity and inclusiveness across our campus communities and encourages applications from qualified individuals who will help us achieve this mission. The University System prohibits discrimination on the basis of race, color, religion, sex, age, national origin, sexual orientation, gender identity or expression, disability, genetic information, veteran status, or marital status. Institution Information UNH is a federal contractor within the meaning of the Executive Order on Ensuring Adequate COVID Safety Protocols for Federal Contractors. This position may require that you be vaccinated against COVID-19 in the future, unless you apply for and receive a religious or medical exemption.The University of New Hampshire is an R1 Carnegie classification research institution providing comprehensive, high-quality undergraduate and graduate programs of distinction. UNH is located in Durham on a 188-acre campus, 60 miles north of Boston and 8 miles from the Atlantic coast and is convenient to New Hampshire’s lakes and mountains. There is a student enrollment of 13,000 students, with a full-time faculty of over 600, offering 90 undergraduate and more than 70 graduate programs. The University actively promotes a dynamic learning environment in which qualified individuals of differing perspectives, life experiences, and cultural backgrounds pursue academic goals with mutual respect and shared inquiry.The UNH Diversity Resource Guide with information and programming available in the seacoast area, New Hampshire, and the region can be found here: https://www.unh.edu/hr/diversity-resource-guide Posting Date 12/15/2021 Open Until Filled Yes Closing Date Posting Open to Internal Candidates Only? No Interested Internal Candidates Exist? No Job Category Salaried Staff (Exempt) Appointment Type Regular If TERM position provide projected end date Equipment/Instruments DOT Safety Information None applicable Duties / Responsibilities Job Duties Duty/Responsibility Salesforce Systems Integration and Data ManagementTranslate business user requirements into the design and development of customized data integration systems.Use data integration platforms/methods (Informatica, Dell Boomi, Axiom, API etc.) to develop and maintain custom data integrations between Salesforce CRM system and other systems including internal campus systems, external systems and vendor services, in order to support business applications and ensure data integrity. Implement/Execute data solutions including data management strategies, data migrations, and data cleansing.Analyze and recommend data modeling, mapping, normalization strategy, and design improvements.Execute data migrations and data quality efforts focused on completeness, standardization, and deduplication.Oversight and monitoring of all ETL processes in and out of CRM system and associated cloud architectures. Establish processes, procedures, and norms for moving data into/out of Salesforce and into other repositories. Use software development life cycle and change management best practices. Perform routine to moderately complex data analysis for planning and auditing data flows. Assist in the development of systems architecture and business processes to leverage integrated data platforms and promote data integration standards and best practices.Design and execute detailed test plans to ensure the highest possible quality of deliverables. Provide end-user support for use acceptance testing.Collaborate with CRM teammates and other IT colleagues to leverage efficiencies. Lead and manage projects from small to enterprise scale. Duty/Responsibility System AdministrationDesign and implement system security. Ensure adherence to data integrity, data validation/testing, and follow standardization of technical procedures.Learn features and requirements of new application releases and lead testing, deployment, and documentation of these releases as applicable. Work with stakeholders to review vendor release notes and coordinate testing plans if needed.Oversight and coordination of change management practices, maintain calendar of administrative functions and upgrades, oversight of updates, communicate with stakeholders for vendor upgrades and refresh events. Use software development life cycle and change management best practices.Maintain standardized technical documentation. Other System Administrator duties as needed. Duty/Responsibility Business AnalysisFacilitate technical design sessions to identify client requirements and processes.Develop and maintain strategic partnership between business needs and technology delivery. Research and analyze departmental needs, preferences, objectives and methods. Meet regularly with business users to ensure that data integrations are designed and set up to support their business processes. Advise and provide guidance and oversight to departmental power users and other distributed administrators. Work with various functions and business users to identify, document, and communicate standard business processes as they relate to data flows. Understand business requirements, lead requirements analysis and business process improvement. Assist business users with new or enhanced functionality. Assist with strategic and tactical planning in areas of responsibilities, especially in areas related to developing and conducting training sessions, including training key users in application system functionality.Manage technical scope and client expectations. Duty/Responsibility User Support and TrainingTroubleshoot technical problems and errors encountered by users and reach out to users to recommend best practices or clarify procedures. Work with vendors and IT staff to escalate and resolve issues as needed to support projects and operations. Lead user training sessions as needed. Create, update, and maintain training documentation/media. Supplemental Questions Required fields are indicated with an asterisk (*). * Do you meet the definition of an Internal Candidate? Internal Candidates include: (1) active status employees who have completed the introductory period and (2) adjunct staff members who have been employed within USNH for at least 12 months in total and who have worked at least 1,000 hours during the 12 month period preceding the application for the position. Student employment does not apply toward internal status eligibility. Yes No