drjobs NC - UNCP - Banner SQL Query Writer

NC - UNCP - Banner SQL Query Writer

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Raleigh - USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

UNCP is seeking a Banner SQL Query Writer that will be responsible for designing developing and optimizing SQL queries to extract manipulate and analyze data from Ellucian Banner to support data integration needs within Softdocs Etrieve platform.
UNCP is seeking a Banner SQL Query Writer that will be responsible for designing developing and optimizing SQL queries to extract manipulate and analyze data from Ellucian Banner to support data integration needs within Softdocs Etrieve platform.

***This is a part time position for 20/hour a week. Hours must be worked between 8AM - 5PM EST Monday - Friday.

***This position will be remote for the duration of the engagement.

Key responsibilities

Design write and optimize SQL queries (including stored procedures functions and views) to meet integration requirements between Banner and Softdocs Etrieve.
Analyze and interpret business requirements and translate them into efficient and accurate SQL queries within the Softdocs Etrieve platform.
  • Collaborate with business analysts developers and other stakeholders to understand data needs and ensure the accuracy and efficiency of generated data extracts.
  • Create and maintain comprehensive technical documentation for SQL queries and data flows to ensure reusability and maintainability.
  • Troubleshoot and resolve data-related issues ensuring data integrity and consistency between Banner and Softdocs Etrieve.
  • Participate in testing and validation of data extracts to ensure they meet quality standards and user requirements.
  • Stay up-to-date with best practices for SQL query writing database optimization and data security to enhance the quality and performance of data extracts.

Required skills and experience

  • Demonstrated experience working with relational databases particularly Ellucian Banner and understanding of its data structure and schemas.
  • Familiarity with Softdocs Etrieve platform and its integration capabilities with Banner.
  • Hands-on experience with Ellucian Banner ERP
  • Excellent analytical and problem-solving skills to interpret complex data requirements and design appropriate solutions.
  • Ability to work collaboratively within a team environment and communicate effectively with both technical and non-technical stakeholders.
  • Bachelors degree in Computer Science Information Technology or a related field or equivalent experience.
  • Strong proficiency in SQL syntax and query writing.

Desired skills

  • Experience with scripting languages like PL/SQL JSON or others used for data manipulation and automation.

  • Familiarity with higher education business processes.

Employment Type

Full-time

Company Industry

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.