Data Warehouse Engineer
Apply NowCompany: Mississippi Gulf Coast Community College
Location: Perkinston, MS 39573
Description:
Posting Details
Position Information
Job Title
Data Warehouse Engineer
Job Description
GENERAL STATEMENT OF FUNCTION:
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:
4. 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:
5. 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:
6. 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:
7. 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
8. Responsible for analyzing and reporting data to meet state, federal and accreditation deadlines.
9. Ensures that all reports and generated output are delivered with accuracy and by the established deadline.
10. 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.
11. Works cooperatively and effectively with other college staff members, faculty and administration. Practices excellent customer service in their daily interaction with stakeholders.
12. Ability to work within strict deadlines. Able to work effectively in a high-pressure environment.
13. Assumes responsibility for special assignments initiated by the administration or our stakeholders.
14. High-level productive programmer who has a passion for designing and maintaining a data warehouse.
15. Works well with individuals from diverse backgrounds and personalities.
16. Adheres to all policies, procedures, and laws governing the employees of the institution.
17. Perform other duties as assigned by the Executive Vice President of Technology & Research.
Mandatory Qualifications
MANDATORY: (M1) Master's degree in Computer Engineering, Computer Science, Computer Programming, or a related field requiring database architecture (M2) Relevant coursework or significant work experience developing a database and proficiency in Oracle required. (M3) Demonstrated experience or have the experience to build reservoirs of data. (M4) Excellent oral and written communication skills; demonstrates the ability to communicate complex findings in a concise manner. (M5) Excellent time management and organizational skills.
Desirable Qualifications
DESIRABLE: (D1) 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. (D2) 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, religion, color, national origin, sex, 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 [redacted], email address [redacted].
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
Administration
Posting Detail Information
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):
Adam Swanson
Executive Vice President, Technology & Research
10298 Express Drive. Gulfport 39503
Position Information
Job Title
Data Warehouse Engineer
Job Description
GENERAL STATEMENT OF FUNCTION:
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:
4. 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:
5. 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:
6. 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:
7. 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
8. Responsible for analyzing and reporting data to meet state, federal and accreditation deadlines.
9. Ensures that all reports and generated output are delivered with accuracy and by the established deadline.
10. 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.
11. Works cooperatively and effectively with other college staff members, faculty and administration. Practices excellent customer service in their daily interaction with stakeholders.
12. Ability to work within strict deadlines. Able to work effectively in a high-pressure environment.
13. Assumes responsibility for special assignments initiated by the administration or our stakeholders.
14. High-level productive programmer who has a passion for designing and maintaining a data warehouse.
15. Works well with individuals from diverse backgrounds and personalities.
16. Adheres to all policies, procedures, and laws governing the employees of the institution.
17. Perform other duties as assigned by the Executive Vice President of Technology & Research.
Mandatory Qualifications
MANDATORY: (M1) Master's degree in Computer Engineering, Computer Science, Computer Programming, or a related field requiring database architecture (M2) Relevant coursework or significant work experience developing a database and proficiency in Oracle required. (M3) Demonstrated experience or have the experience to build reservoirs of data. (M4) Excellent oral and written communication skills; demonstrates the ability to communicate complex findings in a concise manner. (M5) Excellent time management and organizational skills.
Desirable Qualifications
DESIRABLE: (D1) 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. (D2) 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, religion, color, national origin, sex, 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 [redacted], email address [redacted].
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
Administration
Posting Detail Information
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):
Adam Swanson
Executive Vice President, Technology & Research
10298 Express Drive. Gulfport 39503