BI Developer and Data Analyst 1, 2 or 3
Louisiana State University Agricultural Center
- Baton Rouge, LA
- Permanent
- Full-time
- 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
- 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.
- 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.
- 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
- Master’s Degree.
- A degree in Business, Mathematics, Statistics, Engineering, Science, Management Information Systems, Computer Science, or related field.
- 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.
- 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.
- 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.
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, 2024Closing 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, 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.Essential Position (Y/N):LSU is an Equal Opportunity Employer and SAME Agency:LSU is designated as a 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 ( ).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 . 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.
Louisiana State University Agricultural Center