Job Details

Data Architect

Position Number: 6519809
Location: Santa Clara, CA
Position Type: Computing - Database Administration

Data Architect

Position Title:
Data Architect

Position Type:
Regular

Hiring Range:

Pay Frequency:
Annual
A. POSITION PURPOSE

Play a principal role in supporting, building, managing and planning SCU's core reporting applications and new technology.

B. ESSENTIAL DUTIES AND RESPONSIBILITIES

Provide technical leadership and expertise in the SCU BI and Analytics ecosystem.

Design and maintenance of Lakehouse and Prism environments for all functional areas.
- Identify requirements, design data process flow, prepare, and acquire external data sources.
- Create data pipelines that blend and transform data.
- Help identify, establish, configure and maintain security for Prism data sources.
- Publish, report, and maintain Prism and Lakehouse data.
Design, Development, Deployment and Maintenance of physical databases, dimensional data models, OLAP cubes, ETL layer design and data integration strategies
Data Audit, Conversion Build, Formatting and processing for reporting needs, data corrections, mass data updates into various areas of Workday system.
Design and development of custom data structures for SCU specific requirements to track Employee or Financial information, including requirements gathering from end users, design of system, development and testing of business process, reporting and integrations.
Redesign and troubleshoot system configurations per end user requirements, following implementation procedures, including testing and deployment
Provide expertise in Workday domain that may include but is not limited to:
- Business processes and custom report development, including BIRT
- Data conversion
- Holistic view of Workday system as a whole, and ability to identify impact of changes beyond discrete functional areas
- Help establish a well controlled systems environment by defining, documenting, and enforcing system standards
- Collaborate with the Workday Community in order to resolve issues and proactively remain informed about enhancements
- Identify opportunities for system improvement
Provide analysis, system changes, and organizational skills to solve various technical problems that may be outside the scope of other EA staff expertise
Help technically to expand and/or connect Enterprise Applications functionality with other technical services provided by IT

2. Provide project leadership

Lead teams of EA and functional office staff on focused projects to deliver new and/or improved services. In the process, engage key stakeholders, value different technical/functional approaches and possible solutions, explain criteria for decision-making and identify best choices, and help define and ensure successful testing and timely delivery.
Gather requirements, design, develop, deploy and maintain system modules, troubleshooting user issues and coordinating with multiple end user offices for cross functional projects.
Smoke test existing configurations, performance tune and explore new features and functionality during biannual feature release. Simplify existing system complexities and streamline processes for better system usage and user experience..
Work independently on projects not requiring a team approach

3. Mentor other EA staff in Lakehouse, BI and Reporting technology

Work with EA staff on improving their skills in specific areas. This may take the form of 1-on-1 tutoring or presentations to groups of EA staff
Conduct "walkthroughs" and best practices for proposed analysis or configuration modifications, and points out useful resources for further study
Identify areas for growth, provide insights and share helpful feedback, and provide tips for building professional networks.
Work with management to research, recommend, and implement training programs
Develop documentation on typical functions, processes, configurations used within BI and Analytics ecosystem.

4. Provide Support for legacy systems

Troubleshoot complex ETL mapping errors and issues
Create and maintain user accounts and security objects
Develop access controls and role-based security
Support and maintain PeopleSoft MSSQL databases.
Provide administration and support for Windows servers.
Monitor system performance and adjust for optimized performance.
Implement hardware and software upgrades.
Perform hardware and software problem analysis and maintenance.

5. Other Duties as Assigned

Learn new skills through Workday Community, HEDW and Rising conferences, and other educational opportunities
Special projects, as assigned

C. PROVIDES WORK DIRECTION

N/A
D. QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The items below are representative of the knowledge, skills, abilities, education, and experience required or preferred.

This position requires the ability to effectively establish and maintain cooperative working relationships within a diverse multicultural environment.

1. Knowledge, Skills and Abilities

Comprehensive knowledge of Workday reporting tools, including Calculated Fields, PRISM, and Standard, Custom, Composite, Matrix, BIRT and XPresso reports.
Comprehensive knowledge of PeopleSoft tools and architecture, including Application Engine, SQR, and PeopleTools.
Comprehensive knowledge of Lakehouse and Warehouse concepts, including ETL, star schema, and normalized and denormalized data structures..
Thorough knowledge of systems analysis tools and techniques
Thorough knowledge of project management techniques.
Comprehensive knowledge of data extraction and processing tools including SQL, Python, XML and JSON formatting.
Ability to multi-task and handle various projects simultaneously to drive timely results
Excellent oral and written communication and interpersonal skills

Education

BA/BS required. Graduate education is preferred.
Workday Pro Reporting or Prism Certification preferred.

Experience

Minimum of 8 years of experience in ERP support or software development lifecycle.
Minimum of 2 years of experience providing technical support for Workday Prism or similar warehouse environment, including reporting, integrations, security, business processes, and configuration management.
Minimum of 2 years of experience in database administration, preferably in a PeopleSoft environment

E. PHYSICAL DEMANDS

The physical demands described below are representative of those that must be met by an employee to successfully perform the essential functions of this job. In accordance with the Americans with Disabilities Act, as amended, the California Fair Employment & Housing Act, and all other applicable laws, SCU provides reasonable accommodations for qualified persons with disabilities. A qualified individual is a person who meets skill, experience, education, or other requirements of the position, and who can perform the essential functions of the position with or without reasonable accommodation.

Considerable time is spent at a desk using a computer terminal.
Required to travel to other buildings on the campus.
Required to attend conference and training sessions within Bay Area or in- or out-of-state locations.

F. WORK ENVIRONMENT

The work environment characteristics described below are representative of those an employee encounters while performing the essential functions of this job.

Typical office environment.
Mostly indoor office environments with windows.
Offices with equipment noise.
Offices with frequent interruptions.

EEO Statement

Santa Clara University is an equal opportunity employer. For a complete copy of Santa Clara University's equal opportunity and nondiscrimination policies, see https://www.scu.edu/title-ix/policies-reports/

Title IX of the Education Amendments of 1972

Santa Clara University does not discriminate in its employment practices or in its educational programs or activities on the basis of sex/gender, and prohibits retaliation against any person opposing discrimination or participating in any discrimination investigation or complaint process internally or externally. Information about Title IX can be found at www.scu.edu/title-ix. Inquiries can also be made to the Assistant Secretary of Education within the Office for Civil Rights (OCR).

Clery Notice of Availability

Santa Clara University annually collects information about campus crimes and other reportable incidents in accordance with the federal Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act. To view the Santa Clara University report, please go to the Campus Safety Services website . To request a paper copy please call Campus Safety at (408) 554-4441. The report includes the type of crime, venue, and number of occurrences.

Americans with Disabilities Act

Santa Clara University affirms its commitment to employ qualified individuals with disabilities within the workplace and to comply with the Americans with Disability Act. All applicants desiring an accommodation should contact the Department of Human Resources, and 408-554-5750 and request to speak to Indu Ahluwalia by phone at 408-554-5750 or by email at iahluwalia@scu.edu.

Telecommute

Santa Clara University is registered to do business in the following states: California, Nevada, Oregon, Washington, Arizona, and Illinois. Employees approved to telecommute are required to perform their work within one of these states.

To view the full job posting and apply for this position, go to https://wd1.myworkdaysite.com/en-US/recruiting/scu/scu/job/Santa-Clara-CA/Data-Architect_R6487-1