Job Summary

The Data Engineer is responsible for SJSU’s Campus Data Warehousing/Business Intelligence. This position will play a key 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.

The Data Engineer should possess a breadth of knowledge, technical skills, and strategic thinking to build a Data Warehouse to answer important questions across a variety of functional areas and collaborate with business stakeholders and IT management to understand solution requirements and system design for delivering the data model, developing and implementing the solution to deliver the desired business outcomes. 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, provide 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

• Capture, maintain, and apply data and information in order to support key business processes.
• Optimize how the organization uses data both internally and externally.
• Evaluate data that recognizes trends, calling insights, and making recommendations to the executive leadership team to make recommendations to define business strategy.
• Assist with the development of strategies and coordinates the implementation that support the Organization's development plans and that capture new opportunities.
• Partner cohesively with the broader Insights leaders across campus concerning the alignment capabilities.
• Oversee the implementation of analytic methodologies including segmentation, predictive modeling, advanced statistical methods, regression, experimental design, etc.
• Oversee the sourcing and creation of partnerships with key analytical vendors who can provide specialized expertise to assist with solution development while leading the in-house effort and managing CO interface.
• Oversee project plans, timelines, and vendor relationships to ensure releases are delivered with the highest quality, on-time and within budget.
• Partner with University stakeholders and be responsible for data analytics, custodianship, and infrastructure to ensure alignment with departmental data and analytics requirements to avoid conflicting activities, and develop the most efficient data analytics insights across the departments.
• Identify, interpret, analyze and address critical business issues, questions and to develop use cases.
• Organize and create an environment that makes data and information accessible with appropriate channels of access controls.
• Work with internal and external stakeholders to build a relationship of trust and play an advisory role in the use of data to improve performance and University-wide strategy formulation.
• Develop and document clear understandable plans, roadmaps and communication for business users, technical staff and IT groups.   
• Follow IT policies and standards for maintaining consistency and standards across SJSU campus.
• Be proactive in making recommendations and ensure users/departments have the most up-to-date technological solutions to perform their jobs and serve the university community effectively.

Knowledge, Skills & Abilities

• Advanced skills in analytical and holistic problem-solving, project management, effective communication and coordination of internal and external resources
• Ability to work effectively with faculty, staff, and senior administrators in areas other than technology to develop and implement appropriate uses of technology
• Advanced technical knowledge in IT systems and emerging technology trends and issues
• Ability to synthesize data from multiple sources to address complex business questions
• Advanced knowledge with analytics tools, “big data” technologies, cloud computing environments, relational database
• Advanced working knowledge in large ERP scale analytics, optimization, business intelligence, and statistics for IT organizations
• Ability to identify key insights and built large-scale data products that enhance the customer experience and improve operations processes
• Strong ability to provide guidance on emerging technologies to innovate and ensure the SJSU is well-positioned in delivering analytic solutions
• Strong ability to deliver on high-impact analytics projects
• Advanced working SQL knowledge and skills working with relational databases like Oracle, query authoring (SQL), as well as, working familiarity with a variety of databases
• Expert knowledge in high level programming languages like: Python, SQL, Java, and JavaScript
• Advanced knowledge in application architectures on public cloud platform such as Amazon Web Services (AWS), Google Cloud Platform (GCP) or IBM Cloud Pak
• Advanced knowledge of enterprise data architecture, ETL integration, data warehousing techniques, analytics/end-user reporting tool sets
• Advanced knowledge in Visualization tools like Google Data Studio, Tableau, Looker etc
• Knowledge building and optimizing ‘big data’ data pipelines, architectures and data sets
• Ability to build processes supporting data transformation, data structures, metadata, dependency and workload management
• Advanced knowledge of Systems development life cycle methodologies (Agile and Waterfall) in order to develop effective systems
• Advanced knowledge of application development, testing and deployment processes and tools
• Knowledge performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement
• Strong analytic skills related to working with unstructured datasets
• Knowledge with big data languages such as R, Python/PySpark and familiarity with cloud architecture
• Advanced knowledge in data mining, forecasting, simulation, and/or predictive modeling
• Advanced knowledge building BI environments with significant scale and scope

Required Qualifications

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

Preferred Qualifications

• Master’s in Business Administration, Computer Science or equivalent degree
• 3+ years’ experience developing, maintaining and collecting structured and unstructured data sets for analysis and reporting
• 3+ years advanced analytics experience in support of business strategy
• 3+ years working experience in implementing public cloud solutions

