Logo
Southeast Missouri State University

Data Engineer - Information Technology

Southeast Missouri State University, Cape Girardeau, Missouri, United States, 63705


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 EngineerInformation TechnologyFull Time

Primary ResponsibilitiesDevelop 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 servicesImplement and document needed data mappings and transformations between data sources and data repositoriesIncorporate error checking and alerting procedures to ensure failed procedures are caught and corrected in a timely mannerDevelop and support stored procedures and SQL views and queries needed for data access, cleaning and transformations. Implement methods to improve data reliability and qualityWork 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 analysisImplement data access controls to support least privileged access policies for data supporting operational and strategic data usesWork 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 needsWork 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 technologiesRequired 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 experienceExperience in data ETL processes and tools such as SSIS or AlteryxExperience developing queries and views in SQLExperience in reporting data using tools such as SSRSExperience with data visualization tools such as Power BiExperience using database systems such as MS SQL Server or SnowflakeExperience working in a team environmentAbility to effectively communicate technical procedures and concepts, both in writing and verbally, to individuals without a technical backgroundDemonstrated experience and understanding of customer serviceRequired 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 qualificationsresumenames 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 | SEMOSEMO 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