New Contractor - Information Technology Job in San Ramon, CA!
Position Title: Contractor - Information Technology

Position Number: 341755

Location: San Ramon, CA 94583

Position Type: Temporary

Required Skill Set:

Data Analysis, SSIS, SSRS

Position Description:

**C2C is not available**
**Only U.S. Citizens and those authorized to work in the U.S. can be considered as W2 candidates.**
Job title: Contractor - Information Technology
Duration: 07/06/2020 to 12/31/2020
Work Location: San Ramon, CA 94583


TOP 5:
- OSISoft PI Rockstar
- ETL and SSIS (no SSIS is fine, as long they have ETL)
- Data Analytics
- Data Quality

- Highly preferred: UTILITY INDUSTRY exp.
- Remote: Local/non-local are okay

Preferred Position Title: OSI PI Data Engineer
Department Overview

Join a high-performing dynamic team within Client that is working in an exciting operational environment where we are transforming electric grid technology to support smart grid. The Electric Grid Operations Business Applications Data and Analytics team owns the Client Electric OSI PI platform, data warehouses and a multitude of analytics products, the number of which is growing at a rapid rate. The Data and Analytics team is also responsible for charting the path for the data strategy of the overall Business Applications organization. The customer base of the team includes Electric Distribution Operations, Electric Distribution Planning, Electric Transmission Operations, Electric System Protection, Substation Asset Strategy, Substation Maintenance and Substation Automation. We develop innovative analytic solutions to help Client operate the grid of the future. We are seeking a dynamic individual to join our team as the OSI PI Data Engineer.

Position Summary

The Data Engineer will be developing a career for himself/herself filled with excitement! The utility industry is in the middle of a massive transformation. Energy generation is going from 100% centralized to significantly distributed. Operational decision-making and control actions are going from largely manual to largely automated. Technologies such as energy storage, electric vehicle, autonomous vehicle, robots, drones and machine learning are either already changing or are poised to change the way electric utilities operate. Sophisticated software applications are at the heart of all these changes. And it''s the Business Applications team that develop and support these applications. As part of the Business Applications team, the Data Engineer will be responsible for developing and providing support for these applications. This role has a lot of opportunity to learn new things and to come up with creative solutions to difficult problems. The Data Engineer must be able to work with individual contributors, and supervisor and manager level leaders in the Electric Operations organization to gain credibility and trust of both leadership and peers. The successful candidate must be able to work closely with team members, peers within the organization, external partners and the IT organization to deliver high quality support and solutions for business users. A strong sense of ownership and accountability are required, to ensure the infallible quality of support and solutioning that is necessary in electric operations.


• BA/BS in Business, Engineering, Computer Science/Information Systems or equivalent
• 5-7 years of mixed experience in OSISoft PI – architecture, development, system administration and end use
• 3-5 years of experience in analyzing data and presenting the results
• 3-5 years of experience in using relational databases – DML, DDL, DCL and TCL
• 3-5 years of experience in developing and maintaining ETL jobs
• 3-5 years of experience with SSIS
• 1-3 years of experience with SSRS or Power BI
• 1-3 years of experience within any area of Electric Operations in the electric utility industry
• 1-3 years of experience in data quality improvement, especially in detecting data quality issues in OSI PI data
• Ability to work independently and to take accountability
• Ability to be creative
• Ability to communicate in a brief and to the point manner
• Proficiency in Microsoft Word, Excel, PowerPoint and SQL

• 3-5 years of experience within any area of Electric Operations in the electric utility industry
• 3-5 years of experience with scripting languages such as R, python, powershell

• Understand user requirements
• Understand the data in the different data sources
• Develop and maintain (issue resolution and enhancement) ETL jobs from various systems including OSI PI into MS SQL Server
• Develop and maintain (issue resolution and enhancement) analytical reports
• Come up with innovative ideas to solve business problems using data
• Document all work

Send me a reminder to complete this application

Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.

Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.)
Employee Comments
We want you to work with us, but don't take our word for it. Take a look at this sampling of employee comments. They speak for themselves.
About Rose
  • Founded in 1993
  • 21 office locations across the U.S.
  • 130+ Customers; corporations and government agencies
  • Employee Oriented Company
  • Challenging Assignments across the U.S.
  • Continuous Professional Development
  • Challenging, Exciting and Professional Atmosphere
Join Our Team Today!
Follow Us