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.
.

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 functioning of analytics lad, as well as client’s or third-party’s reporting environments and dashboard
• Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization
• Carry out monitoring, tuning, and database performance analysis
• Perform the design and extension of data marts, meta data, and data models
• Ensure all data warehouse architecture codes are maintained in a version control system.

Knowledge

• Data warehouse systems and development theories, including ETL processes.
• Local area networks and personal computing environments.
• Client-server technology.
• Database integrity and security standards, and data encryption methodologies.

Skills

• Possessing a customer-oriented and solutions-focused mindset.
• Maintaining an established work schedule and providing assistance outside of usual work hours, including nights, weekends, holidays, and winter and spring breaks as required.
• Effectively using interpersonal and communications skills including tact and diplomacy.
• Effectively using organizational and planning skills with attention to detail and follow-through.
• Performing data warehouse maintenance activities such as data warehouse backups, creating accounts, and enforcing data warehouse security.
• Ability to to adopt and implement new software languages or tools according to the departmental needs.
• Maintaining confidentiality of work-related information and materials.
• Establishing and maintaining effective work relationships.
• Effectively use work management and productivity tools for project management.

Technology Skills

• Use a variety of spreadsheet, word processing, database, and presentation software.

Required Work Experience

• Two years related work experience.

Required Education

• Bachelor's degree.

Special Requirements

Licenses/Certifications; Other

• Valid Texas Driver's License and reliable transportation needed for local Austin area travel.

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.

Salary Range $70,645 - $100,922

Reports to the Director of Business Intelligence

Number of Openings:

1

Job Posting Close Date:

March 18, 2024 Clery Act

As required by the US Department of Education, employees are required to report violations under 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.

Disclaimer

The 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 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 at its discretion to enable individuals with disabilities to perform essential functions of the job.

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