Energy Data Analyst I

{
  "content_hash": "768ae9c09bb19ec120ba7a6735bb2d1e474ed2cc24aa25923196d3eaf8f2f4d5",
  "source_hash": "1767821ec347c17ad2ffec305824a1bc5c2ab3989ec5a18b1e4666107ddd3d10",
  "last_changed_at": "2026-05-30T05:59:28.745Z",
  "active_status": "active"
}

{
  "language": "en",
  "location": {
    "raw": "The Dalles, Oregon, 97058, United States",
    "city": "The Dalles",
    "region": null,
    "country": "United States",
    "is_remote": false,
    "confidence": 0.95
  },
  "salary_max": null,
  "salary_min": null,
  "inferred_at": "2026-06-06T10:23:36.284Z",
  "launch_scope": {
    "reason": "bamboohr_production_catalog",
    "included": true,
    "location": {
      "raw": "The Dalles, Oregon, 97058, United States",
      "city": "The Dalles",
      "region": null,
      "country": "United States",
      "is_remote": false,
      "confidence": 0.95
    },
    "countries": [
      "United States"
    ]
  },
  "remote_policy": null,
  "salary_period": null,
  "workplace_type": null,
  "salary_currency": null
}

{}

{
  "list_job": {
    "id": "70",
    "isRemote": null,
    "location": {
      "city": "The Dalles",
      "state": "Oregon"
    },
    "atsLocation": {
      "city": null,
      "state": null,
      "country": null,
      "province": null
    },
    "departmentId": "18637",
    "locationType": "2",
    "jobOpeningName": "Energy Data Analyst I",
    "departmentLabel": "13 - Power Resources",
    "employmentStatusLabel": "Full-Time Non-Union"
  },
  "detail_errors": [],
  "detail_job_opening": {
    "location": {
      "city": "The Dalles",
      "state": "Oregon",
      "postalCode": "97058",
      "addressCountry": "United States"
    },
    "datePosted": "2026-05-20",
    "atsLocation": {
      "city": null,
      "state": null,
      "country": null,
      "countryId": null
    },
    "description": "<p><span style=\"font-weight: bold\">Northern Wasco County PUD is seeking an experienced Energy Data Analyst I to join our growing Power Resources team. This full-time, exempt position offers a Monday – Friday 5/8 schedule.</span></p>\n<p><br></p>\n<p>The Energy Data Analyst I serves as a data and analytics resource to the Power Resources Department, with a focus in energy supply analytics. Develops and maintains databases, software, and automated data pipelines supporting critical Power Resources data. Builds complex SQL queries, ETL workflows, and dashboards; compiles and distributes KPI and reconciliation reports; and supports virtual server environments. Analyzes electric load and resource data (hourly through annual) related to settlements with counterparties and organizes data for settlement and reconciliation reporting. Supports end users to define requirements, deliver reporting and analytics solutions, and communicate findings and recommendations to support decision-making.</p>\n<p><br></p>\n<p><br></p>\n<p><span style=\"font-size: 12pt\"><span style=\"text-decoration: underline\"><span style=\"font-weight: bold\">SUMMARY OF BENEFITS:<span> </span></span></span><span style=\"font-weight: bold\">We are proud to offer a comprehensive and very competitive benefits package including but not limited to:</span></span></p>\n<p><br></p>\n<ul>\n<li><span style=\"font-size: 12pt\">Generous PTO Accruals</span></li>\n<li><span style=\"font-size: 12pt\">11 Paid Holidays</span></li>\n<li><span style=\"font-size: 12pt\">100% employer paid premium for Medical/Rx/Dental for individual and/or family coverage</span></li>\n<li><span style=\"font-size: 12pt\">100% employer paid premium for vision coverage for individual and/or family coverage</span></li>\n<li><span style=\"font-size: 12pt\">100% employer paid Basic Life Insurance 2X annual salary</span></li>\n<li><span style=\"font-size: 12pt\">401(k) 7.5% base + 7.5% match = 15% total possible employer contribution</span></li>\n<li><span style=\"font-size: 12pt\">457(b) </span></li>\n<li><span style=\"font-size: 12pt\">100% employer paid Short Term Disability and Long Term Disability</span></li>\n<li><span style=\"font-size: 12pt\">HRA VEBA employee funded</span></li>\n<li><span style=\"font-size: 12pt\">Wellness Incentive to HRA VEBA employer funded</span></li>\n<li><span style=\"font-size: 12pt\">100% Paid Business Travel Insurance</span></li>\n<li><span style=\"font-size: 12pt\">Voluntary benefits</span></li>\n</ul>\n<p><br></p>\n<p><span style=\"font-weight: bold\"><span style=\"text-decoration: underline\">GENERAL ACCOUNTABILITIES AND ESSENTIAL FUNCTIONS:</span></span></p>\n<p><br></p>\n<ul>\n<li>Provide power market analytics and monitoring to support Power Resources operations, planning, and decision-making.</li>\n<li>Analyze electric load and resource data (hourly, daily, weekly, monthly, and annual) related to settlements with counterparties; organize data and assist with reconciliation reporting.</li>\n<li>Develop, update, and maintain databases, software, and reporting tools that support critical Power Resources data and workflows.</li>\n<li>Develop complex SQL queries and data models; administer and support relational database management systems.</li>\n<li>Design, build, and manage ETL processes and around-the-clock (ATC) data pipelines; troubleshoot data quality, availability, and performance issues.</li>\n<li>Create dashboards and visualizations; compile, validate, and distribute KPI reports and other periodic or ad-hoc reporting.</li>\n<li>Perform statistical modeling and analysis of structured and unstructured datasets; identify trends and present results through reports and presentations.</li>\n<li>Develop and maintain data integrations and APIs that collect large time-series datasets from internal and external sources.</li>\n<li>Work with end users to understand data needs, document technical requirements, and deliver solutions on strict deadlines.</li>\n<li>Prepare and present written and verbal recommendations to support strategy and operations aligned with District goals.</li>\n<li>Participate in cross-functional initiatives and special projects to improve systems, workflows, controls, and reporting.</li>\n<li>Maintain confidentiality of sensitive information and exercise professional judgment and discretion.</li>\n<li>Demonstrates cultural competency through respectful, inclusive work habits and through the valuing and welcoming of cultural differences in all position responsibilities.</li>\n<li>Supports the District’s mission to serve our customers and foster a safe and positive work environment by personally exhibiting behavior that aligns with the District’s Core Values &amp; Beliefs.</li>\n<li>Must perform the duties of this position in a safe and efficient manner and follow all safety regulations and protocols.</li>\n<li>Other duties as assigned.</li>\n</ul>\n<p><br></p>\n<p><span style=\"font-weight: bold\"><span style=\"text-decoration: underline\">Secondary Functions:<br></span></span></p>\n<p><br></p>\n<ul>\n<li>Serve as backup support for Data Analyst II or other future scoped analytics role reducing single points of failure.</li>\n<li>Performs other Power Resources Department duties in the absence of other assigned personnel, or as needed.</li>\n<li><span style=\"font-size: 12pt\">All PUD employees are expected to work outside of normal business hours when required during emergency restoration activities and to accomplish other special projects.</span></li>\n</ul>\n<p><br></p>\n<p><span style=\"font-weight: bold\">Skills/Knowledge/Abilities: </span><br><span style=\"font-weight: bold\"><em>PLEASE NOTE: This position requires the use of various tools/equipment that are related to performing the essential functions of this job.</em></span></p>\n<p><br></p>\n<ul>\n<li><span><span style=\"font-weight: bold\">Must-have technical skills:</span></span><span> SQL; relational database management systems (RDBMS); ETL tools; object-oriented programming and Python; Git/GitHub; Windows and Linux; Microsoft Excel; proficiency in EDRMS and Microsoft Office Suite.</span></li>\n<li><span><span style=\"font-weight: bold\">Must-have professional skills:</span></span><span> strong organizational, analytical, and communication skills; strong technical writing and oral presentation skills; strong mathematical skills; attention to detail and accuracy; ability to handle confidential information responsibly; ability to work independently and collaboratively to meet strict deadlines; ability to implement and complete cross-functional initiatives; ability to present data and create visualizations that support decision-making in the Power Resources Department.</span></li>\n<li><span style=\"font-weight: bold\">Preferred Skills:</span><span style=\"font-size: 12pt\"> PostgreSQL/pgAdmin; Apache NiFi; Grafana; R/RStudio; Java; cloud storage/cloud computing solutions; Microsoft SharePoint</span></li>\n</ul>\n<p><br></p>\n<p><span style=\"font-weight: bold\"><span style=\"text-decoration: underline\">Supervisory and/or Functional or Technical Responsibility or Oversight:</span></span></p>\n<p><span style=\"font-weight: bold\"><br></span></p>\n<ul>\n<li>No supervisory responsibilities.</li>\n</ul>\n<p> </p>\n<p><span style=\"font-weight: bold\"><span style=\"text-decoration: underline\">QUALIFICATIONS: </span></span><span style=\"font-weight: bold\">Recommended Education, Training &amp; Experience (includes licenses or certifications): </span><em>Other combinations of education and/or experience demonstrating the knowledge, skills, and abilities required to do the work will also be considered.</em><br></p>\n<p><br></p>\n<p><span style=\"font-weight: bold\">Education/Experience:</span></p>\n<ul>\n<li>Bachelor’s degree in computer science, data science, mathematics, statistics, physical science, natural science, engineering, or a related field.</li>\n<li>One to two (1–2) years of professional experience or advanced academic study in data analytics, business intelligence, software development, or a related area.</li>\n<li>Experience supporting an electric utility, energy market analytics, creating data displays and dashboards, settlements/reconciliations, SCADA, or energy/financial reporting systems is preferred.</li>\n</ul>\n<p> </p>\n<p><span style=\"font-weight: bold\"><span style=\"text-decoration: underline\">Job Scope: </span></span><br></p>\n<p><span style=\"font-weight: bold\"><br></span></p>\n<ul>\n<li>Works on complex assignments requiring judgment, analysis, and initiative to identify root causes, develop options, and make recommendations.</li>\n<li>Moves quickly from problem definition to solutions; selects and adapts order, priorities, and work methods while interpreting applicable policies, procedures, and guidelines.</li>\n<li>Work affects data accuracy, reliability, service quality, and operations and may have moderate financial and reputational impact.</li>\n<li>Tasks and information relative to this position are of a confidential and/or sensitive nature requiring strict confidentiality and professional conduct.</li>\n</ul>\n<p><br></p>\n<p><span style=\"font-size: 12pt\"><span style=\"text-decoration: underline\"><span style=\"font-weight: bold\">Mental or Visual Demand:<span> </span></span></span></span>Concentrated mental and/or visual attention; the work involves performing complex tasks to very close accuracy and quality specifications; or a high degree of hand and eye coordination for sustained periods.</p>\n<p><br></p>\n<p><span style=\"text-decoration: underline\"><span style=\"font-size: 12pt\"><span style=\"font-weight: bold\">Working Conditions:</span></span></span><br></p>\n<p><span style=\"font-size: 12pt\">The job is typically performed under very comfortable working conditions; any disagreeable elements are generally absent during normal performance of job. </span></p>\n<p><span style=\"text-decoration: underline\"><span style=\"font-size: 12pt\"><span style=\"font-weight: bold\"><br></span></span></span></p>\n<p><span style=\"text-decoration: underline\"><span style=\"font-size: 12pt\"><span style=\"font-weight: bold\">Physical Requirements:</span></span></span><span style=\"font-size: 12pt\"><br></span><span>Requirements are those consistent with normal office administrative or clerical positions such as sitting, standing, walking, keyboarding. May push up to 50lbs, and/or lift, pull, or carry up to 25lbs. </span></p>\n<p><br><br></p>\n<p><span>This organization believes that each employee makes a significant contribution to our success.  That contribution should not be limited by the assigned responsibilities.  Therefore, this job description is designed to outline primary duties, qualifications, and job scope, but not to limit the incumbent nor the organization to just the work identified.  It is our expectation that each employee will offer their services wherever and whenever necessary to ensure the success of our endeavors. Northern Wasco County PUD reserves the right to revise or change job duties and responsibilities. This job description does not constitute a written or implied contract of employment.</span></p>\n<p><br></p>\n<p><span style=\"font-size: 12pt\"><span style=\"font-weight: bold\">*Northern Wasco County PUD is an Equal Opportunity Employer.</span></span></p>",
    "compensation": "$80,851.20 - $121,276.80",
    "departmentId": "18637",
    "locationType": "2",
    "seekPromoted": false,
    "jobCategoryId": null,
    "jobOpeningName": "Energy Data Analyst I",
    "departmentLabel": "13 - Power Resources",
    "jobOpeningStatus": "Open",
    "minimumExperience": "Experienced",
    "jobOpeningShareUrl": "https://nwcpud.bamboohr.com/careers/70",
    "employmentStatusLabel": "Full-Time Non-Union"
  }
}