Data Warehouse Developer 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:

Data Warehouse Developer 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, configuration, and support for mission-critical enterprise data warehouse and reporting. Familiar with and responsible for documenting concepts, practices, and procedures. Design, implement, test, and debug complex queries to extract, calculate, transform, and load data. Design, implement, and test data schemas. Relies on experience and judgment 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 WAREHOUSE DEVELOPMENT: Work with IT personnel, central administrative staff, and end users to conduct data analysis and validation. Design, implement, test, debug complex queries to extract, calculate, transform, and load data to data warehouse. Follow programming design principles and best practices. Comply with software quality assurance standards, business goals, and project timelines in an agile delivery environment. Monitor release/upgrade notifications and validate related warehouse functionality. Document and share changes with colleagues. (40%)

DATA AND PROCESS DESIGN: Work with IT data modelers, central administrative staff, and end users to design data warehouse data models, data sets, and data definitions for enterprise business intelligence (EBI) reporting and for use with data visualization technology solutions. (30%)

DATA WAREHOUSE ADMINISTRATION / SYSTEM TECHNICAL SUPPORT: Manage daily tickets and cyclical (release/upgrades) administration of data warehouse solutions in collaboration with other IT personnel, campus partners, and the campus community at large. Ensure the overall health of the technology platform. Reduce operational complexity. Design and implement system security. Perform capacity planning and management. Serve as escalation point for production and/or platform issues. Coordinate and communicate system-related events. (20%)

Other duties as assigned. (10%)

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

• Data warehouse administration.

• ETL for business reporting needs.

• Data warehouse design, configuration, and support.

• Understanding of Relational databases.

• Understanding of SQL language.

Developer 2:

Minimum Qualifications-

• Bachelor's degree.

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

• Experience in data warehouse administration.

• Experience in data warehouse ETL and enterprise business intelligence reporting.

• Experience with Relational databases concepts.

• Experience with SQLs.

Preferred Qualifications-

• Master's degree.

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

• Data warehouse design, configuration, and support.

• Visual analytics programming.

• Cloud services.

Developer 3:

Minimum Qualifications-

• Bachelor's degree.

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

• Experience in data warehouse administration.

• Experience in data warehouse ETL and enterprise business intelligence reporting.

• Experience in data warehouse design, configuration, and support.

• Visual analytics programming.

• Experience with Relational databases concepts.

• Experience with SQL.

Preferred Qualifications-

• Master's Degree.

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

• Cloud services.

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:

Developer 1:

• Assist with data warehouse administration tasks.

• Translates business questions and requirements into ETL (extraction, transformation, and load) and/or data warehouse processes, defining and capturing metadata and rules associated with ETL and/or data warehouse processes.

• Researches and understands source and target data structures, ETL and/or data warehouse processes, and products.

• Maps source system data to target system data model.

• Develops ETL and/or data warehouse processes using organizational ETL and/or data warehouse tools.

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

• Demonstrates effective knowledge of ETL and/or data warehouse tool architectures, functions, features, and programming languages.

• Provides accurate results that satisfy functional requirements.

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

• Provides troubleshooting for ETL and/or data warehouse artifacts.

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

Developer 2:

• Participates in all phases of ETL tool and/or data warehouse implementation.

• Demonstrates strong problem-solving skills in ensuring ETL and/or data warehouse processes meet functional requirements.

• Performs complex analysis of functional use cases to ensure ETL and/or data warehouse processes meet client needs.

• Provides expertise with respect to source and target data structures ensuring ETL and/or data warehouse processes demonstrate data quality and accuracy.

• Uses ETL and/or data warehouse solutions in a manner that demonstrates advanced competency with tools and procedures and produces ETL and/or data warehouse processes that perform efficiently.

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

• Provides advanced troubleshooting for complex ETL and/or data warehouse processes.

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

• Provides advanced ETL and/or data warehouse training, documentation, and second-tier support.

Developer 3:

• Lead ETL tool and/or data warehouse implementations.

• 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 ETL and/or data warehouse processes.

• Produces high quality ETL and data warehouse processes, including technical requirements, test documentation, system/operations guides, issue/enhancement request documentation.

• Develops guidelines and policies for ETL and/or data warehouse activities.

• Develops guidelines and policies for ETL and/or data warehouse testing.

• Develops enterprise standards for use of ETL tools and metadata throughout the organization.

• Evaluates new and existing ETL and/or data warehouse products and methods.

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