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<https://hr.cofc.edu/benefits/index.php> 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 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 ----- To learn more about Jobs at the College of Charleston, please visit https://jobs.cofc.edu To unsubscribe, send a message to [log in to unmask] with the words UNSUBSCRIBE JOBPOSTINGS in the message body. Did you receive this from someone else? You can subscribe to this list by sending a message to [log in to unmask] with the words SUBSCRIBE JOBPOSTINGS in the message body.