IT Data Warehouse Developer

Job Posting Closing Times: Job postings are removed from advertising at 12:00 A.M. on the closing date e.g., at midnight on the day before the closing date.

If you are a current Austin Community College employee, please click this link to apply through your Workday account.

Austin Community College 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 appropriate 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's mission to promote equitable access to educational opportunities

• Cares about student success and collaborates on strategies to facilitate success for under-represented populations

• Welcomes difference and models respectful interaction with others

• Engages with the community both within and outside of ACC

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.

ACC is proud to serve a diverse student body as an open-access and low-cost institution. Dedicated faculty members are excellent professors who help students achieve their educational goals and are sensitive to our students' diverse cultures and socio-economic backgrounds. In 2017 our faculty adopted a Statement of ACC Faculty Values. This Statement affirms that ACC's faculty members value collaboration, service, agency, scholarship, inclusion, and teaching, all of which attest to our commitment to equity, diversity, and inclusion at the heart of our mission.

Job Posting Title:

IT Data Warehouse Developer

Job Description Summary:

An IT Data Warehouse Developer is responsible for designing, developing, and maintaining data warehouse and analytics architecture to meet an enterprise’s business analysis and reporting needs.

Our Ideal Candidate:
He/she works with architects and business partners to fashion out the technical vision for applications in Customer Data Warehouses employing SSIS, SSRS, and SQL server. The job description of warehouse developers includes gathering of business requirements and creating architectural designs. It involves designing, developing, and supporting new and current ETL processes employing industry standards and best practices to enhance loading of data from and into different source/ target systems.

The data warehouse developer’s role in an organization also includes providing support to the organization’s business requirements in the application and consumption of information from the Enterprise Data Warehouse (EDW) or from other suitable source systems. He/she will be part of the team to review, analyze, modify, and create ETLs, utilizing SSIS, testing, debugging, integration and implementation processes. His/her tasks will also include documenting technical needs for ETL processes and databases, and ensuring optimal technical infrastructure is utilized.

This position involves the delivering of data integration projects and would therefore require leveraging best practices expertise and experience at implementation; as well as effective technology know-how. The individual holding this position must be able to perform various complex assignments without much supervision; and must be able to carry out training for company and IT staff.

Job Description:

Description of Duties and Tasks

• Consolidate and optimize available data warehouse infrastructure or create a data warehouse infrastructure that is optimized and consolidated
• Conceive analytics and business intelligence platform architecture for clients, including internal and third-party clients
• Design and implement ETL procedures for intake of data from both internal and outside sources; as well as ensure data is verified and quality is checked
• Design and implement ETL processes and data architecture to ensure proper funct