This position will be remote for the duration of the engagement.DescriptionThe client 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.Key responsibilitiesDesign, 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 experienceStrong proficiency in SQL syntax and query writing.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 ERPExcellent 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.Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent experience.Desired skillsExperience with scripting languages like PL/SQL, JSON, or others used for data manipulation and automation.Familiarity with higher education business processes.Required / Desired SkillsSkill Required / Desired Amount of ExperienceStrong proficiency in SQL syntax and query writing. Required 3 YearsDemonstrated experience working with relational databases, particularly Ellucian Banner, and understanding of its data structure and schemas. Required 3 YearsFamiliarity with Softdocs Etrieve platform and its integration capabilities with Banner. Required 3 YearsHands-on experience with Ellucian Banner ERP Required 3 YearsExcellent analytical and problem-solving skills to interpret complex data requirements and design appropriate solutions. Required 3 YearsAbility to work collaboratively within a team environment and communicate effectively with both technical and non-technical stakeholders. Required 3 YearsBachelor's degree in Computer Science, Information Technology, or a related field, or equivalent experience. Required 3 YearsExperience with scripting languages like PL/SQL, JSON, or others used for data manipulation and automation. Desired 3 YearsFamiliarity with higher education business processes. Desired 3 YearsNotes: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. VIVA is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that VIVA will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status
DescriptionThe client 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.Key responsibilitiesDesign, 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 experienceStrong proficiency in SQL syntax and query writing.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 ERPExcellent 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.Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent experience.
Desired skillsExperience with scripting languages like PL/SQL, JSON, or others used for data manipulation and automation.Familiarity with higher education business processes.Required / Desired SkillsSkill Required / Desired Amount of Experience
Strong proficiency in SQL syntax and query writing. Required 3 YearsDemonstrated experience working with relational databases, particularly Ellucian Banner, and understanding of its data structure and schemas. Required 3 YearsFamiliarity with Softdocs Etrieve platform and its integration capabilities with Banner. Required 3 YearsHands-on experience with Ellucian Banner ERP Required 3 YearsExcellent analytical and problem-solving skills to interpret complex data requirements and design appropriate solutions. Required 3 YearsAbility to work collaboratively within a team environment and communicate effectively with both technical and non-technical stakeholders. Required 3 YearsBachelor's degree in Computer Science, Information Technology, or a related field, or equivalent experience. Required 3 YearsExperience with scripting languages like PL/SQL, JSON, or others used for data manipulation and automation. Desired 3 YearsFamiliarity with higher education business processes. Desired 3 YearsNotes:
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.
(Please ensure email matches your resume email)
(document types allowed: doc/docx/rtf/pdf/txt) (max 2MB)
By submitting this form, you are consenting to the VIVA team contacting you via Phone/Email