Office of Institutional Research - Research Analyst/Programmer

Canton, Saint Lawrence County
Jul 14, 2014
St. Lawrence University seeks an experienced and dynamic candidate to fill an immediate opening for the position of Research Analyst and Programmer. Reporting to the Director of Institutional Research, with a dotted line to the Manager of Maintenance and Software Development, the successful candidate will provide technical, organizational and statistical support for a broad range of data analysis and assessment needs, maintain the IR data warehouse, and have primary responsibility for data reporting and web development. Essential Duties and Responsibilities: • Maintain and expand the IR Office’s extensive historical SQL data warehouse. Determine specifications and create processes to extract, transform and load data into the data warehouse from multiple databases and other data sources. • Ensure accuracy of data collected, identifying outliers and anomalies that require resolution prior to data reporting • Develop a customized repertoire of dynamic reports in support of reporting and analysis • Develop and support database programs, interfaces, and reports for consultant and other projects as needed • Update the University’s longitudinal trend analyses and fact sheets • Prepare and submit Federal, State, NCAA and other mandatory reports • Generate descriptive statistics of large datasets and summarize findings in short narrative reports, tables, charts and graphical format • Maintain and update in a timely manner IR and consumer information websites; develop custom design solutions of website in coordination with IT and Digital Communications staff • Respond to ad-hoc requests internally and externally • Serve on committees or project teams, contribute to larger data warehousing solution, and participate in larger scale web development testing as assigned • Assist with other duties Required Qualifications: • Bachelor’s degree and three years of demonstrated experience in a business or academic setting related to data extraction, analysis, reporting and web development (or any equivalent combination of education and training experience) • Strong quantitative and programming skills, including experiences with relational databases and other applications • Scrupulous attention to detail • Ability to organize, analyze and summarize data and information for multiple audiences • Strong oral and written communication skills • Ability to work with diverse constituencies and contribute to a team-based environment • Ability to handle confidential materials discreetly and professionally on a routine basis • Excellent time management skills; ability to work independently, multi-task and prioritize workflow in order to meet deadlines Preferred Qualifications: • Master’s degree in computer science or a related field • At least 2 years of working experience in Higher Education • Knowledge in SQL,.net, PHP, MSQL • Knowledge in web development applications such as Visual Studio, Drupal • Knowledge of multivariate statistics • Excellent graphic design skills • Familiarity with Ellucian/Colleague and Recruiter and Raiser’s Edge • Experience in working with reporting software such as Business Objects, SSRS Work Schedule and Reporting Structure This is a permanent full-time 12-month position. The Research Analyst/Programmer reports to the Director in a 2 FTE Office of Institutional Research and will work closely together with colleagues from the Libraries & Information Technology division. The position may have some supervisory responsibilities for student workers. Interested applicants must apply online at Review of applications will begin immediately and continue until the position is filled. All offers of employment are contingent upon the finalist successfully passing a background (including criminal records) check. Located in Canton, N.Y., St. Lawrence University is a coeducational, private, independent liberal arts institution of about 2,400 students from more than 40 states and 40 nations. The educational opportunities at St. Lawrence inspire students and prepare them to be critical and creative thinkers, to find a compass for their lives and careers, and to pursue knowledge and understanding for the benefit of themselves, humanity and the planet. Through its focus on active engagement with ideas in and beyond the classroom, a St. Lawrence education leads students to make connections that transform lives and communities, from the local to the global. The University is committed to and seeks diversity among its faculty, staff and students. Such a commitment ensures an atmosphere that is diverse and complex in ways that are intellectually and socially enriching for the entire campus community. Applications by members of all underrepresented groups, as well as from individuals with experience teaching or working in a multicultural environment, are encouraged. St. Lawrence University is an Equal Opportunity Employer. For additional information about St. Lawrence, please visit