Lead Data Engineer

Job Summary

The Lead Data Engineer is responsible for SJSU’s Campus Data Warehousing / Business Intelligence implementation. 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 Lead 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

• Lead role where the position defines and oversees how the organization captures, maintains, and applies data and information in order to support key business processes.
• Implement the strategic direction for building data management programs and optimizing 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.
• Develop the data strategy and vision for building the analytic ecosystem to evaluate, acquire, integrate, and consume data that drive insights.
• Define cloud strategy and lead cross-disciplinary teams to design and implement a scalable future state analytical platform architecture.
• Assists 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.
• Lead and own the interaction with campus technical support staff and customers to provide reliable services.
• Proposes and leads analytics and organization intelligence initiatives in the Data and Analytics area.
• Defines appropriate analytical models necessary to support use cases and leverages the power of predictive insights and analytics.
• Defines and enables teams to implement augmented intelligence and machine learning algorithms and models for efficient processing and delivery of analytics.

Knowledge, Skills & Abilities

• Advanced skills in strategic planning, analytical and holistic problem-solving, project management, effective communication and coordination of internal and external resources
• Strong interpersonal, communication, organization and planning skills
• Ability to understand complex challenges and lead teams of technologists to deploy appropriate technological solutions that meet campus vision and mission
• 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
• Strong ability to provide strategic 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
• Skilled in recruiting, developing, inspiring, leading a growing team of data analysts.
• 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.

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 leading a team
• 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,020 / month - $13,594 / 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 .

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 : May 16, 2024 through May 30, 2024 . 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

and questions may be sent to

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 .

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