Mississippi Gulf Coast Community College
Data Warehouse Engineer
Mississippi Gulf Coast Community College, Long Beach, Mississippi, United States, 39560
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 would like 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. Position Overview
The Data Warehouse Engineer is responsible for extracting, transforming, and processing data 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
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 standardizes the process of data collection, storage, transformation, distribution, and usage. Builds massive reservoirs for data and develops, constructs, tests, and maintains 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 on 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 on employee needs and the individuals 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. Performs other duties as assigned by the Executive Vice President of Technology & Research. Mandatory Qualifications
(M1)
Masters 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
(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, 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
compliance@mgccc.edu . 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 (*). #J-18808-Ljbffr
Apply to this Job
link/button. If you would like 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. Position Overview
The Data Warehouse Engineer is responsible for extracting, transforming, and processing data 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
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 standardizes the process of data collection, storage, transformation, distribution, and usage. Builds massive reservoirs for data and develops, constructs, tests, and maintains 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 on 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 on employee needs and the individuals 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. Performs other duties as assigned by the Executive Vice President of Technology & Research. Mandatory Qualifications
(M1)
Masters 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
(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, 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
compliance@mgccc.edu . 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 (*). #J-18808-Ljbffr