ROI Agency

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

Procurement

• Procure goods and services and support sourcing and purchasing needs for assigned stations/business units
• Create and evaluate quotations/bids and recommend suppliers for selection
• Ensure timely delivery of goods and services
• Negotiate and place purchase orders
• Review and coordinate technical, cost, and delivery requirements
• Resolve accounts payable and delivery issues
• Identify opportunities to leverage spend by category
• Implement sourcing and negotiation strategies to achieve savings targets
• Measure and track performance within defined spend categories
• Develop and maintain supplier relationships
• Participate in cross-functional sourcing teams
• Support supplier KPI execution and continuous improvement
• Process claims against suppliers for unsatisfactory materials, delivery, or equipment
• Ensure warehouse personnel comply with Supply Chain policies and procedures
• Maintain optimum inventory levels while minimizing shortages and delays
• Respond to audits, surveys, and information requests
• Gather and analyze industry, economic, market, and spend data
• Support company Supplier Diversity initiatives
• Communicate sourcing decision impacts to management and employees
• Develop, negotiate, and administer supplier contracts
• Ensure compliance with company and Supply Chain policies

Data Analyst

Data Analyst

Sourcing Specialist IV