Data Warehouse Developer 1
About The Position
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.
Requirements
- Bachelor's degree with 1 year of professional work experience.
- 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.
Nice To Haves
- Master's degree in Business, Mathematics, Statistics, Engineering, Science, Management Information Systems, Computer Science, or related field.
- Experience in the following:
- Data warehouse administration.
- ETL for business reporting needs.
- Data warehouse design, configuration, and support.
- Understanding of Relational databases.
- Understanding of SQL language.
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. (35%)
- 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. . (25%)
- Other duties as assigned. (10%)
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!
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Entry Level
Industry
Educational Services
Number of Employees
1,001-5,000 employees
