Business Intelligence & Systems Developer – Thomas Jefferson University (Philadelphia, PA)

Job Details Develop APIs and workflows to assist in managing the constituent database for the Office of Institutional Advancement (OIA) with a focus on developing reports and data visualizations for OIA teams and moving data between systems such as Cvent, HiveBrite, and financially related software into the Salesforce Enterprise CRM system. Job Description Provide day to day system development and support for the Salesforce CRM system, including connections to marketing tools such as the Marketing Cloud and Account Engagement modules; create business intelligence (BI) reports and visual analytics dashboards for the Office of Institutional Advancement (OIA) teams such as Gift Administration, Events, and the Alumni Association; and develop application programming interfaces (APIs) and Load Tools to perform mass data changes and imports into the constituent database. Develop data management workflows to support multiple Salesforce environments and to manage the flow of data between the Cvent event data management system and the Salesforce CRM to support the Events team; support the Alumni community on systems such as Cvent and the Hivebrite online community platform by developing reports, establishing and maintaining security measures, and supporting mobile applications (iOS and Android); create and maintain documentation around automation processes, transformations, data standards, and reports; collaborate with Salesforce Administrators to coordinate updates, tool implementation, and education; automate the Gift Administration and Data Quality audits, form letters, and data feeds to support Information Management & Analytics teams; and collaborate with the data architect to define data changes to the Operational Data Store (ODS) for reporting and analysis needs. Requirements: Requires a Bachelor’s degree in Information Systems or a related field and 5 years of experience or alternatively, Master’s degree in same and 3 years of experience. Experience must include: Working with the Salesforce CRM system, the Cvent event data management system, the HiveBrite online community platform, BI tools (Qlik Sense, SSRS) for report, data visualization and dashboard development, T-SQL programming, and API development and management. Apply online at jeffersonhealth.org/about-us/careers. Work Shift Workday Day (United States of America) Worker Sub Type Regular Primary Location Address 1101 Market, Philadelphia, Pennsylvania, United States of America Nationally ranked, Jefferson, which is principally located in the greater Philadelphia region, Lehigh Valley and Northeastern Pennsylvania and southern New Jersey, is reimagining health care and higher education to create unparalleled value. Jefferson is more than 65,000 people strong, dedicated to providing the highest-quality, compassionate clinical care for patients; making our communities healthier and stronger; preparing tomorrow's professional leaders for 21st-century careers; and creating new knowledge through basic/programmatic, clinical and applied research. Thomas Jefferson University, home of Sidney Kimmel Medical College, Jefferson College of Nursing, and the Kanbar College of Design, Engineering and Commerce, dates back to 1824 and today comprises 10 colleges and three schools offering 200 undergraduate and graduate programs to more than 8,300 students. Jefferson Health, nationally ranked as one of the top 15 not-for-profit health care systems in the country and the largest provider in the Philadelphia and Lehigh Valley areas, serves patients through millions of encounters each year at 32 hospitals campuses and more than 700 outpatient and urgent care locations throughout the region. Jefferson Health Plans is a not-for-profit managed health care organization providing a broad range of health coverage options in Pennsylvania and New Jersey for more than 35 years. Jefferson is committed to providing equal educational and employment opportunities for all persons without regard to age, race, color, religion, creed, sexual orientation, gender, gender identity, marital status, pregnancy, national origin, ancestry, citizenship, military status, veteran status, handicap or disability or any other protected group or status. In keeping with Jefferson's Mission, We Improve Lives, it is our goal to recruit, retain, develop and reward highly-qualified employees. If you are enthusiastic, caring and dedicated to service excellence, we invite you to consider joining Jefferson. Jefferson encourages its employees to expand their knowledge and develop their careers through growth opportunities and continuing education. With a long standing history, Jefferson has been advancing the medical field from the heart of Center City Philadelphia for nearly 200 years. Our Mission, We Improve Lives, expands to every corner of the organization. From our weekly farmer’s market, to our new Jefferson Accelerator Zone for innovation, our employees’ passion for the community is evident by the daily gestures towards our patients, students and each other.