Data Analyst Scientist
Data Analyst Scientist
Customer Analytics, Reporting & Engagement (CARE)
Industry: Utilities / Energy
Location: New York, NY - remote candidates considered
Work Arrangement: Local or remote; Eastern Time preferred
Employment Type: Contract, approximately 1–2 years
Openings: 2
Schedule: Standard business hours
Target Start Date: ASAP
Interview Process: One interview, approximately 30 minutes
About the Role
Our client, a large utility organization, is seeking two Data Analysts/Scientists to support its Digital Products Customer Analytics, Reporting & Engagement (CARE) team. These roles will analyze utility usage, billing, and digital engagement data to improve customer-facing products, customer experiences, and business decisions.
Working closely with Product Owners, engineers, and business subject matter experts, these individuals will develop reports and dashboards, validate data and analytical tools, and turn findings into actionable recommendations. Projects include personalized rate recommendation and bill comparison tools that use historical customer usage and billing information.
Prior utility industry experience and hands-on experience with AMI (Advanced Metering Infrastructure) data are required.
Key Responsibilities
· Analyze large, complex datasets, including AMI usage, Customer Care & Billing, and digital engagement data.
· Review data extracts and multiple data sources to identify trends, patterns, common themes, anomalies, and data quality issues.
· Analyze customer usage and billing information to identify opportunities related to customer savings, billing outcomes, energy usage, and clean energy programs.
· Build Power BI dashboards, recurring reports, and visual summaries to track customer engagement, product performance, billing outcomes, and other key metrics.
· Support analytics for customer-facing rate recommendation and bill comparison tools, including ongoing performance monitoring after launch.
· Track website and digital product engagement, including page views, clicks, and customer interactions, using Google Analytics.
· Review and validate datasets, vendor dashboards, and analytical tools for accuracy and consistency.
· Partner with engineers, Product Owners, and business teams on data integrations, testing, validation, and resolution of data quality issues.
· Help define consistent performance metrics and refine analytical methods used to monitor digital products.
· Present findings, risks, opportunities, and recommendations clearly to technical and business stakeholders.
· Manage multiple analytical workflows and priorities while following defined processes in a regulated environment.
Required Qualifications
· Bachelor’s degree.
· At least 2 years of professional data analysis experience.
· Prior utility industry experience and hands-on familiarity with AMI data and utility customer usage datasets.
· Understanding of how utility usage data is generated and used in customer-facing analytics and digital products.
· Hands-on Power BI experience creating dashboards, reports, and data visualizations.
· Demonstrated ability to analyze large, multi-source datasets and work independently with data extracts.
· Strong data validation, analytical, and problem-solving skills, with the ability to identify anomalies, inconsistencies, patterns, and trends.
· Strong attention to detail and ability to follow established processes in a regulated environment.
· Excellent written and verbal communication skills, with the ability to translate technical findings into practical business recommendations.
· Ability to collaborate with Product Owners, engineers, and business stakeholders while managing multiple priorities.
Preferred Qualifications
· Databricks experience.
· Experience with Customer Care & Billing (CC&B) data or tools.
· Google Analytics or other digital engagement analytics experience.
· Experience supporting customer-facing digital products, recurring reporting, and product performance measurement.