Cloud Integrations Specialist
Job location: 2420 OLD IVY RD OFFICE BUILDING
Employment Type: Full-time
Posted data: 2021-05-05
The University of Virginia Advancement Operations team seeks a Cloud Integrations Specialist to automate business processes and integrate best-in-class platforms with CRM and data warehouses.
You will own the lifecycle of multiple integrations: defining business requirements, producing end-to-end process diagrams, developing and testing integrations and moving them to production. You will help create, modify, and support an efficiently tuned and modular codebase that evolves with business needs in an agile environment.
A thorough knowledge of extract, transform, load (ETL), SQL, and data warehousing is required. Data accuracy, cleansing, and constituent matching are crucial. Experience with modern integration tools like Mulesoft, Informatica, Boomi, or Jitterbit is desired.
You will complete complex assignments independently and help maintain continuity of operations during a transition from legacy systems. Oracle, Azure, Salesforce, Marketing Cloud, Cvent, Eventbrite, EverTrue, RESTful APIs and other cloud technologies will be part of our evolving technology ecosystem.
Shifting priorities and flexible collaboration across departments with multiple stakeholders are to be expected and will create meaningful ROI and progressive wins.
We seek a self-starter; a team player familiar with agile methodologies and project management best practices. If this sounds like you, come join our team during the ten-year Honor the Future fundraising campaign at Thomas Jefferson’s flagship educational institution. This position is full-time, remote-friendly, with benefits.
Bachelor's degree in computer science, programming, related disciplines, or equivalent related experience. Relevant experience may be considered in lieu of a degree.
Required Experience - 3 years
If any experience is required, please specify kind of experience:
Proven track record with extract, transform, load (ETL) responsibilities and exchanging data across systems using web service services, APIs, (RESTful, SOAP).
Experience with master data management (MDM) practices to ensure new transactions are correctly matched to existing constituents to create an official golden record and data is cleansed and standardized to accepted formats.
Experience scoping, writing, maintaining, and testing SQL procedures, error/exception files, and job scheduling; (PL/SQL & T-SQL); Linux shell scripting, BASH; Windows; Linux; Oracle; SQL Server.
Proven responsibility for troubleshooting existing services, performing root cause analysis, automating business processes.
Demonstrable experience preparing technical diagrams, logical data models, source to target maps, user-friendly documentation and responsibilities for stakeholder and vendor communications.
Experience participating in team-driven, deadline-oriented environment using project management tools and agile methods in an environment of shifting priorities.
Preferred Experience - 4 or more years
Full life cycle ownership of design, configuration, and maintenance of third-party ETL tools such as Mulesoft, Informatica, Jitterbit, or Boomi.
Experience designing system architectures including star schemas, snowflakes, cubes, and dimensional modeling.
Demonstrable experience in business requirements gathering, process improvement, leadership of stakeholder and vendor communications/meetings to ensure efficient use of time and clear communications.
Salesforce Admin/Developer/Other Certifications.
Experience with higher education CRM systems such as Salesforce, Ellucian, Blackbaud.
Diversity, Equity & Inclusion
Committed to attracting and retaining a diverse staff, University Advancement honors your experiences, perspectives and unique identity. Together, we strive to create and maintain working environments that are inclusive, equitable and welcoming so we can best achieve our mission of supporting our broadly diverse partners, schools, and networks of engaged alumni, parents, and friends of the University.
UVA Advancement offers a flexible and hybrid workplace. All team members must have access to and maintain a secure home office environment with high-speed internet service and work collaboratively with others using a variety of technologies and tools. Depending on the type of position and work performed, or as deemed by manager, some positions may be required to work intermittently in a shared office space located in Charlottesville, Virginia.
This position will remain open until filled. This is an Exempt level, benefited position. This position is a restricted position and is dependent upon project need, availability of funding and performance. The University will perform background checks on all new hires prior to employment. This position will also require insert any additional checks. For questions about the position or the application process, please contact Ashley Cochran, Senior Recruiter at email@example.com.
Please apply through Workday, and search by job title “Cloud Integrations Specialist.” Complete an application online and attach a cover letter and CV/resume all into the resume submission field, multiple documents can be submitted into this one field. Internal applicants must apply through their UVA Workday profile.
The University of Virginia, including the UVA Health System which represents the UVA Medical Center, Schools of Medicine and Nursing, UVA Physician’s Group and the Claude Moore Health Sciences Library, are fundamentally committed to the diversity of our faculty and staff. We believe diversity is excellence expressing itself through every person's perspectives and lived experiences. We are equal opportunity and affirmative action employers. All qualified applicants will receive consideration for employment without regard to age, color, disability, gender identity or expression, marital status, national or ethnic origin, political affiliation, race, religion, sex (including pregnancy), sexual orientation, veteran status, and family medical or genetic information.