Skip to main content

This job has expired

Data Analyst

Employer
Foothill-De Anza Community College District
Location
California, United States
Salary
Salary Not specified
Date posted
Aug 30, 2022


Data Analyst

HR EMPLOYMENT/CAREERS
Initial Review Date: 04/12/22*
*Any complete applications received after the review date will only be forwarded to the hiring committee at their request.

Starting Salary: $8,432.17 (per month); Salary Grade: C1-70

Full Salary Range: $8,432.17 - $11,305.12 (per month)

The Foothill-De Anza Community College District is currently accepting applications for the classified position above.

Foothill - De Anza Community College District Mission Statement:

The mission of the Foothill-De Anza Community College District is student success. We are driven by an equity agenda and guided by core values of excellence, inclusion, and sustainability. Every member of our district contributes to a dynamic learning environment that fosters student engagement, equal opportunity, and innovation in meeting the various educational and career goals of our diverse students. We are committed to providing an accessible, quality undergraduate education dedicated to developing a broadly educated and socially responsible community that supports an equitable and just future for California.

JOB SUMMARY:

Under the direct supervision of the Executive Director of Institutional Research and Planning (IRP) for the Foothill - De Anza Community College District, the position will work collaboratively with IRP offices in Central Services and the two colleges to plan, prioritize, and complete projects. Projects will entail the creation and maintenance of database objects as well as supporting data reporting needs.

Database work will involve building and maintaining views, materialized views, tables, functions, and other database objects. Awareness of database architecture and maintenance is welcomed as this insight will facilitate collaboration with database administrator(s). Our ERP system is Banner and database work will be done in consultation with appropriate Educational Technology Services (ETS) personnel as needed.

Data reporting needs will focus on a range of topics related to (student) equity and will involve creating reports and data visualizations to support internal and external reporting requirements. Familiarity with tools such as Argos, Tableau, or PowerBI is preferred, and work completed should align with and enhance the current Foothill - De Anza data reporting infrastructure.

DEFINITION:

Under general supervision, performs technical tasks related to the configuration, troubleshooting, maintenance, and monitoring of the District's databases, data models, and data platforms; performs database performance analysis and assists in building interfaces between enterprise databases and end-user query tools; performs analysis, troubleshoots database problems, and ensures data integrity; creates reports; provides recommendations, support, and training to other information services support staff and District users in areas of responsibility; and performs related work as required.

SUPERVISION RECEIVED AND EXERCISED

Receives general supervision from assigned ETS supervisor. Exercises no supervision of staff.

CLASS CHARACTERISTICS

This class is responsible for performing complex technical assignments, projects, and analyses in support of District databases, creating data models, or managing complex data classification structures and/or manipulating data layers and data sets for District-wide systems. Responsibilities require the use of tact, discretion, and independent judgment and to have full and thorough knowledge of the concepts, practices, procedures, and policies of assigned function. This classification is distinguished from the Senior Database Administrator by the complexity and the amount of discretion exercised over problems and resolutions, as well as the latter serves as a technical leader and subject matter expert in specific area(s).

