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: • 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 tot his job Apply To this Job