Data Warehouse Engineer

Mississippi Gulf Coast Community College; Perkinston (MS); On-site; USD 70,000 - 90,000; Full time

Job summary

A regional community college in Perkinston, MS is seeking a Data Warehouse Engineer to develop and manage database tables, ensuring accurate data extraction and reporting. This role will require expertise in SQL and PL-SQL, along with experience in database engineering. The ideal candidate will work independently while collaborating with the Executive Vice President of Technology & Research. This position also involves troubleshooting and technical support within a data warehouse environment.

Qualifications

• Master's degree in a related field required for database architecture.
• Experience in developing databases and proficiency in Oracle is necessary.
• Excellent communication skills for conveying complex findings.

Responsibilities

• Develop/manage database tables for data processing in the data warehouse.
• Write SQL and PL-SQL procedures to extract data from multiple sources.
• Ensure data accuracy and troubleshoot technical issues in the data warehouse.

Skills

Database engineering

SQL

PL-SQL

Shell scripting

R programming

Linux

Education

Master’s degree in Computer Engineering, Computer Science, or related field

Ph.D. or progress towards it in related field

Tools

Oracle

Ellucian Banner

Windows Batch Scripting

Job description

Below you will find the details for the position including any supplementary documentation and questions you should review before applying to the opening. To apply to the position, please click the Apply to this Job link/button.

If you wouldUSEDwant to bookmark this position for later review, click on the Bookmark link. If you would like to print a copy of this position for your records, click on the Print Preview link.

The Data Warehouse Engineer is responsible for extracting, transforming, and data processing by developing/managing the corresponding database tables. The individual must be proficient in database engineering and have expertise in SQL /PL- SQL . The individual maintains and writes PL- SQL procedures and functions and ensures the warehoused tables update via a Cron schedule on the Linux-based server. Data from the warehoused tables are used in internal, state and federal reports. The position requires a high amount of independent technical work and ongoing communication with the Executive Vice President of Technology & Research.

Job Duties

SPECIFIC DUTIES & RESPONSIBILITIES

Engineering Tables in the Data Warehouse

1. Creates the database tables used to store the extracted and transformed data which are subsequently used as drivers of reports and dashboards. These tables are updated on a cron schedule on the Linux server using SQL and shell scripts to automate the process. As needs arise for new fields to be added to the tables, the Data Warehouse Engineer will code these fields, update all prior records to include the new data, and ensure the fields are populated automatically going forward.
2. Responsible for the organizational framework that standardize the process of data collection, storage, transformation, distribution, and usage.
3. Builds massive reservoirs for data and develop, construct, test, and maintain architectures and data processing systems.

Extracting Data

Writes SQL queries and PL- SQL procedures and functions to extract data from multiple sources, including the Oracle database-based Banner student information system and excel spreadsheets. Extraction from survey data spreadsheets and subsequent data transformation and loading utilizes scripting in R which are written and maintained by the Data Warehouse Engineer. Custom projects based on extracted data and extracting data to the planning system in Oracle Application Express are also the responsibility of the Data Warehouse Engineer.

Maintaining Tables in the Data Warehouse

Responsible for ensuring the data are updated and troubleshooting any technical issues that may arise in the data warehouse tables. Monitor the system performance by performing regular tests and integrating new features.

Verification & Validation of Data Elements

Assembles data from multiple sources, cleans and analyzes complex datasets in areas, including but not limited to: internal data requests, survey research, ad hoc research projects, assessments and evaluation, program/institutional accreditation, and state/federal reporting. Interprets the data with accuracy and presents key findings to internal and external stakeholders in a clear and concise manner.

Consultation

Designs and coordinates various ad hoc research projects based off of institutional need, facilitates the administration of assessments, and creates comprehensive evaluation plans.

General Responsibilities

1. Responsible for analyzing and reporting data to meet state, federal and accreditation deadlines.
2. Ensures that all reports and generated output are delivered with accuracy and by the established deadline.
3. Provides ongoing training, support and educational opportunities to our employees on IR related topics and promotes a culture of assessment at the institution. Prepares and presents employee development educational sessions based off employee needs and the individual’s area of expertise.
4. Works cooperatively and effectively with other college staff members, faculty and administration. Practices excellent customer service in their daily interaction with stakeholders.
5. Ability to work within strict deadlines. Able to work effectively in a high-pressure environment.
6. Assumes responsibility for special assignments initiated by the administration or our stakeholders.
7. High-level productive programmer who has a passion for designing and maintaining a data warehouse.
8. Works well with individuals from diverse backgrounds and personalities.
9. Adheres to all policies, procedures, and laws governing the employees of the institution.
10. Perform other duties as assigned by the Executive Vice President of Technology & Research.

Mandatory Qualifications

• Master’s degree in Computer Engineering, Computer Science, Computer Programming, or a related field requiring database architecture.
• Relevant coursework or significant work experience developing a database and proficiency in Oracle required.
• Demonstrated experience or have the experience to build reservoirs of data.
• Excellent oral and written communication skills; demonstrates the ability to communicate complex findings in a concise manner.
• Excellent time management and organizational skills.

Desirable Qualifications

• A Ph.D. or significant progress towards a terminal degree, in Computer Engineering, Computer Science, Computer Programming, or a closely related field requiring database architecture or data analysis from a regionally accredited institution of higher education.
• Strong background and technical skills working with Ellucian Banner, FTP, SSH, Linux, Crontab, Shell Scripting, SQL, PL- SQL, R, Oracle Application Express (APEX), Windows Batch Scripting.

EEO Statement

Mississippi Gulf Coast Community College is an Equal Opportunity Employer and welcomes students and employees without regard to race, color, religion, national origin, sex, pregnancy, age, or qualified disability in its programs and activities. For further information, contact the Compliance Officer P.O. Box 609, Perkinston, Mississippi, 39573, telephone number 601-528-8735, email address [e-mail].

The College

The Mississippi Gulf Coast Community College District serves a four-county area with three major campuses, the Community Campus and four centers including: Perkinston Campus, Perkinston, MS; Harrison County Campus, Gulfport, MS; Jackson County Campus, Gautier, MS. Additionally, Mississippi Gulf Coast Advanced Manufacturing and Technology Center, Gulfport, MS; Keesler Center, Biloxi, MS; West Harrison Center, Long Beach, MS; and George County Center, Lucedale, MS. State and regional associations accredit Mississippi Gulf Coast Community College, and several programs are accredited nationally. Offerings include academic, technical degree, vocational skill and adult continuing education programs.

Classification

Classification Administration

Open Date

Open Date 06/20/2022

Close Date

Open Until Filled Yes

Special Instructions to Applicants

For more information on the position, please contact (Name, Address, Phone, and Email):

Executive Vice President, Technology & Research
10298 Express Drive. Gulfport 39503

Required fields are indicated with an asterisk (*).

To ensure the security of your data, you will be logged out due to inactivity in 3 minutes at. Any data not saved will be lost. Click 'OK' to keep your session active.