Senior Systems Engineer

Required Qualifications: (as evidenced by an attached resume)
Bachelor's degree. In lieu of the Bachelor's degree a combination of higher education and relevant experience totaling eight [8] full-time years may be considered. Four (4) years of directly related experience. Experience scripting and working with SQL code. Experience working with databases, designing and developing ETL processes, integrating data from external on-premise and cloud data sources, and automating these processes into a data warehouse. Experience analyzing data.

Preferred Qualifications:
Advanced degree. Experience working with relational databases such as Microsoft SQL Server, Azure, or data warehouse database design, working with Microsoft Visual Studio, SSIS packages, or similar ETL tools. Experience developing analytics and reports. Experience working with ERP systems.

Brief Description:
The Department of Information Technology is a team-oriented office that requires business analysts who can work collaboratively on institutional priorities. The Senior Systems Engineer needs to have 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 to integrate data from external on-premise or cloud systems into the data warehouse. They will be designing complex reports and analytics, and are required to understand system operations, and data analysis, verify the structure, accuracy, and quality of the data, troubleshoot to support the data warehouse, and analysis.

The Senior Systems Engineer will give presentations and train end-users about the data and how to use the system. The incumbent must be able to communicate with others effectively. In the performance of all job duties, at all times be responsible for delivering optimal customer service, protecting institutional data and privacy, and the excellent delivery of solutions and services by following divisional and University policies, procedures, and processes.

• Design, develop and support new and current ETL processes to integrate data from various data systems and automate processes to load data 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.
• All other duties as assigned.

Special Notes:
The Research Foundation of SUNY is a private educational corporation. Employment is subject to the Research Foundation policies and procedures, sponsor guidelines and the availability of funding. FLSA Exempt position, not eligible for the overtime provisions of the FLSA. Minimum salary threshold must be met to maintain FLSA exemption.

This position will remain posted until filled or for a maximum of 30 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 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.

Job Number: 2300571Official Job Title: Senior Programmer/Analyst (Project)Job Field: Information TechnologyPrimary Location: US-NY-Stony BrookDepartment/Hiring Area: Division of Information Technology (DoIT)Schedule: Full-time Shift :Day Shift Shift Hours: 8:30-5PM Posting Start Date: Feb 23, 2023Posting End Date: Mar 25, 2023, 8:59:00 PMSalary:$95,000.00-$105,550.00Appointment Type: RegularSalary Grade:E79SBU Area:The Research Foundation for The State University of New York at Stony Brook

To apply, visit https://stonybrooku.taleo.net/careersection/2/jobdetail.ftl?job=2300571&tz=GMT-08%3A00&tzname=America%2FLos_Angeles

jeid-29e826bd69494a4aa08d56f183a5f9e9