Position Information
Location:
Service Center
Hours:
Typically Monday - Friday 8 am to 5pm
Salary:
Salary Commensurate Upon Experience.
FLSA Status:
Exempt
Reports To:
Manager, Business Intelligence
Criminal Background Check:
Pre-employment criminal background checks are required for all Staff and Faculty positions. Pre-employment urinalyses drug screens are also required for all top candidates considered for positions in ACC's College Police department.
College Profile

Austin Community College (ACC) is a public two-year institution that serves a diverse population of approximately 41,000 credit students each fall and spring semester. We embrace our identity as a community college as reflected in our mission statement. We promote student success and community development by providing affordable access, through traditional and distance learning modes, to higher education and workforce training, including appropriately applied baccalaureate degrees, in our service area.

As a community college committed to our mission, we seek to recruit and retain a workforce that:

• Reflects the diversity of our community.
• Values intellectual curiosity and innovative teaching.
• Is attracted by the college mission to promote equitable access to educational opportunities.
• Cares about student success and collaborates on strategies to facilitate success for underrepresented populations.
• Welcomes difference and models respectful interaction with others.
• Engages with the community both within and outside of ACC.

Our Mission

The Austin Community College District promotes student success and community development by providing affordable access, through traditional and distance learning modes, to higher education and workforce training in its service area.

For more information, see http://www.austincc.edu/about-acc/mission-statement.Commitment to Equity and Inclusion

ACC is committed to the ongoing systemic changes needed to ensure the increased recruitment, inclusion, retention, and completion of historically underserved and underrepresented populations. Through continual strategic community engagement and professional development of administrators, faculty, staff, and students, the college demonstrates its dedication to fostering a culture and climate for equitable outcomes.

As an open-access and low-cost institution, ACC is proud to serve a diverse student body. Dedicated faculty members are excellent professors who help students achieve their educational goals and are sensitive to the diverse cultures and socio-economic backgrounds of our students. The College values and is committed to equity, diversity, and inclusion throughout the College community.General Statement of Job

To support the college's new enterprise information management strategy and have a hand in building a new data integration hub from the ground up to support a robust and meaningful business intelligence platform that serves the whole college.Description of Duties and TasksEssential duties and responsibilities include the following. Other duties may be assigned.

Facilitates the app-to-app transfer of data via a SQL-based data hub, including data element mapping, design, development, testing, and documentation.

Ensures data accuracy and quality from end to end in complex ETL/ELT processes.

Identifies and vets source application data for transfer to the data hub and subsequent warehousing and analysis.

Maintains robust documentation of data mappings and logic between applications and the data hub.

Works closely with other BI and IT teams to maintain an accurate and efficient information ecosystem.

Identifies opportunities for process and quality improvement in the data hub.

KnowledgeMust possess required knowledge and be able to explain and demonstrate, with or without reasonable accommodations, that the essential functions of the job can be performed.

Strong SQL skills and understanding of relational databases. Experience with data management and ETL/ELT processes in a high volume, near-real-time data scenario. Strong knowledge of best practices and principles behind building and maintaining a data integration hub. Understanding of data warehousing principles and best practices.SkillsMust possess required skills and be able to explain and demonstrate, with or without reasonable accommodations, that the essential functions of the job can be performed.

Maintaining an established work schedule. Effectively using interpersonal and communications skills including tact and diplomacy. Effectively using organizational and planning skills with attention to detail and follow-through. Analyzing, reviewing, and writing applications and programs based on customer needs and requirements. Conducting analysis of customer needs and developing solutions to software challenges. Maintaining and modifying existing software applications. Maintaining confidentiality of work-related information and materials. Establishing and maintaining effective working relationships. Outstanding problem-solving skills and attention to detail.Technology Skills

Use a variety of spreadsheet, word processing, database, and presentation software. Use query and control languages, program, deal with network servers, and provide technical support.Required Work Experience

Three years related work experience.

Preferred Work Experience

Three or more years of experience working with enterprise-level data integration, relational databases, data warehousing, data hubs, etc., experience with Informatica or other iPaaS or cloud-based enterprise tools a plus.Required Education

Bachelor's degree.

Special RequirementsLicenses/Certifications; Other

Valid Texas Driver's License and reliable transportation for travel in the Austin area as required.Other Preferred Qualifications

Experience using SAS, JavaScript, SQL, Visual Basic, Excel formulas, or other tools used for reporting.Physical Requirements

Work is performed in a standard office or similar environment. Subject to standing, walking, sitting, bending, reaching, pushing, and pulling. Occasional lifting of objects up to 10 pounds.Safety

Work safely and follow safety rules. Report unsafe working conditions and behavior. Take reasonable and prudent actions to prevent others from engaging in unsafe practices.

Information for This Posting Only

This is a benefit eligible position funded through January 31, 2022 and is subject to renewal. The College is unable to support candidates who require sponsorship to work in the United States.ACC Benefits OverviewFull-time Faculty and Staffing Table employees who work in full-time and/or part-time positions at the College are eligible for ACC medical benefits effective the first of the month after their first 60 days of employment. Benefits include medical, dental, life insurance, short and long term disability, retirement plans and AD&D.

ACC does not participate in Social Security. ACC participates in the Teacher Retirement System of Texas (TRS) and the Optional Retirement Program (ORP-Faculty Only). Part-time and Hourly employees participate in the ACC Money Purchase Plan (ACCMPP) as a retirement program required by Federal law.

DisclaimerThe above description is an overview of the job. It is not intended to be an all-inclusive list of duties and responsibilities of the job, nor is it intended to be an all-inclusive list of the skills and abilities required to do the job. Duties and responsibilities may change with business needs. ACC reserves the right to add, change, amend, or delete portions of this job description at any time, with or without notice. Employees may be required to perform other duties as requested, directed, or assigned. In addition, reasonable accommodations may be made by ACC as its discretion to enable individuals with disabilities to perform the essential functions.

Austin Community College provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics.

As required by the US Department of Education, employees are required to report violations under the Title IX and, under the Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act (Clery Act), select individuals are required to report crimes. If this position is identified as a Campus Security Authority (Clery Act), you will be notified, trained, and provided resources for reporting.