Compensation

Classification: Analyst/Programmer - Expert
CSU Salary Range: $7,371/month - $14,274/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.

Application Procedure

Click Apply Now to complete the SJSU Online Employment Application and attach the following documents:

• Resume
• Letter of Interest

All applicants must apply within the specified application period: January 9, 2025 through January 22, 2025. This position is open until filled; however, applications received after screening has begun will be considered at the discretion of the university.

Contact Information

University Personnel
jobs@sjsu.edu
408-924-2252

CSU Vaccination Policy

The CSU strongly recommends that all individuals who access any in-person program or activity (on- or off-campus) operated or controlled by the University follow COVID-19 vaccine recommendations adopted by the U.S. Centers for Disease Control and Prevention (CDC) and the California Department of Public Health (CDPH) applicable to their age, medical condition, and other relevant indications and comply with other safety measures established by each campus. The system wide policy can be found at https://calstate.policystat.com/policy/9779821/latest/ and questions may be sent to jobs@sjsu.edu.

Additional Information

Satisfactory completion of a background check (including a criminal records check) is required for employment. SJSU will issue a contingent offer of employment to the selected candidate, which may be rescinded if the background check reveals disqualifying information, and/or it is discovered that the candidate knowingly withheld or falsified information. Failure to satisfactorily complete the background check may affect the continued employment of a current CSU employee who was offered the position on a contingent basis.

The standard background check includes: criminal check, employment and education verification. Depending on the position, a motor vehicle and/or credit check may be required. All background checks are conducted through the university's third party vendor, Accurate Background. Some positions may also require fingerprinting. SJSU will pay all costs associated with this procedure. Evidence of required degree(s) or certification(s) will be required at time of hire.

SJSU IS NOT A SPONSORING AGENCY FOR STAFF OR MANAGEMENT POSITIONS. (e.g. H1-B VISAS)

All San José State University employees are considered mandated reporters under the California Child Abuse and Neglect Reporting Act and are required to comply with the requirements set forth in CSU Executive Order 1083 as a condition of employment. Incumbent is also required to promptly report any knowledge of a possible Title IX related incident to the Title IX Office or report any discrimination, harassment, and/or retaliation to the Office of Equal Opportunity.

Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act and Campus Housing Fire Safety Notification: 

Pursuant to the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act, the Annual Security Report (ASR) is also now available for viewing at https://www.sjsu.edu/clery/docs/SJSU-Annual-Security-Report.pdf. The ASR contains the current security and safety-related policy statements, emergency preparedness and evacuation information, crime prevention and Sexual Assault prevention information, and information about drug and alcohol prevention programming. The ASR also contains statistics of Clery crimes for San José State University locations for the three most recent calendar years. A paper copy of the ASR is available upon request by contacting the Office of the Clery Director by phone at 408-924-1501 or by email at clerycompliance@sjsu.edu.

Pursuant to the Higher Education Opportunity Act, the Annual Fire Safety Report (AFSR) is also available for viewing at https://www.sjsu.edu/clery/docs/SJSU-Annual-Fire-Safety-Report.pdf. The purpose of this report is to disclose statistics for fires that occurred within SJSU on-campus housing facilities for the three most recent calendar years, and to distribute fire safety policies and procedures intended to promote safety on Campus. A paper copy of the AFSR is available upon request by contacting the Housing Office by phone at 408-795-5600 or by email at uhs-frontdesk@sjsu.edu.

Campus Security Authority - In accordance with the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act (Clery Act) and CSU systemwide policy, this position is subject to ongoing review for designation as a Campus Security Authority. Individuals that are designated as Campus Security Authorities are required to immediately report Clery incidents to the institution and complete Clery Act training as determined by the university Clery Director.

Equal Employment Statement

San José State University (SJSU) is an Equal Opportunity/Affirmative Action employer committed to nondiscrimination on the basis of age, ancestry, citizenship status, color, creed, disability, ethnicity, gender, genetic information, marital status, medical condition, national origin, race, religion or lack thereof, sex, sexual orientation, transgender, or protected veteran status consistent with applicable federal and state laws. This policy applies to all SJSU students, faculty and staff programs and activities. Title IX of the Education Amendments of 1972, and certain other federal and state laws, prohibit discrimination on the basis of sex in all education programs and activities operated by the university (both on and off campus).

#LI-RC1