EXAMPLES OF TYPICAL JOB FUNCTIONS (Illustrative Only)
  • Plans, coordinates, installs, implements, tests, and maintains databases and applications; designs and maintains database infrastructure; creates and manipulates spatial data tables and layers; integrates data and functionality with other specialized applications.
  • Designs application processes and work flow strategies for the management, access, and retrieval of data, defines data rules and relationships, and develops methods for quality control of databases.
  • Designs, builds, and maintains the District's databases, websites, and web-based and mobile applications.
  • Recommends and implements strategies and procedures for integrating data standards, use, and methods of analyses to support District projects, programs and services.
  • Individually or as a team member, works on and is responsible for applications research, development, conversion, installation, and maintenance projects, including conception and initiation, definition and planning, launch and execution, monitoring and controlling, and close-out; defines project requirements, methods, and end objectives in consultation with end users; estimates and tracks project budget; coordinates project activities with team members, other information technology services staff, user representatives, and outside vendors.
  • Organizes and converts data into relational tables using normalization process; analyzes access paths by identifying logical and physical indices.
  • Extracts, Transforms, and Loads (ETL) data from disparate systems to be loaded into other systems, data stores, and/or data warehouses.
  • Performs database performance analysis and assists in building interfaces between enterprise databases and end-user query tools.
  • Identifies table relationships and builds Structured Query Language (SQL) data manipulation scripts to extract data; troubleshoots data extraction issues.
  • Performs advanced database queries and develops reports using SQL.
  • Develops applications to extract, transform, and report data used for business process analysis and decision-making.
  • Maintains relational data models as new information and table structures are added.
  • Develops and documents operational and database standards, scripts, guidelines, and usage procedures; oversees the setup and implementation of IT systems and databases to ensure data integrity and compatibility.
  • Writes and maintains user and technical operating instructions and documentation; provides training to users and other technical staff and advises on best practices.
  • Maintains a healthy database environment for testing and quality assurance purposes.
  • Stays abreast of new trends and innovations in technology related to District operations; researches, recommends, and evaluates vendor solutions and technologies; implements improvements; works with staff to maintain, revise, or improve operations and systems.
  • Provides technical assistance, training, and customer service to staff and/or users.
  • Installs database products and upgrades; performs change control; verifies system resources as required; plans and executes backup and recovery.
  • Ensures that modifications to operating systems are compatible with the overall design of the database system.
  • Monitors, tunes, and optimizes database and application performance.
  • Resolves database errors and failures, manages system access, audits activities and resource utilization, and generates database objects availability.
  • Implements and documents database back-up and recovery processes and procedures; develops scripts and workflows to support stand-by recovery options.
  • Ensures database security by preparing access and control policies and procedures and reviewing permissions a regular basis.
  • Performs other duties as assigned.

  • QUALIFICATIONS

    Knowledge of:
  • Database design and administration in one or more of the following environments: Oracle, Microsoft SQL Server, MYSQL, and Access.
  • Reporting tools such as ARGOS and business intelligence tools such as Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Degree Works,
  • Principles and practices of configuring, changing, and implementing system backup solutions.
  • Modern Specific (UNIX) procedures/commands related to Relational Database Management System (RDBMS) analysis and programming.
  • Data management theory, principles, and practices and their application to a wide variety of services and programs.
  • Modern web-programming languages, environments and concepts to include but not limited to, several of the following: HTML5, Java, Javascript/jQuery, PLSQU, ColdFusion, Perl, PHP, AJAX, CSS and XML.
  • Computer equipment capacity and limitations, operating time, form of desired results.
  • Integration of enterprise system components.
  • Security measures as they apply to a database environment.
  • UNIX, Windows, Macintosh server operating systems and related software applications.
  • Technology, hardware and software, and current applications and practices related to data platforms.
  • Techniques and methods of database system evaluation, implementation, and documentation.
  • Recent and on-going developments, current literature, and sources of information related to the operations of the assigned programs.
  • English usage, spelling, vocabulary, grammar, and punctuation.
  • Techniques for providing a high level of customer service by effectively dealing with vendors and District staff.

  • Ability to:
  • Diagnose problems, perform remedial actions to correct problems, and/or recommend and determine solutions.
  • Lead groups or working sessions to establish new processes or technical design for improvement
  • Install, configure, test, upgrade, and tune databases.
  • Use methods of ETL for data loads between disparate systems.
  • Design, develop, and maintain applications using various development toolsets.
  • Develop test scripts that allow both functional and technical team participation.
  • Regularly report status and raise issues/risks as appropriate.
  • Develop prototypes/proofs of concepts to validate key project assumptions.
  • Organize, maintain, and update records systems and prepare reports.
  • Use English effectively to communicate in person, over the telephone, and in writing.
  • Use tact, initiative, prudence, and independent judgment within general policy, procedural, and legal guidelines.
  • Establish, maintain, and foster positive and effective working relationships with those contacted in the course of work.
  • Demonstrate understanding of, sensitivity to, and respect for the diverse academic, socio-economic, ethnic, religious, and cultural backgrounds, disability, and sexual orientation of community college students, faculty and staff.

  • MINIMUM QUALIFICATIONS:
  • Understanding of, sensitivity to, and respect for the diverse academic, socio-economic, ethnic, religious, and cultural backgrounds, disability, and sexual orientation of community college students, faculty and staff.
  • Any combination of training and experience that would provide the required knowledge, skills, and abilities is qualifying. A typical way to obtain the required qualifications would be: equivalent to graduation from an accredited four-year college or university with major coursework in management information systems, computer science, or a related field AND two (2) years of progressively responsible experience in database management and specific to the specialty area assigned which includes logical and physical database administration; integration; business intelligence, analytics, and report scripting; and/or data quality and integrity.

  • Licenses and Certifications:

    None.

    PHYSICAL DEMANDS

    Must possess mobility to work in a standard office setting and use standard office equipment, including a computer; vision to read printed materials and a computer screen; and hearing and speech to communicate in person and over the telephone. Standing in and walking between work areas is frequently required. Finger dexterity is needed to access, enter, and retrieve data using a computer keyboard or calculator and to operate standard office equipment. Positions in this classification frequently bend, stoop, kneel, and reach to perform assigned duties, as well as push and pull drawers open and closed to retrieve and file information.

    ENVIRONMENTAL ELEMENTS

    Employees work in an office environment with moderate levels, controlled temperature conditions, and no direct exposure to hazardous physical substances.

    APPLICATION PACKET:
  • A District on-line application on http://hr.fhda.edu/careers/. *In the application, you will provide information, which demonstrates your understanding of, sensitivity to, and respect for the diverse academic, socio-economic, ethnic, religious, and cultural backgrounds, disability, and sexual orientation of community college students, faculty and staff. Additionally, you will be asked to explain how your life experiences, studies or work have influenced your commitment to diversity, equity and inclusion.
  • A cover letter addressing your qualifications for the position.
  • A current resume of all work experience, formal education and training.

  • If any required application materials are omitted, the committee will not review your application. Items not required (including reference letters) will not be accepted. For full-consideration, all application packets must be received by 11:59 pm on the closing date.

    Please allow yourself ample time to complete your application and resolve any technical difficulties that may arise with your submission. We do not guarantee a response to application questions within 48 hours of the closing date. You may also visit our “Applicant Information” to assist with technical difficulties at: http://hr.fhda.edu/careers/a-applicant-instructions.html

    CONDITIONS OF EMPLOYMENT:

    Position: Full-Time, Categorical Funded, 12-months per year

    Starting date: As soon as possible upon completion of the search process.

    Excellent benefits package which includes medical coverage for employee and eligible dependents, dental, vision care, employee assistance program, long term disability, retirement benefits and basic life insurance. For information on our benefits package that includes medical for employees and dependents, visit our web site: http://hr.fhda.edu/benefits/index.html.

    Persons with disabilities who require reasonable accommodation to complete the employment process must notify Employment Services no later than the closing date of the announcement. The successful applicant will be required to provide proof of authorization to work in the U.S. All interviewing costs incurred by applicant are the responsibility of the applicant.

    For more information about our application process contact:

    Employment Services

    Foothill-De Anza Community College District

    12345 El Monte Road

    Los Altos Hills, California 94022

    Email: employment@fhda.edu

    http://hr.fhda.edu/


    To apply, visit https://fhda.csod.com/ux/ats/careersite/4/home/requisition/677?c=fhda

    jeid-611d3d0671f56b44860a86a27a8d5ad3

    Get job alerts

    Create a job alert and receive personalized job recommendations straight to your inbox.

    Create alert