Data Engineer - CDW
San Jose State University
San José
hace 6 días

Location : San José

Categories : Unit 9 - CSUEU - Technical Support Services, Probationary, Full Time, Information Systems & Technology

Job Summary

Reporting to the Interim Associate Chief Information Officer and Senior Director of Enterprise Solutions, the Data Engineer Campus Data Warehouse (CDW) is responsible for SJSU’s Campus Data Warehousing / Business Intelligence implementation.

This position will play an important role in the research, design, architecture, creation, development, implementation, and maintenance of Campus Data Warehouse.

This includes identifying and pulling data from 500+ individual databases across SJSU and curating them into a single data source in order to facilitate data-driven decisions.

Assist in conducting technical reviews, creating definitions of business problems, including the preparation of business / technical requirements to support the mission of the university and administrative departments, providing systems and technical support of vendor and locally developed software, and work with the Data Warehouse Project Manager, SJSU IT Enterprise Solutions resources, external vendors, and IT team members.

Duties and system assignments can be temporarily or permanently changed to meet the needs and goals of the department and university.

Key Responsibilities

  • Develop and maintain ETL processes to populate the data warehouse
  • Build and maintain Google BigQuery data warehouse interfaces to house data from various sources such as Oracle, MySQL, and Web APIs, etc.
  • Building and maintaining production data pipelines for data analytics
  • Partner cohesively with campus stakeholders to align with their strategic goals and initiatives through the implementation of Campus Data Warehouse
  • Collaborate with key analytical vendors who can provide specialized expertise to assist with solution development while developing the in-house effort and managing CO interface
  • Follow project plans, timelines, and vendor relationships to ensure releases are delivered with the highest quality, on-time and within budget
  • Provide the data analytics infrastructure that supports and achieves operational organization goals and targets
  • Apply performance tuning techniques to existing and new ETL scripts and analytical reports
  • Develop efficient database manipulation code to ensure reliable and consistent result sets
  • Develop appropriate and reusable data validation scripts to ensure the analytical dashboards are meeting the business requirements
  • Assist the development team in performing the troubleshooting of Campus Data Warehouse components as identified by the Business groups
  • Develop and deploy ad-hoc query extracts from Campus Data Warehouse as desired by the Business groups
  • Participate in overall analytics architecture and application roadmap.
  • Assist in the improvement of organization performance by utilizing not only the data already available to the organization, but also utilizing new and innovative sources of data
  • Develop custom reports as necessary using visualization tools such as Google Data Studio, Tableau and other visualization tools
  • Identify, interpret, analyze and address critical business issues, questions and to develop use cases.
  • Organizing and creating an environment that makes data and information accessible with appropriate channels of access controls.
  • Knowledge, Skills & Abilities

  • Intermediate skills in a Data Engineer role
  • Knowledge of Google Cloud Platform components including but not limited to Composer, Airflow, Dataproc, Sqoop, Cloud Storage, and BigQuery
  • Advanced knowledge in high level programming languages like : Python, SQL, Java, and JavaScript
  • Advanced knowledge of application development, testing and deployment processes and tools
  • Knowledge of data visualizations tools like Tableau, Google Data Studio, or equivalent experience
  • Knowledge and skills working with large data sets
  • Solid knowledge of ETL, ELT, reporting and analytics tools and environments
  • Ability to strategically think and build a Data Warehouse to answer important questions across a variety of functional areas
  • Ability to collaborate with business stakeholders and IT management to understand solution requirements and system design
  • Strong interpersonal, communication, organization and planning skills
  • Proficiency in management of multiple priorities to produce quality products for customers
  • Required Qualifications

  • A bachelor’s degree, preferably in computer science or business, or equivalent training and applied experience
  • 5+ years of experience in business applications analysis, design, and programming for medium or large scale, multi-programmed computers
  • Preferred Qualifications

  • 3+ years’ experience developing, maintaining and collecting structured and unstructured data sets for analysis and reporting
  • 3+ years of working experience in implementing cloud-based architecture (i.e. Google Cloud Platform or similar)
  • Compensation

    Classification : Analyst / Programmer-Expert

    Anticipated Hiring Range : $9,640 / month - $9,834 / month

    CSU Hiring Range : $6,249 / month - $12,100 / month

    San José State University offers employees a comprehensive benefits package typically worth 30-35% of your base salary. For more information on programs available, please see the Employee Benefits Summary .

    Reportar esta oferta

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Mi Correo Electrónico
    Al hacer clic en la opción "Continuar", doy mi consentimiento para que neuvoo procese mis datos de conformidad con lo establecido en su Política de privacidad . Puedo darme de baja o retirar mi autorización en cualquier momento.
    Formulario de postulación