Application Programmer Analyst*

POSTING INFORMATION

Internal Title

Application Programmer Analyst*

Position Type

Classified

Faculty / Non-Faculty / Administration

Non-Faculty

Pay Band

7

Level

5

Department

Office of Enrollment Information

Job Purpose

The Application Program Analyst serves as the lead programmer and data process developer within the College of Charleston’s Division of Enrollment Planning. This role leads and supports projects related to developing standardized and automated data processes that enable accurate and efficient sharing of data and information. Primary job duties include custom programming in multiple languages, ETL process and data pipeline development, business intelligence development support, and process documentation. This position is collaborative with multiple offices within the Division of Enrollment Planning and the Division of Information Technology.

Minimum Requirements

Bachelor’s degree in computer science, information technology, computer information systems, or similar field. Work experience in computer programming, software application development, workflow development, project management, and/or systems analysis. Experience in a higher education setting preferred. Candidates with an equivalent combination of experience and/or education are encouraged to apply.

Required Knowledge, Skills and Abilities

Required

• Demonstrated understanding of relational database and data warehousing concepts and architectures, ETL architectures, API management, system integrations, and web/cloud applications
• Understanding of project management concepts and agile methodology
• Proficiency in one or more programming languages; emphasis on Java and SQL but also Python and/or R
• Experience developing ETL processes within Informatica or similar middleware application(s)
• Proficiency with Microsoft Office 365 applications, namely Excel, Teams, SharePoint, and PowerPoint
• Superior skill and passion for technical problem solving and logic development
• Excellent attention to detail and commitment to data accuracy and security
• Talent for conceiving of ways to enhance data and business process efficiencies
• Eagerness to research, learn, and teach how to utilize new software applications
• Ability to be proactive in a fast-paced environment and effectively prioritize competing requests and tasks
• Professional, clear, effective communication style when collaborating with team members and end users
• Self-motivated to work toward continuous improvement in all aspects of the job

Preferred

• Experience with any of the following applications: Salesforce, TargetX, Tableau, Apex, Visualforce, Informatica, Axiom Elite, Git
• Experience working and/or developing within relational databases such as Salesforce or other CRM systems
• An understanding of business processes and best practices in admissions and higher education
• Relevant software or technology certifications or badges

Additional Comments Regarding Position

*Depending upon experience level, this position can accommodate preferences for remote, hybrid remote, or on-campus work schedules.

Special Instructions to Applicants

A resume is required with application submission. Cover letter strongly encouraged. College transcript(s) showing relevant coursework encouraged.
Please complete the application to include all current and previous work history and education. A resume will not be accepted nor reviewed to determine if an applicant has met the qualifications for the position.
**Salary is commensurate with education/experience which exceeds the minimum requirements.
Offers of employment are contingent upon a successful background check.
All applications must be submitted online https://jobs.cofc.edu.

Salary

**$66,821 - $75,000

Posting Date

09/26/2023

Closing Date

10/05/2023

Benefits

• Insurance: Health/Dental/Vision
• Life Insurance
• Paid Leave: Sick/Annual/Parental
• Retirement
• Long Term Disability
• Paid Holidays
• Free CARTA Bus Service
• Employee Tuition Assistance Program (ETAP)
• Employee Assistance Program (EAP)
• Full Benefits Package – Click Here

Open Until Filled

No

Posting Number

2023167

EEO Statement

The College of Charleston is an Affirmative Action/Equal Opportunity employer and does not discriminate against any individual or group on the basis of gender, sexual orientation, gender identity or expression, age, race, color, religion, national origin, veteran status, genetic information, or disability.

Quicklink for Posting

https://jobs.cofc.edu/postings/14530

Job Duties

Activity

Custom programming

Develops custom programming to enhance data transfer and ETL processes, CRM functionality, and statistical modeling routines. Writes custom code in one or more C-family programming languages including but not limited to Java, Python, and R. Constructs SQL-based queries and logic in Informatica, Cognos, Argos, and other applications. Contributes to the development of objects, custom coded features, and user interfaces in Salesforce (SOQL, Apex, Visualforce, etc.) and other platforms. Organizes scripts using version control systems (e.g., Git). Serves as subject matter expert and teacher for team members developing their own programming skills.

Essential or Marginal

Essential

Percent of Time

40

Activity

Data pipeline development

Leads and supports data pipeline development projects for transferring data and information efficiently and accurately between systems and databases. Designs, determines functional requirements for, develops and implements ETL processes utilizing a variety of applications including but not limited to Informatica, Axiom Elite, Tableau Prep, Cognos, Argos, and custom programming. Effectively captures and communicates data pipeline details and mappings using tables and diagrams. Schedules and monitors automated data transfer jobs. Enhances scheduled job efficiencies to optimize traffic and performance given database capacity and API limits. Contributes to SFTP setup and maintenance.

Essential or Marginal

Essential

Percent of Time

40

Activity

Business intelligence development

Collaborates with team members for report development in Salesforce, Cognos Analytics, Argos, and other BI tools for the purpose of summarizing admissions, financial aid, and marketing data. Contributes to the development of reports and dashboards in Salesforce and Tableau. Aids with maintenance and enhancements to dashboard functionality, content, and features.

Essential or Marginal

Essential

Percent of Time

15

Activity

Process documentation
Develops and maintains data and business process documentation in written and visual forms to ensure continuity. Ensures that documentation is maintained and accurately represents current processes. Effectively translates technical procedures to forms of documentation that are understandable to non-experts. Periodically solicits feedback from colleagues to ensure documentation is interpretable and implementable by others.

Essential or Marginal

Essential

Percent of Time

5