Application Programmer Analyst*

Posting Details

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

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

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

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