BI Developer and Data Analyst 1

Louisiana State University

5d•Onsite

About The Position

This position involves data warehouse design and configuration for mission-critical enterprise data warehouse and reporting needs. The role provides support for data warehouses, is responsible for coding and documenting procedures, and for programming, testing, and debugging data warehouses. The individual will be familiar with concepts, practices, and procedures, relying on experience and judgment to plan and accomplish goals. This is a varied role where 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.

Requirements

Bachelor’s degree.
1 year of professional work experience.
Programming for various data driven tasks like analysis, extraction, cleaning, validation, summarization, manipulating, creating datasets and generating reports
Proficient with Microsoft Office products
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.
Valid U.S. work authorization at the time of hire and maintain that valid work authorization throughout employment.

Nice To Haves

Master’s degree.
A degree in Business, Mathematics, Statistics, Engineering, Science, Management Information Systems, Computer Science, or related field.
Awareness of dimensional modelling, Star Schemas, Data Marts.

Responsibilities

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.
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 reports and validate that they meet 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.
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.
Design and implement system security.
Perform capacity planning and management.
Serve as escalation point for production and/or platform issues.
Other duties as assigned.