Data Engineer - Information Technology

Salary: Depends on Qualifications Location : Cape Girardeau, MO Job Type: Full-Time Job Number: 202400354 Division: Finance and Administration Department: Information Technology Opening Date: 10/18/2024 Position Summary Data Engineer Information Technology Full Time Primary Responsibilities Develop procedures for moving operational data into data repositories used for reporting and data analysis employing Extract, Transform, and Load (ETL) tools such as SSIS and Alteryx to automate data pipeline services Implement and document needed data mappings and transformations between data sources and data repositories Incorporate error checking and alerting procedures to ensure failed procedures are caught and corrected in a timely manner Develop and support stored procedures and SQL views and queries needed for data access, cleaning and transformations. Implement methods to improve data reliability and quality Work with the Office of Institutional Research to identify existing operational data sources to support the Enterprise Data Warehouse (EDW) and help develop database schemas and data models to support longitudinal data analysis Implement data access controls to support least privileged access policies for data supporting operational and strategic data uses Work with clients and the Office of Institutional Research to help develop needed reports and data dashboards; Use tools such as SSRS and Power Bi to develop and support reports and dashboards; Implement data models supporting data reporting needs Work with campus leadership to identify database platforms, data reporting and analysis tools, and data ETL systems that support campus data management needs and align with evolving technologies Required Qualifications Master's degree in computer science or related field or a bachelor's degree in computer science or related field along with four years of relevant experience Experience in data ETL processes and tools such as SSIS or Alteryx Experience developing queries and views in SQL Experience in reporting data using tools such as SSRS Experience with data visualization tools such as Power Bi Experience using database systems such as MS SQL Server or Snowflake Experience working in a team environment Ability to effectively communicate technical procedures and concepts, both in writing and verbally, to individuals without a technical background Demonstrated experience and understanding of customer service Required Information & Deadline Application Deadline : To ensure full consideration, application materials must be received by November 1, 2024 . The position is available immediately and will remain open until filled. To Apply: Complete the online application by clicking on the APPLY button at the top of the page and select the position title. For the application materials to be complete, attach the following items: letter of interest addressing all position qualifications resume names and contact information of three professional references may be asked for at a later date Additional Information About Southeast Missouri State University (SEMO): Founded in 1873 and accredited by the Higher Learning Commission, Southeast Missouri State University provides student-centered education and experiential learning with a foundation of liberal arts and sciences, embracing a tradition of access, exceptional teaching and commitment to student success that significantly contributes to the development of the region and beyond. SEMO values access to high quality, affordable education with a broadly representative student body, faculty and staff that respects and celebrates a diverse learning community in a global society. SEMO Fact Book: Institutional Research Factbook | SEMO SEMO Strategic Action Plan: Strategic Action Plan (semo.edu) Southeast Missouri State University provides an excellent benefits package. For complete benefit details visit our website at