Data Processing Analyst 2

Louisiana State University; United States; On-site; USD 65,000 - 90,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Life insurance

Flexible spending accounts

Retirement options

Paid holidays

Wellness benefits

Tuition exemption

Training and development opportunities

Employee discounts

Job summary

Louisiana State University is seeking a data analyst to consolidate, analyze, and visualize data by generating reports using SQL, MSSQL/MySQL, Sharepoint, Salesforce, and Tableau.

You will support marketing, retention, and management teams by collecting data, building reports, and providing timely results. The role involves maintaining electronic reporting systems and collaborating with LSU Digital and Continuing Education staff to meet reporting needs.

Qualifications

• Bachelor's degree in related field and 2 years of related experience
• Proficiency in writing and understanding SQL, Tableau, and Salesforce report writing
• Preferred: Bachelor's degree in related field and 3 years of related experience
• Proficiency in writing and understanding SQL Reporting Services, Sharepoint report writing, Tableau, Data Warehouses, and AWS

Responsibilities

• Design, manage, and implement electronic reports (financial, enrollment, demographic, marketing, course procedures, student progress).
• Maintain reporting systems: Sharepoint, SQL Reporting Services, Jenzabar reporting, Moodle reporting, Salesforce reporting, Tableau.
• Create/maintain database tables, views, and stored procedures for back-end report functionality in a Windows/VMWare environment.
• Migrate reports across systems (Sharepoint/SQL Reporting Services to Moodle, Salesforce, Tableau) as needed.
• Help develop/maintain in-house apps (course evaluation, data migration, archival data) and related DB maintenance.
• Perform other duties as assigned by Director and collaborate with LSU Continuing & Distance Education teams.

Skills

SQL

Tableau

Salesforce reporting

Education

Bachelor's degree in related field

Tools

SQL Reporting Services

Sharepoint reporting

Data Warehouses

AWS

Job description

Job Details

Position Type: Professional / Unclassified Department: LSUAM Online - Strategic & Educational Technology (Kappie Mumphrey (00068483) (Inherited)) Work Location: United Plaza XII Pay Grade: Professional

Job Description

Responsible for data consolidation, analysis, and visualization through the generation of reports. Utilizes various technologies and software packages including generic SQL, MSSQL, mySQL, Sharepoint, Salesforce, Tableau to generate reports, visualizations, and metrics. Provides reporting support to marketing, retention, and management teams by collecting and analyzing data and reporting results. Familiar with a variety of the field’s standards, concepts, practices, and procedures. A certain degree of creativity and latitude is expected. Requires a bachelor's degree. Plays an active role in supporting the technical needs of LSU Digital and Continuing Education staff and programs. This position is responsible for managing and supporting the Digital and Continuing Education electronic reporting systems, as well as creation and support of all required reports on those systems. As a member of the Information Technology team, this full-time staff position reports to the IT Director and works closely with the staff within LSU Digital and Continuing Education. Is responsible for maintaining a line of communication with management to ensure reporting needs are satisfied in a timely manner. Works to maintain accurate information regarding available reports and communicates that information in a digital format. Assists all units within the LSU Department of Digital and Continuing Education with reports related to educational, marketing, and business processes. Initiates, implements, and provides reporting support for new projects in consultation with LSU Department of Digital and Continuing Education and other applicable units on campus. Other duties as assigned by Director. Works with other analysts in the LSU Department of Continuing and Distance Education to complete reporting-related projects.

Responsibilities

• Responsible for designing, managing, and implementing electronic reports, including but not limited to financial, enrollment, demographic, marketing, course procedural and student course progress reports. (30%)
• Responsible for maintenance and support of reporting systems, including but not limited to Microsoft Sharepoint, SQL Reporting Services, Jenzabar reporting, Moodle reporting, Salesforce reporting, and Tableau. (30%)
• Responsible for creating and maintaining database tables, views, and stored procedures for back end report functionality. Programs that will be used are Windows 2012 servers in a VMWare virtual environment running Sharepoint, Moodle, MediaSite, Jenzabar, SQL, IIS web services, and AWS.(15%)
• Responsible for migration of reports to other systems as needed, including but not limited to migration of Sharepoint/SQL Reporting Services reports to Moodle, Salesforce, and Tableau in conjunction with departmental initiatives. (15%)
• Assist with development and maintenance of new and existing in-house applications, including but not limited to course evaluation web applications, archived data applications, data migration applications and supplemental database maintenance applications. (5%)
• Other duties as assigned (5%)

Minimum Qualifications

• Bachelor's degree in related field and 2 years of related experience.
• Proficiency in writing and understanding SQL, Tableau, and Salesforce report writing.

Preferred Qualifications

• Bachelor's degree in related field and 3 years of related experience.
• Proficiency in writing and understanding SQL, SQL Reporting Services, Sharepoint report writing, Tableau, Data Warehouses, and AWS.

Special or Physical Qualifications

• Evening and weekend hours are sometimes required. Some travel may be required. Must have a valid driver's license.

Background Check

Background Check - An offer of employment is contingent on a satisfactory pre-employment background check.

Equal Opportunity & Work Authorization

LSU is an Equal Opportunity Employer.

All candidates must have valid U.S. work authorization at the time of hire and maintain that valid work authorization throughout employment. Changes in laws, regulations, or government policies may impact the university’s ability to employ individuals in certain positions.

Benefits

• health, life, dental, and vision insurance
• flexible spending accounts
• retirement options
• various leave options
• paid holidays
• wellness benefits
• tuition exemption for qualified positions
• training and development opportunities
• employee discounts
• and more!

Positions approved to work outside the State of Louisiana shall be employed through Louisiana State University’s partner, nextSource Workforce Solutions, for Employer of Record Services including but not limited to employment, benefits, payroll, and tax compliance. Positions employed through Employer of Record Services will be offered benefits and retirement as applicable through their provider and will not be eligible for State of Louisiana benefits and retirement.

Contact Information

For questions or concerns related to updating your application with attachments (e.g., resumes, RS:17 documents), date of birth, or reactivating applications, please contact the LSU Human Resources Management Office at 225-578-8200 or email [e-mail].

For questions or concerns regarding the status of your application or salary ranges, please contact the department using the information provided in the Special Instructions section of this job posting.

LSU researchers across Louisiana are working on developing a wide-range of innovations to improve quality of life by studying issues such as disease management, advance medical treatments, obesity, coastal protection, hurricane preparedness, energy, natural resource management and agriculture, among others. Louisiana’s Flagship University is a land-, sea- and space-grant institution with academic programs in all areas of science, engineering, humanities, arts and social sciences. The University comprises of nine institutions: Louisiana State University and Agricultural and Mechanical College (“LSU”), the premier flagship university for the state, which include the Paul M. Hebert Law Center and the School of Veterinary Medicine Louisiana State University at Alexandria Louisiana State University at Eunice Louisiana State University at Shreveport LSU Health Sciences Center – New Orleans LSU Health Science Center – Shreveport The Health Care Services Division Louisiana State University Agricultural Center Pennington Biomedical Research Center Any other college, university, school, institution, or program now or hereafter under the supervision and management of the Board of Supervisors of Louisiana State University and Agricultural and Mechanical College In implementing its mission, LSU is committed to: Offering a broad array of undergraduate degree programs and extensive graduate research opportunities designed to attract and educate highly qualified undergraduate and graduate students; Employing faculty who are excellent teacher-scholars, nationally competitive in research and creative activities, and who contribute to a world-class knowledge base that is transferable to educational, professional, cultural, and economic enterprises; and Using its extensive resources to solve economic, environmental, and social challenges.