IT Business Analyst - Data Warehouse Modeler
- Employer
- Auburn University
- Location
- Alabama, United States
- Salary
- Salary Not Specified
- Date posted
- Jul 1, 2022
View more
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
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 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
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
- Resume
- Cover Letter
Required fields are indicated with an asterisk (*).
- * Please select how you first became aware of this opportunity.
Your response helps us determine how we can more effectively reach
our candidates.
- 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
- * 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