Salary Range: Salary commensurate with experience and qualifications
About SMU SMU's more than 12,000 diverse, high-achieving students come from all 50 states and over 80 countries to take advantage of the University's small classes, meaningful research opportunities, leadership development, community service, international study and innovative programs.
SMU serves approximately 7,000 undergraduates and 5,000 graduate students through eight degree-granting schools: Dedman College of Humanities and Sciences , Cox School of Business , Lyle School of Engineering , Meadows School of the Arts , Simmons School of Education and Human Development , Dedman School of Law , Perkins School of Theology and Moody School of Graduate and Advanced Studies .
SMU is data driven, and its powerful supercomputing ecosystem - paired with entrepreneurial drive - creates an unrivaled environment for the University to deliver research excellence.
Now in its second century of achievement, SMU is recognized for the ways it supports students, faculty and alumni as they become ethical, enterprising leaders in their professions and communities. SMU's relationship with Dallas - the dynamic center of one of the nation's fastest-growing regions - offers unique learning, research, social and career opportunities that provide a launch pad for global impact.
SMU is nonsectarian in its teaching and committed to academic freedom and open inquiry.
About the Department: Development and External Affairs (DEA) supports SMU by securing funding for University priorities; by promoting meaningful involvement in the life and work of the University; by heightening international, national, state and local awareness of SMU; and by supporting the enrollment of a diverse and able student body.
DEA comprises the offices of Office of the Senior Vice President, Annual Giving and Alumni Relations, Development Services, Program Services and Donor Relations, Marketing and Communications, Principal and Major Gifts, and School and Project Development.
SMU continues to leverage the benefits from the largest fundraising campaign in its history to achieve dramatic increases in academic quality and impact.
About the Position: This role is an on-campus, in-person position.
This role is primary responsible for system to systems data communications for the Development and External Affairs (DEA) team at SMU. This position is part of the Advancement Application and Technology Services group, which includes developer, support, and administrator for DEAs Fundraising tools. This role will build, trouble shoot, and enhance future and existing ETL, SSIS packages, and APIs, create new ETL and APIs, as well as, implement 3rd party APIs as needed.
Essential Functions: - Extract Translation and Load (ETL) development and application:
- Develop, maintain, and improve current ETLs to provide reporting and transactional database enhancements from a variety of sources, including the fundraising CRM, third-party, student information system, and financial systems. Help build future integrations with Salesforce and external technology solutions.
- Application Programming Interface (API) development and application:
- Develop, maintain, and improve existing and new API connections with on-premise and off-premise systems, including outbound and inbound data sets, to improve SMU's fundraising data sets in support of DEA's goals to meet SMU's mission. Support the selection of a middleware tool and help maintain it and the associated processes.
- Support:
- Participate in troubleshooting and analysis, and assist as needed in developing effective and efficient solutions as it relates to APIs, ETLs and other data issues. Be proactive with solutions and recommendations for improving processes and structures. Monitor integration performance and optimize for efficiency and scalability.
- Project Management:
- Participate in meetings and processes to track your work and time estimates using Development Services project tracking software. Collaborate with cross-functional teams to deliver high quality solutions. Document integration processes, workflows, and configurations for reference and training purposes.
- The position requires occasional evening and/or weekend work and occasional travel.
Education and Experience: Bachelor's degree is required. A Master's degree is preferred. A degree in Computer Science, Technology, or Engineering, desired.
A minimum of seven years of full-time software development work experience and at least three years working with ETL's and API's is required.
Experience in higher education and fundraising systems is preferred.
Knowledge, Skills and Abilities: Candidate must demonstrate strong interpersonal and verbal communication skills, with the ability to communicate broadly across the University and develop and maintain effective relationships with a wide range of constituencies. Must also demonstrate strong written communication skills. Candidate must be able to communicate effectively with technical and non-technical users.
Candidate must possess strong problem-solving skills with the ability to identify and analyze problems, as well as devise solutions. Must also have strong organizational, planning and time management skills. A strong focus on attention to detail and strong project management skills are essential.
Candidate must have the ability to use and understand large dataset. Must also be able to work independently and collaboratively with a team.
Candidate must have experience with CRM, API, and data warehouse. Experience with Blackbaud CRM or Salesforce is preferred. Experience writing APIs with C and/or .NET is desired. Experience writing ETL using MS SQL is a plus.
Candidate must have a strong working knowledge of MS Office Suite. Experience with SOSQL and Apex is preferred. Experience with Microsoft SQL queries and optimization is desired. Experience with Microsoft Visual Studio is a plus.
Physical and Environmental Demands: - Sit for long periods of time
Deadline to Apply: The position is open until filled.
Priority consideration may be given to submissions received by April 14, 2025
EEO Statement: SMU will not discriminate in any program or activity on the basis of race, color, religion, national origin, sex, age, disability, genetic information, veteran status, sexual orientation, or gender identity and expression. The Executive Director for Access and Equity/Title IX Coordinator is designated to handle inquiries regarding nondiscrimination policies and may be reached at the Perkins Administration Building, Room 204, 6425 Boaz Lane, Dallas, TX 75205 .
Benefits: SMU offers staff a broad, competitive array of health and related benefit s. In addition to traditional benefits such as health, dental, and vision plans, SMU offers a wide range of wellness programs to help attract, support, and retain our employees whose work continues to make SMU an outstanding education and research institution.
SMU is committed to providing an array of retirement programs that benefit and protect you and your family throughout your working years at SMU and, if you meet SMU's retirement eligibility criteria, during your retirement years after you leave SMU.
The value of learning at SMU isn't just about preparing our students for the future. Employees have access to a wide variety of professional and personal development opportunities , including tuition benefits .