Required Qualifications (as evidenced by an attached resume): Bachelor's Degree (foreign equivalent or higher). Four (4) years of directly related experience. Experience with SQL code. Experience working with databases and conducting data analyses. Experience designing and developing reports.
Preferred Qualifications: Experience working with relational databases such as Microsoft SQL Server, Azure or data warehouse database design. Experience with Microsoft Visual Studio. Experience developing SQL Server Reporting Services reports, and analytics. Experience working with T-SQL. Experience working with ERP.
Brief Description of Duties: The Department of Information Technology is a team-oriented office that requires business analysts who can work collaboratively on institutional priorities. The position of Senior Programmer/Analyst is a position that involves technical expertise and functional business understanding. The incumbent will design data models, implement, test, and comprehend how to source, load, map, transform and extract data according to customer requirements and system procedures. They will be designing complex reports and analytics, and are required to understand system operations, data analysis, verify the structure, accuracy, and quality of the data, troubleshoot to support the data warehouse, and analysis to design data structures, reports, and analyses. The incumbent will understand complex business processes and data such as financial, academic records, or human resources and the integration of these data systems. This position collaborates with colleagues on projects and performs various complex assignments. Opportunities will arise to work with non-relational and "big data" databases. The incumbent will be expected to be able to give presentations and train end-users about the data and how to use the system. The incumbent will have outstanding written, verbal, and interpersonal communication skills. Experience successfully working independently as well as part of a team with a collaborative approach to problem-solving.
This position requires an understanding of database architecture, and experience with building and designing database structures. This position will also work in T-SQL code and other programming languages to examine and understand data and business structures, test for quality assurance, and monitoring processes and performance in the database system. The incumbent will write, interpret and analyze data, and verify data models for accuracy to ensure the data are used correctly.
Design, develop and support new and current ETL processes to integrate data from various data systems into the data warehouse. Design and develop transformations to build data models for analyses and to be integrated with other data models. Analyze results to ensure the data models are accurate and function for analyses. Test for quality assurance and monitor processes and performance in the loading of data models.
Collect business requirements from business stakeholders and provide effective communication during the development process. Design and develop reporting and analytics that are appropriate to the audience and meet the specifications of the users. Analyze and provide data to respond to immediate data needs. Provide a high degree of customer support and satisfaction; engage with users on their requests and data needs; provide training and guidance regarding the understanding of data. Deploy and organize reporting content to appropriate areas.
Oversee and monitor daily operations and performance of ETL processes; maintain security groups and users with access to the data warehouse and analytics systems and data.
Training and documentation. Provide end-user training on the understanding of data, catalog of available reports, and how to use the data warehouse system to access and extract data.
Other duties or projects as assigned as appropriate to rank and department mission.
Special Notes: This is a full time appointment. FLSA Exempt position, not eligible for the overtime provisions of the FLSA. Minimum salary threshold must be met to maintain FLSA exemption. For this position, we are unable to sponsor candidates for work visas.
This has been designated as an essential position based on the duties of the job and the functions performed. Positions that are designated as such are required to report to work/remain at work even if classes are cancelled, and the campus is working on limited operations in an emergency.
This position will remain posted until filled or for a maximum of 60 days. An initial review of all applicants will occur two weeks from the posting date. For full consideration, applications must be received before the initial review date. If within the initial review no candidate was selected to fill the position posted, additional applications will be considered for the posted position; however, the posting will close once a finalist is identified, and at minimal, two weeks after the initial posting date.
Resume/CV and cover letter should be included with the online application.
Stony Brook University is committed to excellence in diversity and the creation of an inclusive learning, and working environment. All qualified applicants will receive consideration for employment without regard to race, color, national origin, religion, sex, pregnancy, familial status, sexual orientation, gender identity or expression, age, disability, genetic information, veteran status and all other protected classes under federal or state laws.
If you need a disability-related accommodation, please call the university Office of Equity and Access (OEA) at (631) 632-6280 or visit OEA .
In accordance with the Title II Crime Awareness and Security Act a copy of our crime statistics can be viewed here .
Visit our WHY WORK HERE page to learn about the total rewards we offer.
Official Job Title: Senior Programmer/Analyst
Job Field: Information Technology
Primary Location: US-NY-Stony Brook
Department/Hiring Area: DoIT/Enterprise Data Analytics-Stony Brook University
FROM ITS BEGINNINGS A HALF-CENTURY AGO, STONY BROOK UNIVERSITY HAS BEEN CHARACTERIZED by innovation, energy and progress, transforming the lives of people who earn degrees, work and make groundbreaking discoveries here. A dramatic trajectory of growth has turned what was once a small teacher preparation college into an internationally recognized research institution that is changing the world.