Programmer Analyst
Programmer Analyst
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Job Description: Under the leadership of the Director of Enterprise Applications the Programmer Analyst will play a critical role in developing and supporting the universitys 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 Universitys 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 Universitys data dictionary and data mart documentation. Update Confluence and other documentation to maintain institutional knowledge and infrastructure.
- Other Duties as assigned.
Qualifications:
Required:
- Bachelors 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 Arcadias 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 weve 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. Housed in the College of Health Sciences the Universitys Physical Therapy program is ranked as the best in the Philadelphia region (and #2 in PA) by U.S. News & World Report which also 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. Arcadias 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 .
We welcome candidates who can contribute to the diversity and excellence of our community. The successful candidate will demonstrate examples of ways they will incorporate our values in their work.
Arcadia actively seeks and welcomes candidates of diverse backgrounds and abilities. 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
Required Experience:
IC
Employment Type
Full-Time
