Data Specialist

Looking for a career at an organization that is mission-focused in an industry that provides essential services to its local community?  Wanting a 4x10 work schedule?  Looking to become a valued member of a team responsible for influencing the strategic direction of an organization? Trying to find a position with a competitive salary AND excellent benefits? Apply today for the full-time Data Specialist position at Clatskanie People’s Utility District.  

This position will be responsible for preparing data reports, submittals, and invoices to meet contractual obligations, regulatory requirements, or internal analysis needs. The successful candidate will have the opportunity to influence the strategic direction and fiscal performance of our hydro-powered, locally-owned electric utility and will be given the chance to develop professionally. The District is seeking someone who is detail-oriented, professional, collaborative, and has an analytical disposition; experience in the electric utility industry is not required.

Ideal Candidate! Someone who is intellectually-curious, detail-oriented, and loves turning data into information.    

Benefits! The District benefit package not only includes 100% coverage of excellent medical and dental programs, but Oregon PERS retirement and District matching funds toward employee retirement savings.  The District has an HRA VEBA program and significant other employer paid benefits.

Job satisfaction! You’ll be joining Clatskanie PUD’s Energy Resources and Services department which is focused on executing both strategic initiatives and operational imperatives of the District.  We strive to be Insightful, Professional, Collaborative, and Driven!

Compensation range is $65,246 to $95,693 and will be based on qualifications and experience.

 Submit completed application, résumé, and cover letter to: Human Resources, PO Box 216, Clatskanie, OR 97016, secure fax 503-308-4884, email hrclatskaniepud.com, or complete the online application. This position remains open until 5:00 pm, May 17, 2021, or until filled, with a flexible start date in June 2021. If you have questions or need additional information, please contact Lynn Donner or Sarah Johnson: 503-728-2163.

Clatskanie PUD is an equal employment opportunity employer, following all necessary federal and state employment laws required. Clatskanie PUD will make reasonable accommodations for those covered by the Americans with Disabilities Act. Veterans will receive hiring preference as required by law.

 

ESSENTIAL FUNCTIONS

 

·        Understand District power contracts and resources, prepare contract submissions, calculate settlements based on contractual arrangements, and recommend strategies to maximize the value of contracts and resources.

·        Prepare data reports, submittals, and invoices to meet contractual obligations, regulatory requirements, or internal analysis needs. Maintain a comprehensive list of all reports and submittals and review deadlines with Manager monthly.

·        Import and process month-end data to calculate industrial invoices based on power supply contracts.

·        Prepare and send power invoices to industrial customers and wholesale counterparties.

·        Independently verify and error check power invoices received by the District for accuracy based on the contractual relationship with the counterparty.

·        Communicate with wholesale counterparties and scheduling agent.

·        Develop data quality management tools (queries, reports, data connections, etc.) and collaborate with coworkers to implement them.

·        Work with cross-functional team to identify opportunities to utilize Advanced Metering Infrastructure data to add value or solve problems for the District.

·        Manage, update, and validate power department’s SQL database.

·        Develop and maintain data queries used by coworkers in tools used for analysis.

·        Demonstrate effective decision making in areas of responsibility. Support and present positive attitude for all directives and decisions of the District. Foster and support collaboration among peers, staff, and teams to ensure the effective and efficient achievement of goals and objectives.

·        Interact successfully and work effectively while displaying professionalism, a cooperative attitude, open communication, and respect with all levels within the organization, outside agencies, consultants, customers and the general public.

 

·       Support and comply with safety leadership and all safety programs within the District.

·       Maintain a cooperative and approachable attitude with internal and external customers.

·       Attendance at in-house meetings and other business meetings will be required.

·       Seek opportunities to streamline process and workflow.

·        Perform other related duties as assigned for which they are qualified, and all other duties as assigned.

*NOTE: All Clatskanie PUD employees are expected to work varying amounts of unscheduled overtime during power restoration activities or scheduled overtime required to accomplish special projects.

 

·        Strong organizational skills, attention to detail, and highly skilled at error checking.

·        General statistical aptitude.

·        Database query techniques, especially Structured Query Language (SQL).

·        Developing, testing, and using SQL queries, reports, and data connections in Excel files

·        Complete assignments in an appropriate time period.

·        Strong analytical skills, problem solving skills, intellectual curiosity, and ability to learn and adapt to new systems, methods, and process changes.

·        Professional demeanor that faithfully and consistently represents the District in all aspects of job responsibilities including day-to-day interactions and when representing the District’s interests in business meetings.

·        Good reasoning and judgment to maintain confidential information.

·        Ability to receive guidance and supervision, follow work rules, safety practices, work procedures, and meet punctuality and attendance standards.

·        Ability to communicate well both orally and in writing.

·        Work well with a diverse group of people and function as part of a team. 

·        Ability to comprehend and follow legal regulations and compliance information. 

·        Know, understand, and support public power goals, history, and direction.

  

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the job duties and responsibilities of the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the job duties and responsibilities.

 

 

·        Frequent walking, standing, and sitting.

·        Extensive use of a personal computer requiring sitting for extended periods of time, adequate eyesight for viewing and manual dexterity.

·        Ability to exert 50 pounds of force occasionally, and/or in excess of 20 pounds of force frequently, and/or in excess of 10 pounds of force constantly to move objects.

·        Hearing and speech must be adequate to communicate with other employees, personnel from outside agencies, and the general public, in person and on the telephone.

 

·       Work will normally be performed in an office setting with extended periods of sitting and extended periods of time working at a computer station. The required dress is that of a professional that is presentable to the public and appropriate for the position. Personal hygiene should be appropriate for an office environment that is shared by many.

·        Occasional exposure to all weather conditions with related road conditions, when traveling, may be encountered.

·        Must be able to work long hours in stressful conditions such as assisting in restoring power during storms, emergencies, other power outage situations, or special projects.

 

 

·        Completion of a Bachelor’s Degree in an applicable major, for instance: Information Systems, Data Sciences, Computer Science, Economics, Accounting, Business, Applied Mathematics, or Engineering.

·        Proficiency in querying data from relational databases (like Oracle or SQL).

·        Mathematical abilities in the practical application of algebra and statistics. 

·        Must be able to communicate effectively both orally and in writing; comprehend and use English effectively including producing all forms of communications in a clear, concise, and understandable manner to intended audiences.

·         Punctuality and regular attendance is required.

·         Proficiency in the use of computers is required, including the use of Microsoft Office applications.

 

*NOTE:  Complete achievement of certain of the above specifications may not be required if, in the opinion of the District hiring team, a particular candidate possesses significant offsetting characteristics, such as past accomplishments, experience, education, or estimate of future potential.