Programmer Analyst - Arcadia University : Job Details

Job Description: Under the leadership of the Director of Enterprise Applications, the Programmer Analyst will play a critical role in developing and supporting the university's data integration, data management, data warehouse and reporting and analytics. This position is partly funded by a Title III Strengthening Institutions Program grant and is subject to continued funding from the U.S. Department of Education. The Programmer Analyst will contribute to the Integration, Data and Reporting vertical within Enterprise Applications. The role will have responsibility for supporting integrations, developing and maintaining data pipelines, creating, organizing and streamlining data marts, and report and dashboard development and maintenance. In collaboration with IT and other departments, the Programmer Analyst will help ensure university data meets the FAIR principles of findability, accessibility, interoperability and reusability. This position is a hybrid role.

Location: Glenside

Responsibilities:

• Cultivate a deep understanding of University data and data lineage by collaborating with data stewards, Institutional Research and the Enterprise Applications team.
• Work with data stewards (e.g. Registrar, Career Services, etc.) of Data Warehouse data sources to ensure data transforms reflect business logic.
• Contribute to decisions regarding data quality, data architecture, and data organization. Bring a long term sustainability and scalability perspective.
• Support existing integrations and develop net new integrations within the University's integration framework (iPaas solution (Workato), Python framework and DBAmp tool).
• Develop and monitor data pipelines, stored procedures and other integration tools for new and existing data.
• Create and maintain Microsoft SQL stored procedures, functions and agent jobs to transform source data.
• Build and support PowerBI reports and dashboards.
• Contribute to the development and execution of a scalable PowerBI structure and maintenance plan.
• Assist in migrating legacy reports into PowerBI.
• Participate in the cross-department data analytics and data warehouse working groups.
• Assist in the maintenance of the University's data dictionary and data mart documentation. Update Confluence and other documentation to maintain institutional knowledge and infrastructure.
• Other Duties as assigned.

Qualifications:

Required:

• Bachelor's Degree from an accredited four year college in a related technology field and/or relevant professional experience preferred.
• 1-2 years of experience working with SQL or other query languages with moderate levels of complexity.
• 1-2 years of experience working with SSIS packages, Python, and/or an iPaas solution.
• 1-2 years of experience with a data reporting and visualization tool (PowerBI, Tableau, Looker).
• 1-2 years of professional experience in a data management capacity.
• Curiosity and willing to take initiative to understand business data definitions, use cases and logic behind ETL.
• Strong teamwork mentality and interpersonal communication skills with the ability to maintain effective working relationships with co-workers, vendors and the public are required.

Preferred:

• Experience in higher education or related industry.
• Experience working with Student Information System (PowerCampus, Colleague) and/or CRM (Salesforce) data.
• Experience with PowerBI.
• Experience with working in an iPaas solution.
• Experience with SSIS packages.

Application Instructions:

• Applications must be submitted online through Arcadia's Human Resources portal to receive full consideration. Please do not email application materials to the hiring manager. Due to the volume of applications received, communication will generally be limited to candidates selected for additional consideration.
• Application review will begin immediately. Posting will be removed from the website once we've established a sufficient talent pool for consideration.

Arcadia University is a top-ranked private University in Greater Philadelphia that provides a values-based, authentic educational experience by placing students at the center. The Institute of International Education has consistently ranked Arcadia first in the nation for study abroad, and the Princeton Review has ranked Arcadia among the Best in the Northeast for 10 consecutive years. The University's graduate programs in Physical Therapy, Physician Assistant, Education, and Public Health are nationally ranked in their respective categories by U.S. News & World Report, which cites Arcadia for being among the top study abroad programs and a top performer for social mobility. Arcadia is home to a close-knit and welcoming community that supports students throughout their journey. Arcadia's quality academic programs, unique approach to a liberal arts education, and supportive community guide students toward degree completion and career success. Learn more about our vibrant community at www.arcadia.edu.

We welcome candidates who can contribute to the excellence of our community. The successful candidate will demonstrate examples of ways they will incorporate our values in their work.

At Arcadia University, our Lived Values are the foundation of our highly regarded, values-based learning community, which reflects the world in which we want to live. As such, Arcadia actively seeks and welcomes candidates who embrace those values. Arcadia prohibits discrimination against individuals on the basis of ethnicity, national origin, ancestry, race, color, religion, creed, sex, gender, marital status, affectional or sexual orientation, age, gender identity, military or military veteran status, disability, family medical or genetic information, or any other legally protected characteristic. All offers of employment are conditional based on the successful completion of a background check. Employment may not begin until the University accepts the results of the background check.

Arcadia offers a competitive benefits package that includes excellent healthcare, generous tuition benefits for employees and their families, retirement benefits, health and wellness programs and resources, and much more.

Position Code: AC0245