This job has expired

IT Business Analyst - Data Warehouse Modeler

Employer
Auburn University
Location
Alabama, United States
Salary
Salary Not Specified
Posted Date
Jul 1, 2022

View more

Position Type
Administrative, Business & Administrative Affairs, Business & Administrative Support, Computer Services & Information Technology, Technology Administration/Other, Chief Technology & Information Officers
Employment Type
Full Time
You need to sign in or create an account to save a job.


Position Details

Position Information

Requisition Number

S1794P

Home Org Name

Office of Information Technology

Division Name

Chief InfoOffice and InfoTechnology

Position Title

IT Business Analyst - Data Warehouse Modeler

Job Class Code

MA14 C/D/E

Appointment Status

Full-time

Part-time FTE

Limited Term

No

Limited Term Length

Job Summary

The Office of Information Technology is seeking applicants for an enterprise Data Warehouse Data Modeler (IT Business Analyst) position. This position analyzes business data processes and definitions and designs data models and structures that translate these complex business data definitions into efficient, compact models. Data Modelers work with DBAs, Business Analysts, Developers, and Functional Users to design data models that meet the organizational needs using conceptual, logical, and physical data models. Their models 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.

Formal AU Title: Specialist, Information Technology ( III /IV/V)


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.

Essential Functions
  • Performs configuration, support, and monitoring activities for third party applications
  • Recommends and performs tuning and optimization for performance of various applications that require integration to core system infrastructure
  • Installs vendor provided fixes for defects, performance enhancements or security related issues.
  • Identifies bugs and defects and communicates with vendor to apply fixes in a timely manner.
  • Follows proper Change controls for testing, implementation and validation for all Middleware product changes/modifications and completes work related to Known Errors, Problem tickets, Problem tasks, Root Cause Analysis research and resolution.
  • Maintains up-to-date knowledge of current and emerging technologies and technical strategy, and advises the leadership where improvements are deemed necessary.
  • Serves as first responder to all incidents and provides root cause analysis involving supported applications.
  • Performs technical Proof of Concepts (POCs) for new tools and services.
  • Conducts training sessions on technical matters and new technology trends for internal audiences.
  • Participates in department projects and serves as consultant for integrating supporting applications
  • Collaborates and completes assigned tasks as part of various projects, initiatives, and/or other work efforts
  • Researches technical issues and provides recommendations for resolution and process improvements.
  • Creates, updates, and maintains department work instructions.
  • Documents and communicates daily tasks to team members and stakeholders
  • Researches tools and makes recommendations to improve reliability, security, efficiency, and cost
  • Works with Banner subject matter experts and DBAs to establish the process and schedule for ETL functions within Oracle and exports to Qlik.
  • Collaborates with Business Analysts to understand the needs and fulfill the data reporting and visualization needs of customers including converting existing reports to visualizations.
  • Enforces data governance policy across Banner and all third party systems which share data with Banner by collaborating with the data owners across campus.
  • Performs other duties as assigned
Minimum Education and Experience

Education Level

High school diploma or equivalent for entry level

Field of Study

Years of Experience

4

Area of Experience

Developing and documenting business requirements, design specifications, use cases, and test cases.

Requirements for Additional Job Levels

The Business Analyst position is posted at three levels – III, IV, and V.

Typical salaries for the Business Analyst, Specialist III level are between $43,000 and $54,000.

The Specialist IV position requires a High School diploma and 5 years or more years of relevant experience. Typical salaries are between $55,000 and $67,000.

The Specialist V position requires a Bachelor’s degree and 4 or more years of applicable experience as indicated. The starting salaries for this level are between $64,000 and $76,000.

Levels III and IV: When a candidate has the required education, but lacks the required experience, they may normally apply additional appropriate education toward the experience requirement, at a rate of one (1) year relevant education per year of required experience

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
  • Strong troubleshooting skills
  • Ability to think logically
  • Ability to work with minimal supervision
  • History of handling moderately complex projects through to completion
  • Strong technical/process documentation skills
  • Strong team and communication skills.
  • Ability to learn and use new applications and computer languages
  • Ability to identify and implement efficiencies and automate processes and procedures
  • Able to coordinate and communicate with other teams for example; application support/development, infrastructure teams, project managers, and support teams to resolve incidents or to complete work requests.
  • 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
  • Understanding of database structures
  • Hands-on experience with application implementation process to include base OS functionality, OS build, web hosting services, and application performance understanding
  • Experience with scripting/programming in language
  • Experience in implementing security, compliance and auditing of Middleware applications
  • Strong customer facing skills and ability to support and drive troubleshooting with multiple vendors and internal teams.
  • Experience creating technical and process documentation.
  • Familiarity with Datacenter operations and complex infrastructure designs
  • Experience with Internal Audit controls and Vulnerability ( CVE ) assessment and remediation
  • Experience with both Linux/ UNIX Systems and Windows Systems environments
  • Experience administering installed Middleware products regardless of platform.
  • Experience supporting the following applications: Qlik and Informatica
  • Experience supporting applications hosted in Cloud environments preference within Azure technologies
Posting Detail Information

Salary Grade

32

Salary Range

$35,000 - $86,400

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

07/01/2022

Closing Date

08/19/2022

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/30436
Documents Needed to Apply
Required Documents
  1. Resume
  2. Cover Letter
Optional DocumentsSupplemental Questions

Required fields are indicated with an asterisk (*).

  1. * Please select how you first became aware of this opportunity. Your response helps us determine how we can more effectively reach our candidates.
    • LinkedIn
    • AcademicKeys
    • The Chronicle of Higher Education
    • DiversityJobs
    • HigherEdJobs
    • HERC (Higher Education Recruitment Consortium)
    • Indeed
    • RecruitMilitary
    • The Tuskegee News
    • Professional organization or journal
    • Veterans Assistance Services
    • Disability Assistance Services
    • State Employment Service
    • Social Media
    • AU Job Bulletin
    • Notified by an Auburn employee
    • College or university Career Services
    • I went to the AU Employment Website directly (www.auemployment.com)
    • Other
  2. * Do you have a high school diploma or equivalent?
    • Yes
    • No


You need to sign in or create an account to save a job.

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert