BI Developer and Data Analyst 1

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., 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%), * 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., 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.

• Bachelor’s degree.
• 1 year of professional work experience., * 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

LSU values skills, experience, and expertise. Candidates who have relevant experience in key job responsibilities are encouraged to apply- a degree is not required as long as the candidate meets the required years of experience specified in the job description.

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