BI Developer And Data Analyst 1, 2 Or 3

All Job Postings will close at 12:01a.m. CST (1:01a.m. EST) on the specified Closing Date (if designated).

If you close the browser or exit your application prior to submitting, the application progress will be saved as a draft. You will be able to access and complete the application through "My Draft Applications" located on your Candidate Home page.

Job Posting Title:

BI Developer and Data Analyst 1, 2 or 3

Position Type:

Professional / Unclassified

Department:

LSUAM FA - ITS - DA - PS - Business Intelligence (Anthony Joseph Alfonso (00012319))

Work Location:

0202 Fred C. Frey Computing Services Building

Pay Grade:

Professional

Job Description:

Data warehouse design and configuration for mission-critical enterprise data warehouse and reporting needs. Provides support for data warehouses. Responsible for coding and documenting procedures and for programming, testing, and debugging data warehouses. Familiar with concepts, practices, and procedures. Relies on experience and judgement to plan and accomplish goals. Performs a variety of tasks. A certain degree of creativity and latitude is expected. All Information Technology Services employees are expected to demonstrate a commitment to exemplary customer service in all facets of their work.

Job Responsibilities:

Data Analysis, Query, Report Writing: Work with IT personnel, central administrative staff, and end users to conduct data analysis and validation, perform ad-hoc queries, and to design, develop, and maintain reports and related reporting programming artifacts. Follow programming design principles and best practices. Comply with software quality assurance standards, business goals, and project timelines in an agile delivery environment. Through release/upgrade notifications validate report functionality and edit reports as needed. (60%)

Data Design: Work with IT data modelers, central administrative staff, and end users to design data models, data sets, and data definitions for enterprise business intelligence (EBI) reporting and for use with data visualization technology solutions.

Test report and validate that it meets clients requirements. Prepare reports for deployment to multiple environments using established control protocols. Document and share technical and functional changes with colleagues. Coordinate and communicate system-related events with ITS support and communications personnel with a goal of providing excellent customer service. (20%)

Reporting Platform Administration / System Technical Support: Manage daily tickets and cyclical (release/upgrades) administration of reporting and analytics solutions in collaboration with other IT personnel, campus partners, and the campus community at large. Ensure the overall health of the technology platform. Apply software maintenance. Reduce operational complexity. Deign and implement system security. Perform capacity planning and management. Serve as escalation point for production and/or platform issues. (10%)

Other duties as assigned. (10%)

Analyst 1:

Minimum Qualifications:

• Bachelor's degree.
• 1 year of professional work experience.

Preferred Qualifications:

• Master's degree.

• A degree in Business, Mathematics, Statistics, Engineering, Science, Management Information Systems, Computer Science, or related field.

• Programming for various data driven tasks like analysis, extraction, cleaning, validation, summarization, manipulating, creating datasets and generating reports

• Awareness of dimensional modelling, Star Schemas, Data Marts.

• Proficient with Microsoft Office products

Analyst 2:

Minimum Qualifications:

• Bachelor's degree.

• 2 - 4 years of experience in a data warehouse developer position.

• Experience programming for various data driven tasks like analysis, extraction, cleaning, validation, summarization, manipulating, creating datasets and generating reports.

• Experience dimensional modelling, Star Schemas, Data Marts..

• Experience with Relational databases concepts and SQL.

Preferred Qualifications:

• Master's degree.

• A degree in Business, Mathematics, Statistics, Engineering, Science, Management Information Systems, Computer Science, or related field.

• Visual analytics programming.

• Experience in SAS EBI Platform Server, including SAS Management Console, SAS Data Integration Studio, Enterprise Guide, SAS Add-in for MS Office, etc.

• Experience with SAS report generating procedures, functions, user defined formats, Proc SQL, SAS/Macros to produce summary datasets and reports.

• Experience with exporting SAS Results to different formats such as HTML, PDF, CSV, Excel using SAS/ODS & Proc Export for reporting and presentation.

Analyst 3:

Minimum Qualifications:

