Business Intelligence Developer / AS1356P

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

Job summary

Mississippi Gulf Coast Community College in Gulfport, MS seeks a Business Intelligence Developer to design and optimize SQL/PL/SQL queries and develop reporting contents in Argos and Tableau. You will collaborate with stakeholders to translate requirements into effective data solutions, support data governance, and ensure accuracy, security, and timely delivery of reports.

The role requires independent technical work and ongoing communication with the Associate Vice President of Reporting & Data

Qualifications

• Bachelor's or Master's degree in Computer Engineering, Computer Science, or Computer Programming with programming experience.
• Experience with SQL and PL/SQL to extract, transform, and load data from various sources.
• Excellent written and oral communication; ability to convey complex findings concisely.

Responsibilities

• Write and maintain SQL/PL/SQL scripts for ETL and reporting.
• Design, develop, and maintain reports in Argos and Tableau.
• Validate data quality and ensure data integrity for state and federal reporting.
• Collaborate with stakeholders to translate requirements into data solutions.

Skills

SQL

PL/SQL

Argos

Tableau

Data governance

Data analysis

Education

Bachelor's degree in Computer Science/Engineering/Programming

Master's degree in Computer Science/Engineering/Programming

Tools

Banner

Linux

Shell Scripting

Oracle APEX

Job description

This position is for an Business Intelligence Developer with a company located in Gulfport, MS.

Job Description: The Reporting & Data Analytics Office is seeking a skilled programmer proficient in SQL and PL/SQL. The ideal candidate will be responsible for developing, maintaining, and optimizing complex SQL and PL/SQL queries and scripts to extract, transform, and analyze data from various sources. The candidate will collaborate with stakeholders to understand reporting requirements and translate them into effective data solutions using Argos and Tableau. This role will also play a key role in data governance, ensuring data accuracy, integrity, and security within the organization. Strong programming and analytical skills as well as attention to detail are essential for success in this role. The position requires a high amount of independent technical work and ongoing communication with the Associate Vice President of Reporting & Data Analytics.

Job Duties

PROGRAMMING RESPONSIBILITIES

• This role requires expertise in SQL and PL/SQL programming languages, as well as a deep understanding of relational databases within Banner and data modeling concepts.
• Write and maintain SQL and PL/SQL scripts to extract, transform, and load data from various sources to satisfy internal, state, and federal reporting requirements.
• Responsible for designing, developing, and maintaining reporting contents within Argos and Tableau.
• Design and optimize database queries and procedures to ensure efficient data retrieval and processing for reporting purposes.
• Perform data validation and quality assurance checks to ensure the accuracy and integrity of reports produced for internal, state, and federal agencies.
• Stay informed about changes in reporting regulations and requirements at the state and federal levels and update reporting processes accordingly. Ensures that all reports and generated output are delivered with accuracy and by the established deadline.
• Provide technical support and training to end-users on report generation tools, such as Argos and Tableau, and techniques to facilitate self-service reporting capabilities.
• Troubleshoot and resolve issues related to data integrity, report accuracy, and performance to maintain compliance with reporting requirements.
• Document reporting processes, procedures, and technical specifications to ensure clarity and consistency in report development and maintenance.

Communication

• Strong communication and collaboration skills are essential for effectively interacting with team members and stakeholders to deliver high-quality reporting solutions that meet business needs.
• Collaborate with cross-functional teams, including academic departments, and administrative units, to integrate data science solutions into institutional workflows and systems, fostering a data-driven culture.
• Work cooperatively and effectively with other college staff members, faculty and administration.
• Practice excellent customer service in their daily interaction with stakeholders.

General

• 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.
• Adheres to all policies, procedures, and laws governing the employees of the institution.
• Perform other duties as assigned by the Associate Vice President of Reporting & Data Analytics.

Mandatory Qualifications

• (M1) Bachelor's degree in Computer Engineering, Computer Science, Computer Programming with a minimum of three years of programming work experience OR Master's degree in Computer Engineering, Computer Science, Computer Programming.
• (M2) Relevant coursework or significant work experience programming using SQL and/or PL SQL.
• (M3) Experience writing SQL and PL/SQL scripts to extract, transform, and load dat from various sources.
• (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) Ph.D. in Computer Engineering, Computer Science, Computer Programming from a regionally accredited institution of higher education.
• (D2) Strong background and technical skills working with Ellucian Banner, FTP, SSH, Linux, Shell Scripting, SQL, PL-SQL, R, Oracle Application Express (APEX), Windows Batch Scripting.

EEO/Compliance

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, The Bryant Center at Tradition, Biloxi, MS; Advanced Manufacturing and Technology Center, Gulfport, MS; Haley Reeves Barbour Maritime Training Academy, Pascagoula, MS; Naval Construction Battalion Center, Gulfport, MS; Keesler Center, Biloxi, MS; The 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.