Data Warehouse Engineer Job Perkinston Mississippi USA,IT/Tech

Location: Perkinston

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

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.

Responsible for the organizational framework that standardize the process of data collection, storage, transformation, distribution, and usage.

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

Responsible for analyzing and reporting data to meet state, federal and accreditation deadlines.

Ensures that all reports and generated output are delivered with accuracy and by the established deadline.

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.

Works cooperatively and effectively with other college staff members, faculty and administration. Practices excellent customer service in their daily interaction with stakeholders.

Ability to work within strict deadlines. Able to work effectively in a high-pressure environment.

Assumes responsibility for special assignments initiated by the administration or our stakeholders.

High-level productive programmer who has a passion for designing and maintaining a data warehouse.

Works well with individuals from diverse backgrounds and personalities.

Adheres to all policies, procedures, and laws governing the employees of the institution.

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…