Job description

Function: Information Technology Family: IT Applications Reports to: Director, Enterprise, Applications, and Data Warehouse Terms of Employment: Pay Grade: E19 Minimum Salary: * $79,350 Mid-Point Salary: $98,435 • Salary is determined on directly related experience supported by a service record or experience affidavit. For more information on our pay policy, please refer to the Compensation Resource Manual. Annualized pay may be pro-rated based on actual start date. Minimum Work Days: 230 Type of Assignment: Full-Time; Exempt Contract Type: Non-Chapter 21 Funding Source: This position is locally funded. Job Scope Use significant independent judgment and familiarity of the field to perform work. May be responsible for administration of various moderate and high complexity departmental programs and may be the lead a group of employees. May develop policies and procedures and oversee the implementation and execution of them. Position Summary The position will be responsible for maintaining the District’s data warehouse system to ensure efficient, effective, and secure data retrieval, aggregation, and access of all District electronic information. Other responsibilities include analyzing the district’s data management, inputs, security needs, and help develop tools that support data access and information security. In addition, this role will be involved in operational improvement projects and development/enhancement of database and business intelligence solutions. Ensure compliance with local, state and federal policies and procedures regarding data access, storage, integrity and security. Comply with the Texas Educator’s Code of Ethics. Essential Functions / Key Responsibilities 1. Design, develop, and execute Extract, Transform, and Load (ETL) packages to process data from heterogenous data sources and formats using stored procedures, functions, and SQL scripts in a Microsoft SQL Server environment. 2. Develop, modify, and optimize stored procedures and T-SQL scripts in response to the needs of the District. 3. Design, implement, maintain and document new and existing database objects including tables, indexes, constraints, stored procedures, and user-defined functions in support of data projects. 4. Manage all database designs by performing moderately complex coding, implementation, maintenance and documentation of custom databases and other applicable data tools. 5. Review and manage software evaluation, hardware suitability, and applicability within the District’s data repositories. 6. Perform SQL Server administration activities (backup, restore, DBCC commands, indexing) 7. Collect, organize, and analyze information related to the development of database applications for specific user needs. 8. Evaluate software and hardware suitability and applicability within District’s data repositories. 9. Provide technical assistance for applications and database software and hardware. Oversees moderately complex data downloads from source systems and other external sources to the data warehouse. Performs scheduled server maintenance as needed. 10. Research, recommend and implement new innovative database technologies. programs. 11. Compile and retain all physical and computerized reports, records, and other required documents. 12. Performs other related duties as assigned within the appropriate skill and experience capabilities expected for this position. Minimum Requirements • Bachelor's Degree from an accredited college or university in Computer Science, Management Information Systems or Mathematics, or 4 years equivalent experience. • 3+ years of progressive experience in database administration, database management, database design, ETL design, or data analysis. • Candidate must have satisfactory outcome of fingerprinting background check. Non-refundable fee (approximately $50.00) paid by the employee. Preferred Qualifications • Master's Degree from an accredited university. • 5+ years of progressive experience in database administration, database management, database design, ETL design, or data analysis. Knowledge, Skills & Abilities • Strong knowledge of various operating systems and productivity tools • Knowledge of business and/or student type application programming and databases • Knowledge of computer hardware and peripheral devices • Knowledge of database design • Ability to normalize, de-normalize, extract and aggregate data • Ability to problem solve, think critically, and manage conflicts • Strong communication, public relations, and interpersonal skills • Knowledge of data warehousing / business intelligence best practices • Proficiently use Microsoft SQL Server Management Studio (SSMS) and/or SQL Server Data Tools (SSDT) for Visual Studio (VS) • Develop, maintain, and troubleshoot SSIS packages, stored procedures and functions using T-SQL and SSMS and/or SSDT for VS • Use aggregate functions in Microsoft SQL Server • Create and maintain complex queries in Microsoft SQL Server using T-SQL • Understand and use database schemas, tables, relationships, and constraints • Development experience using C# or PowerShell is a plus Working Conditions Work Environment: • Computer, computer software programs and peripherals, resource materials and equipment, copier, fax, and other equipment applicable to position. • Frequent exposure to temperature extremes (hot and cold), humidity extremes, noise. Occasional exposure to biological hazards (communicable diseases, bacteria, insects, mold, fungi, etc. Physical Demands/Requirements: • Maintain emotional control under stress; work with frequent interruptions/deadlines and prolonged or irregular hours; Frequent walking, standing, stooping, bending, pulling and pushing; Occasional: Lifting and carrying 10-25 pounds frequently, 25-40 pounds occasionally, more than 45 pounds infrequently with assistance; Pushing/pulling 10-35 pounds sporadically; May be required under specific circumstances to provide physical restraint of students in danger of causing harm to themselves or others; Frequent districtwide and occasional statewide travel. Supervisory Responsibilities / Direct Reports • None San Antonio ISD is committed to non-discrimination on the basis of race, color, ethnicity, culture, religion, national origin, age, sex, gender identity, gender expression, sexual orientation, appearance, immigration/citizenship status, home language, socioeconomic status, or disability in its educational programs, services, and District business functions.

Requirements