SQL Developer / Ellucian Insights Report Writer

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:

Report Development and Design:
• 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