Data Analyst

• Develop and optimize complex SQL queries and data models
• Develop and maintain relational databases, including schemas, tables, functions, and views
• Design, build, schedule, and maintain ETL processes and around-the-clock automated data pipelines
• Troubleshoot data quality, availability, integration, and performance issues
• Develop and maintain software, APIs, integrations, and reporting tools supporting Power Resources data
• Analyze electric load and resource data across hourly, daily, weekly, monthly, and annual periods
• Provide power market analytics and monitoring for operations, planning, and decision-making
• Organize, validate, and analyze data for energy settlements and reconciliation reporting
• Create dashboards, visualizations, KPI reports, and recurring and ad-hoc reports
• Perform statistical modeling and analysis of structured and unstructured datasets
• Work with large time-series datasets from internal and external sources
• Partner with end users to understand business needs, document technical requirements, and develop data and reporting solutions
• Present analytical findings and recommendations to technical and non-technical stakeholders
• Participate in cross-functional initiatives improving systems, workflows, controls, and reporting
• Provide cross-training and backup support for other Power Resources analytics functions
• Work occasional hours outside normal business hours for emergency restoration, critical operational needs, or special projects

• Develop and optimize complex SQL queries and data models
• Develop and maintain relational databases, including schemas, tables, functions, and views
• Design, build, schedule, and maintain ETL processes and around-the-clock automated data pipelines
• Troubleshoot data quality, availability, integration, and performance issues
• Develop and maintain software, APIs, integrations, and reporting tools supporting Power Resources data
• Analyze electric load and resource data across hourly, daily, weekly, monthly, and annual periods
• Provide power market analytics and monitoring for operations, planning, and decision-making
• Organize, validate, and analyze data for energy settlements and reconciliation reporting
• Create dashboards, visualizations, KPI reports, and recurring and ad-hoc reporting
• Perform statistical modeling and analysis of structured and unstructured datasets
• Work with large time-series datasets from internal and external sources
• Partner with end users to understand business needs, document technical requirements, and develop data and reporting solutions
• Present analytical findings and recommendations to technical and non-technical stakeholders
• Participate in cross-functional initiatives improving systems, workflows, controls, and reporting
• Provide cross-training and backup support for other Power Resources analytics functions
• Occasionally work outside normal business hours for emergency restoration activities, critical operational needs, or special projects

• Analyze and interpret data to provide strategic and tactical support
• Develop and implement data collection systems and strategies that optimize statistical efficiency and data quality
• Analyze collected data using statistical techniques and provide ongoing reports
• Identify, analyze, and interpret trends or patterns in complex data sets
• Support end-to-end analysis development, management, and delivery
• Interface with business and technical teams to understand context and business value in data
• Build relationships with internal customers and develop analytic solutions to meet business needs
• Produce dynamic, meaningful, clear, and informative reports and dashboards using standard business intelligence tools
• Help executive management solve highly complex problems
• Perform additional projects and duties as assigned

Data Analyst jobs in Oregon

Data Analyst

Data Analyst

Data Analyst II