IT Data Warehouse Developer

Austin, TX, United States

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 multicultural 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:

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 populations including; first generation college students, low-income students, and students from underserved communities.

Focused on student academic achievement and postgraduate outcomes

Welcomes difference and models respectful interaction with others

Engages with the community both within and outside of ACC

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

$85,239 - $106,548

Reports to the Director of Business Intelligence

Number of Openings:

1

Job Posting Close Date:

July 17, 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.