Systems Engineer - Enterprise Data Warehouse

Updated: over 1 year ago
Location: Auburn, ALABAMA
Deadline: ;

Position Details
Position Information


Requisition Number S1921P
Home Org Name Office of Information Technology
Division Name Chief InfoOffice and InfoTechnology
Position Title Systems Engineer - Enterprise Data Warehouse
Job Class Code MA14 F
Appointment Status Full-time
Part-time FTE
Limited Term No
Limited Term Length
Job Summary
Systems Engineer – Enterprise Data Warehouse
The Office of Information Technology at Auburn University is seeking applicants for the Enterprise Data Warehouse Systems Engineer position. This position performs work associated with analysis, design, implementation, operation, deployment, and support of the organization’s information technology Enterprise Data Warehouse (including operating systems, software applications, data processing and security), and software/database products by internal staff, outsourcing staff, or consultants. The position works with DBAs, Developers, Architects, Data Modelers, Business Analysts and Functional Users to design data solutions that meet the organizational needs. These solutions are designed to improve efficiency and outputs and may focus on issues such as reducing data redundancies or improving data integration, across systems. This role plays a key part in defining and implementing Data governance and standards within the University for Data warehousing and reporting purposes.
About Auburn: At Auburn, our work changes lives. Ranked by U.S. News and World Report as a premier public institution, Auburn University is dedicated to shaping the future of the people of Alabama, the nation, and the world through forward-thinking education, life-enhancing research, scholarship and selfless service. Auburn is nationally recognized for its commitment to academic excellence, community outreach, positive work environment, student engagement, and thriving community.
Why employees choose Auburn: Auburn University was named by Forbes Magazine as one of the state of Alabama’s best employers, with employees staying an average of ten years. Employees enjoy competitive benefits that include top-notch health insurance, generous retirement plans, tuition assistance for employees and dependents, flexible spending accounts and more!
Learn more about Auburn’s impact, generous employee benefits, and thriving community by visiting aub.ie/working-at-auburn.
Our Commitment: Auburn University is committed to a diverse and inclusive campus environment. Visit www.auburn.edu/inclusion to learn more about our commitment to expanding equity and inclusion for all.
Formal AU Title: Specialist, Information Technology (VI)
Essential Functions
  • Works with functional counterparts to design and develop University procedures, configurations, complex workflows, and system integration procedures for our Enterprise Data Warehouse. Documents deployed systems and their integration points. Creates and coordinates routine audits and testing.

  • Establishes and coordinates the administration and maintenance and testing of university systems according to university and industry standards. Establishes and coordinates enterprise-level configuration changes to systems and applications to identify, correct, and prevent operational and architectural problems. Develops recommendations for the monitoring of university systems to ensure compliance with departmental and University standards.

  • Designs and approves technical solutions to automate, monitor, test, and deploy applications, Extract/Transform/Load (ETL) process and API integrations. Establishes the methods and procedures for collecting, organizing, interpreting, and classifying system and log data for security, performance, and capacity planning needs.

  • Provides oversight and recommendations of backup/recovery plans and procedures for compliance with enterprise guidelines. Defines and oversees backup and disaster recovery processes and procedures. Coordinates testing of high availability, backup, and disaster recovery processes in accordance with departmental standards.

  • Collaborates with project leaders and management to identify technology gaps and recommend changes and improvements. Coordinates and provides ongoing technical assistance to customers regarding systems and applications. Makes recommendations to stakeholders to increase efficiencies in systems and serves as a subject matter expert and consultant to university departments.

  • Develops processes for data visualization using Qlik based on the needs of our constituents. Provides hands on training when necessary. Collaborates with Business Analysts to understand the needs and fulfill the data reporting and visualization needs of customers including converting existing reports to visualizations.

  • May provide on-call support for designated systems and services.

  • Performs other related duties as assigned by the supervisor.

Minimum Education and Experience


Education Level Bachelor's degree from an accredited institution
Field of Study
Years of Experience 7
Area of Experience
Experience in IT analysis, design, implementation, operation, deployment, and support of an organization’s Enterprise Data Warehouse (including operating systems, software applications, data processing and security), and software/database products
Requirements for Additional Job Levels

Alternate Minimum Education and Experience (If available)


Education Level
Field of Study
Years of Experience
Area of Experience
Requirements for Additional Job Levels

Minimum Skills, License, and Certifications


Minimum Skills and Abilities
  • Analytical and troubleshooting skills with complex technical subjects and tasks
  • Ability to present and explain complex technical topics, problems, alternative solutions to others
  • Advanced knowledge and experience in relational databases
  • Experience working with data, data quality, and movement of data between systems
  • History of handling moderately complex projects through to completion
  • Strong technical/process documentation skills
  • Strong teamwork and communication skills
  • Ability and willingness to quickly learn and use new applications and computer languages
  • Ability to identify and implement efficiencies and automate processes and procedures
  • Collaborate, coordinate and communicate with other teams
  • Professional verbal and written communication skills
  • Follow Enterprise IT Security best practices – have a clear understanding of security concepts and best practices and the implementation within the Middleware environments
  • Candidate must be able to work quickly and accurately with minimal supervision
Minimum Technology Skills
Minimum License and Certifications

Desired Qualifications


Desired Qualifications
A Bachelor’s degree from an accredited institution in Computer Science or related field, experience working as a data analyst with functional business units, extensive experience with data visualization, and a deep understanding of data governance. Experience with any of the following: Snowflake or similar data warehouse solutions, GitHub or other code repository, SQL, JSON, IDE software, cloud infrastructures, ETL tools, API connectivity and development, Azure, Logic Apps, Swagger, DataFactory, or Salesforce

Posting Detail Information


Salary Range $59,700 - $99,600
Job Category Information Systems/Technology
Working Hours if Non-Traditional
City position is located in: Auburn
State position is located: Alabama
List any hazardous conditions or physical demands required by this position
Posting Date 08/12/2022
Closing Date
EEO Statement
Auburn University is committed to an inclusive and diverse campus environment. Women, underrepresented groups, individuals with disabilities and veterans are encouraged to apply.
AUBURN UNIVERSITY IS AN AFFIRMATIVE ACTION/EQUAL OPPORTUNITY EMPLOYER. It is our policy to provide equal employment opportunities for all individuals without regard to race, sex, religion, color, national origin, age, disability, protected veteran status, genetic information, sexual orientation, gender identity, or any other classification protected by applicable law.
Special Instructions to Applicants
Quick Link for Internal Postings https://www.auemployment.com/postings/31594


Similar Positions