All roles

Open role

SQL Developer / Ellucian Insights Report Writer

Remote · Kenya Full-time

SQL Developer / Ellucian Insights Report Writer Location Fort Lauderdale, FL (Remote) Duration 12 months (will go up to 3 years) Rate $60/hr on C2C (slightly negotiable for the right fit) Client Educational institutions The candidate should have a working background with educational institutions Key Skills SQL, Ellucian Insights, Ellucian Banner, Business Objects, and Argos Job Description The selected candidate will be responsible for the design, development, and maintenance of customized data models, reports, and/or dashboards using Ellucian Insights and SQL development as needed to support the Integrations team. The role requires a deep understanding of Ellucian data structures, Insights Objects, report development, and business analysis to deliver high-quality, actionable insights for the organization. Scope of Work Under the direction of the Reporting Technical Lead of the SIS project, the Ellucian Insights Report Writer/SQL Developer will be tasked with the following

  • Review and as needed, create new Data Specification Documents (requirements) to ensure they include the required information from the Reports Inventory Smartsheet and data mapping documents, and follow naming standards.
  • Leverage Ellucian's data model to create, modify, and optimize reports, dashboards, or data models based on the Data Specification Document.
  • Develop customized reports, dashboards, and/or data models using Ellucian Insights to provide meaningful and actionable data.
  • SQL Develop/maintain PostgreSQL snippets as appropriate within the Insights environment. Provide SQL development/maintenance as needed to support the Integrations team. Data Analysis and Reporting
  • Analyze data from Ellucian SIS (Student Information System) and other relevant data sources as appropriate.
  • Design appropriate objects (reports, dashboards, data models, SQL code) to enhance decision-making processes across departments. Collaboration
  • Work closely with departmental teams (e.g., Institutional Research, Information Technology, Academic Affairs) to gather report specifications and feedback on delivered objects.
  • Collaborate with data engineers and analysts to troubleshoot and resolve data-related issues.
  • Openly share knowledge on all work. This may include issues encountered, resolutions to issues, and workarounds implemented. Report Maintenance and Optimization
  • Ensure the accuracy, integrity, and timeliness of all objects (reports, dashboards, data models, SQL code, etc.).
  • Troubleshoot and resolve issues related to object (reports, dashboards, data models, etc.) execution and data quality. Documentation and Training
  • Document object (reports, dashboards, data models) creation processes, data sources, and methodologies.
  • Provide training and support to colleagues and/or end-users on how to use and interpret reports. Skills Required Report Writer/SQL Developer Experience needed
  • 5+ years within a reporting realm preferably in a college or university setting developing business intelligence solutions based on reporting tools
  • 5+ years of SQL programming skills - preferably in a data warehouse environment
  • 5+ years of demonstrated experience solving business challenges using Argos, Ellucian Insights, and Business Objects
  • 5+ years of experience with Banner tables across the entire Banner software suite Ellucian Insights Report Writer/SQL Developer
  • Develop and deploy business intelligence solutions based on supported Ellucian Banner reporting tools, including Ellucian Insights and business objects, using data sourced from Banner and the Operational Data Store (ODS)
  • Openly share knowledge on object creation/maintenance and any other Ellucian tools. This may include issues encountered, resolutions to issues, and workarounds implemented.
  • Perform implementation services such as training, functional consulting, and technical support Apply To this Job Apply To this Job

More open positions

Metrics Advisor (SQL Developer)

Work from home Full-time role

Staff data analyst (sql developer)

Work from home Full-time role

SQL Developer, Mid Level; Remote

Work from home Full-time role

Staff Data Analyst (SQL Developer)

Work from home Full-time role

Prophet 21 SQL Developer

Work from home Full-time role

Field Admissions Rep Remote Territory - Pensacola

Work from home Full-time role

Commercial Escrow Assistant

Work from home Full-time role

Remote Electrical Engineer 4

Work from home Full-time role

[Remote] Mainframe DevOps Migration Consultant

Work from home Full-time role

Remote LCSW - Telehealth

Work from home Full-time role

Veteran IT Talent Network Transitioning Service Members and Military Spouses

Work from home Full-time role

Contract Negotiation Manager - PA, OH, WV, and Deleware

Work from home Full-time role

Sr Systems Engineer

Work from home Full-time role

Medical Director, Child and Adolescent Psychiatrist (New York, Remote - Full time)

Work from home Full-time role

Change & Release Coordinator 3

Work from home Full-time role

Bookkeeper - Remote in DC/MD/VA area

Work from home Full-time role

Collections Specialist (Bilingual English/Spanish) | Remote (Mexico)

Work from home Full-time role

Experienced Virtual Assistant - UPS Data Entry Clerk Typing: Remote Work Opportunity with careerzynith

Work from home Full-time role

Analyst, Procurement Systems (remote)

Work from home Full-time role

Clinical Nurse Auditor, HEDIS Remote Part Time WA OR

Work from home Full-time role

Customer Care Agent

Work from home Full-time role