Job Summary
- DATE POSTED: 18 hours ago
- SCHEDULE: Full-time
- JOB CODE: 4745
- EMPLOYEE STATUS: Regular
- GRADE: I
- REQUISITION ID: 103862
- WORK ARRANGEMENT: Hybrid Eligible
Water Resources and Civil Infrastructure Group
Water Resources Business Analyst
Stanford University is one of Silicon Valley’s largest employers – and one of the most unique. Our mission is to educate future leaders and promote interdisciplinary, world-class research and teaching. This passion makes Stanford an intensely creative, rewarding, and challenging place to work. At the same time, our traditions of respect and collaboration sustain a humane, supportive environment in which to pursue your life and your career.
We are Land, Buildings & Real Estate (LBRE).
Our work is founded upon the collective value of dedication, innovation, expertise, teamwork, and continuous improvement. We are committed to serving the university’s academic mission, as well as preserving and enhancing Stanford’s 8,100 acres, and pride ourselves on supporting the teaching and research of the university as “Caretakers of a Legacy.”
The Water Resources & Civil Infrastructure Group within Sustainability & Energy Management in LBRE is responsible for operation and maintenance of roads, bridges, dams, storm drainage, sanitary sewer, and the water distribution systems and is currently recruiting for a newly created Business Analyst position.
Immediate Opening: Data Analyst
Job Title: Data Analyst 2
Job Code: 4745, Grade I
Exemption: Exempt
Location: Main Campus, 560 Fremont Road, Stanford CA
Work Schedule: Hybrid
What you will do in this role:
- You will continue development and implementation of water systems operations and use data collection, analytics and reporting processes and tools, working with the Water/Civil Group staff. The effort includes thorough review of metering data configuration, data flow continuity and categorization to facilitate trending, billing, reporting, and formulation of templates for documenting system changes, use variances/reports, and data adjustments.
- You will continue development and implementation of water systems operations and use data collection, analytics and reporting processes and tools, working with the Water/Civil Group staff. The effort includes thorough review of metering data configuration, data flow continuity and categorization to facilitate trending, billing, reporting, and formulation of templates for documenting system changes, use variances/reports, and data adjustments.
- Analyze and document current water business, operation, and financial procedures, such as invoicing and PO vendor payment process, EBS utility billing functions/process, Oracle eAM (Enterprise Asset Management) for asset programing and preventative maintenance.
- Work in partnership with Finance & Administration and SEM Business Systems focusing on water database communications and other related items.
- Collaborate in UAT water application testing before go live of water applications such as Watersmart, LBRE-IT applications, EBS utility billing updates/patches, oBI reporting upgrades, mobile eAM application enhancements and eAM upgrades/patches.
Create reporting solutions based on business process and data use for Water Resources & Civil Infrastructure.
Conduct monthly water use and wastewater in EBS, the utility billing system. Collect, review, and administer billing system data. Responsible and accountable for entering, updating, correcting water use data into database system such as EBS. Create new meter sites, meter changes/updates, site removals, manual read/input. Verify water ITRON water metering management information. Download and upload monthly meter read data to/from handhelds and EBS Utility Billing System. Develop eAM asset management systems information into eAM, create PM activities and routes, create, and assign PM schedules.
Specific Duties:
- Perform technical work associated with a wide variety of analytical data and fulfill routine to customized, single and multi-data sources’ information requests.
- Using Python using Pandas, matplotlib, and NumPy and their applications for data analytics:
- Review existing scripts created by cross-functional teams and understand the logic behind the scripts.
- Propose enhancements to the existing scripts better suit the ever-changing reporting needs
- Develop new scripts for new processes and reports once an understanding of the data is developed
- WaterSmart integration / MDI Process for OSI PI
- ADS/XiO
- Using SQL:
- Understands joins, unions, CTEs, aggregation
- Similar to above where reviewing and understanding existing scripts created by cross functional teams
- WaterSmart/MDI (all of the Python scripts have a SQL component to them as the billing system is being queried for the meter information)
- Running various reports
- Write queries to fulfill reporting requirements
- Ad-hoc reports for the conservation team to identify and verify meter sites and their attributes.
- Work with Engineering to get the meter age based on metadata change dates in the data base
- Analysis using Python
- Transforming unstructured data (JSON/XML) into structured data
- Transforming Itron supplied readings in XML format into a tabular format for validation. Supports SUI Business Systems efforts in the integration.
- Transforming JSON API returns from our external SCADA vendor into a tabular format for review and eventual storage in the database
- Data analysis, visualization, validation, and cleaning for time series data using Python
- While working on the data transformations, being able to validate, clean, and provide proof of concept visualizations to possible stakeholders as there are times that this is exploratory data rather than a full project.
- Support with Watersmart / external vendor integrations
- Understand and maintain existing scripts/logic behind queries to support the technical team that developed/maintains the automated integration
- Exploratory data analysis
- Explore existing data sources and identify possible new reporting solutions to create holistic data stories
- Billing
- Develop SQL queries for billing variance report reviews and streamlining of validation processes
The successful candidate will embrace the following:
LBRE Core Values of Leadership, Exploration, Gratitude, Accountability, Community and You, and Diversity, Equity, and Inclusion in their management style and help to build an organization where these qualities serve as the foundation for successful and rewarding careers for all employees. https://lbredei.stanford.edu/
LBRE views a strong culture of diversity, equity, and inclusion as one where everyone can thrive. It is a culture of trust and respect, where staff can be their authentic selves, feel safe and work in a place that they feel they belong. We strive to create a community that draws upon a wide pool of talent to unify excellence while fully embracing individuals from varied backgrounds, cultures, races, identities, life experiences, perspectives, beliefs, and values.
To be successful in this role you must bring:
- Bachelor’s degree and three years or relevant experience or a combination of education and relevant experience. Experience in a quantitative discipline such as economics, finance, statistics, or engineering.
- Knowledge of software systems design and operating principles including business process mapping, system architecture, business rules development, database design, database administration, and other functions required to create and sustain operations of modern computerized business processes for the university facilities management and utilities industry.
- Knowledge of project management principles and practices, especially as related to development of computerized business processes.
- Knowledge of computer system capabilities, business processes and workflow.
- Understanding of the software development life cycle.
- Experience with enterprise applications and understanding of database driven applications.
- In-depth knowledge and experience using and applying analytical software, database management system software, database reporting software, database user interface and query software, and data mining software.
- Demonstrated ability to collect data using a variety of methods, such as data mining and hardcopy or electronic documentation study, to improve or expand databases.
- Intermediate statistical ability.
- Ability to manage multiple activities in a deadline-oriented environment; highly organized, flexible, and rigorous attention to detail.
- Ability to use logic to calculate data; efficiently construct a database or scrutinize the form of a question.
- Ability to work with data of varying levels of quality and validity.
- Demonstrated ability to produce data in a clear and understandable manner meeting user requirement.
- Ability to work effectively with multiple internal and external customers.
- Ability to take a leadership role on projects and with users/clients.
- Excellent communication skills, both written and verbal, including the ability to bridge functional and technical resources by
- Communicating effectively with individuals of varying systems expertise and business needs.
- Listening, negotiation and conflict resolution skills.
- Ability to maintain good customer relations with clients and external vendors and partners.
- Must having experience with Python using Pandas, matplotlib, and NumPy, SQL
Note: Not all unique aspects of the job are covered by this job description. Other duties and responsibilities may be assigned as appropriate.
Additional Information:
Physical Requirements*:
- Constantly perform desk-based computer tasks.
- Frequently sit, grasp lightly/fine manipulation.
- Occasionally stand/walk, use a telephone.
- Rarely writing by hand, lift/carry/push/pull objects that weigh up to 10 pounds.
- *Consistent with its obligations under the law, the University will provide reasonable accommodation to any employee with a disability who requires accommodation to perform the essential functions of the job.
Working Condition:
- May work extended hours.
The expected pay range for this position is $92,000 – $115,000 per annum.
Stanford University provides pay ranges representing its good faith estimate of what the university reasonably expects to pay for a position. The pay offered to a selected candidate will be determined based on factors such as (but not limited to) the scope and responsibilities of the position, the qualifications of the selected candidate, departmental budget availability, internal equity, geographic location, and external market pay for comparable jobs.
At Stanford University, base pay represents only one aspect of the comprehensive rewards package. The Cardinal at Work website (https://cardinalatwork.stanford.edu/benefits-rewards) provides detailed information on Stanford’s extensive range of benefits and rewards offered to employees. Specifics about the rewards package for this position may be discussed during the hiring process.
Why Stanford is for you:
Imagine a world without search engines or social platforms. Consider lives saved through first-ever organ transplants and research to cure illnesses. Stanford University has revolutionized the way we live and enrich the world. Supporting this mission is our diverse and dedicated 17,000 staff. We seek talent driven to impact the future of our legacy. Our culture and unique perks empower you with:
- Freedom to grow. We offer career development programs, tuition reimbursement, or audit a course. Join a TedTalk, film screening, or listen to a renowned author or global leader speak.
- A caring culture. We provide superb retirement plans, generous time-off, and family care resources.
- A healthier you. Climb our rock wall, or choose from hundreds of health or fitness classes at our world-class exercise facilities. We also provide excellent health care benefits.
- Discovery and fun. Stroll through historic sculptures, trails, and museums.
- Enviable resources. Enjoy free commuter programs, ridesharing incentives, discounts and more!
The job duties listed are typical examples of work performed by positions in this job classification and are not designed to contain or be interpreted as a comprehensive inventory of all duties, tasks, and responsibilities. Specific duties and responsibilities may vary depending on department or program needs without changing the general nature and scope of the job or level of responsibility. Employees may also perform other duties as assigned.
Consistent with its obligations under the law, the University will provide reasonable accommodations to applicants and employees with disabilities. Applicants requiring a reasonable accommodation for any part of the application or hiring process should contact Stanford University Human Resources by submitting a contact form.
Stanford is an equal employment opportunity and affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law.