• Bachelor's degree.

• 5+ years of experience in a data warehouse developer position.

• Experience in SAS EBI Platform Server, including SAS Management Console, SAS Data Integration Studio, Enterprise Guide, SAS Add-in for MS Office, etc.

• Experience with SAS report generating procedures, functions, user defined formats, Proc SQL, SAS/Macros to produce summary datasets and reports.

• Experience with exporting SAS Results to different formats such as HTML, PDF, CSV, Excel using SAS/ODS & Proc Export for reporting and presentation.

• Experience with visual analytics software

• Tableau, Power BI, SAS VA

Preferred Qualifications:

• Master's Degree.
• A degree in Business, Mathematics, Statistics, Engineering, Science, Management Information Systems, Computer Science, or related field.

LSU is committed to creating an inclusive space where our employees feel valued for their skills and uniqueness. If you do not meet the minimum qualifications as listed, but have significant experience within the major job responsibilities, we welcome your application.

Examples of Work:

Analyst 1:

• Translates business questions and requirements into reports, views, and BI query objects.

• Researches and understands business data model.

• Researches and understands SQL and relational and multidimensional designs.

• Develops reports, views, and BI query objects using organizational BI tools.

• Complies with BI standard operating procedures and institutional data management policies.

• Demonstrates effective knowledge of BI tool architectures, functions, and features.

• Provides data and analytics output that satisfy functional requirements and provides accurate results.

• Adheres to organization's design policies including maintaining current documentation.

• Provides troubleshooting for reports, views, and BI query objects.

• Collaborates with subject matter experts (SMEs), functional owners, and other ITS staff.

Analyst 2:

• Performs complex analysis of functional use cases to ensure BI solutions meet client needs.

• Provides expertise with respect to data sources ensuring BI artifacts demonstrate data quality and accuracy.

• Uses BI solutions in a manner that demonstrates advanced competency with tools and produces BI artifacts that perform efficiently.

• Solves complex problems, assimilating information rapidly, and working under strict timelines.

• Participates in all phases of BI tool and application implementation.

• Demonstrates strong problem-solving skills in ensuring BI artifacts meet functional requirements.

• Provides advanced troubleshooting for complex BI artifacts.

• Identifies and communicate issues and risks in a timely manner.

• Provides advanced BI training, documentation, and second-tier support.

Analyst 3:

• Provides expert consultation and comprehensive recommendations by anticipating needs with respect to requirement analysis, level of effort estimation, and project planning.

• Considers broad scope across functional areas when translating functional needs into BI artifact designs.

• Leads BI tool and application implementation.

• Produces high quality BI artifacts, including technical requirements, test documentation, system/operations guides, issues/enhancement request documentation.

• Develops guidelines and policies for BI development activities.

• Develops guidelines and policies for BI solution testing.

• Develops enterprise standards for use of BI tools and semantic layers throughout the organization.

• Evaluates new and existing BI products.

• Mentors junior staff.

Additional information:

Please note that this position requires in-office work on our Baton Rouge Campus.

Additional Job Description:

Special Instructions:

A copy of your transcript(s) may be attached to your application (if available). However, original transcripts are required prior to hire.

Please provide three professional references including name, title, phone number and e-mail address.

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

For questions or concerns regarding the status of your application or salary ranges, please contact Mary Bordelon at mbordelon@lsu.edu.

Posting Date:

April 4, 2024

Closing Date (Open Until Filled if No Date Specified):

Additional Position Information:

Background Check

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

Benefits

• LSU offers outstanding benefits to eligible employees and their dependents including 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, next

Source 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.

Essential Position (Y/N):

LSU is an Equal Opportunity Employer and SAME Agency:

LSU is designated as a State As a Model Employer (SAME) agency and provides assistance to persons needing accommodations or with the accessibility of materials. For those seeking such accommodations or assistance related to this search, we encourage you to contact the Office of Human Resource Management (hr@lsu.edu).

HCM 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 HR@lsu.edu. 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.