SQL Reporting Analyst

<p>Effective utilization of data is the primary responsibility of the dedicated SQL Reporting Analyst. Working closely with Advancement staff, the SQL Reporting Analyst gathers data requirements from fundraising staff, builds data criteria and output specifications based on input from staff, and may do the programming or work with other programmers to fulfill the data request.</p>

Baton Rouge, LA

LSU Foundation

<p>The LSU Foundation is the primary fundraising entity for academics at LSU.&nbsp;The LSU Foundation's sole purpose to provide philanthropic support to LSU, which we accomplish through the work of a campus-wide team of frontline development officers and a support team of advancement services, communications and marketing, donor relations, financial and talent management personnel. &nbsp;</p> http://www.lsufoundation.org/jobs

keywords: data utilization,collaboration,develop,analysis,troubleshoot,teamwork,degree,experience,knowledge

Analyst

Overview: <p>Effective utilization of data is the primary responsibility of the dedicated SQL Reporting Analyst. Working closely with Advancement staff, the SQL Reporting Analyst gathers data requirements from fundraising staff, builds data criteria and output specifications based on input from staff, and may do the programming or work with other programmers to fulfill the data request. &nbsp;The&nbsp;SQL Reporting Analyst is expected to be knowledgeable about LSU fundraising business processes, be timely in the delivery of requests, and work collaboratively with IS and Advancement. This position will report directly to the Information Services Manager within Advancement Services at the LSU Foundation.</p>
Responsibilities: <p><strong>Essential Duties &amp; Responsibilities</strong></p> <ul> <li>Actively develop reporting queries, hosted reports, data exports to flat files, data models, interactive dashboards and review product satisfaction with the requester</li> <li>Review and assess business requests for data and data usage</li> <li>Investigate and resolve technical issues with reports and ETL processes</li> <li>Maintain high degree of working knowledge of Ellucian Advance and other systems used in daily work in Advancement</li> </ul> <p><strong>Marginal Duties &amp; Responsibilities</strong></p> <ul> <li>Contributes to team objectives by accomplishing IT tasks as needed</li> </ul>
Requirements: <div class="job-listing-header"><strong>Requirements</strong></div> <div data-bind="html: Job.Requirements"> <ul> <li>Bachelor&rsquo;s degree in Computer Science, Information Technology from an accredited college or university or equivalent</li> <li>Experience with SQL server (T-SQL) or Oracle (PL-SQL)</li> <li>Experience with Microsoft Power BI or Tableau</li> <li>Strong understanding of stored procedures, packages, functions, views, and indexing</li> <li>Strong understanding of the Systems Development Lifecycle</li> </ul> <p><strong>Preferred Knowledge &amp; Skill Qualifications</strong></p> <ul> <li>Experience with Crystal Reports, SSRS, or other report program</li> <li>Experience with SSIS</li> <li>Experience working directly with customers or clients to understand business requirements</li> <li>Experience with query optimization</li> <li>Strong understanding of database and warehouse design principles</li> <li>Demonstrated experience in managing time effectively</li> <li>Demonstrated experience in utilizing problem solving techniques</li> <li>Experience with Object-oriented languages (Python, Powershell, C#, Java, JavaScript) a plus</li> </ul> <p><strong>Supervisory Responsibilities</strong></p> <ul> <li>None</li> </ul> <p><strong>Work Environment Requirements</strong></p> <ul> <li>May be required to occasionally work extended workdays, evenings or weekends</li> </ul> </div>