Data Scientist, Consultant (Utilities)

Guidehouse; New York (NY); On-site; USD 89,000 - 148,000; Full time

Benefits offered by this job

Medical Insurance

Tuition Reimbursement

Parental Leave

401(k) Retirement Plan

Mobility Stipend

Job summary

Guidehouse seeks a Data Scientist, Consultant in New York, NY to turn client needs into scalable data products and dashboards. You will collaborate with utility teams to define objectives, select analytical methods, and deliver actionable recommendations throughout analytics projects.

You will present findings to both technical and non-technical stakeholders, driving data-driven decision making across engagements and ensuring impact across the client base.

Qualifications

• Bachelor’s degree in a related quantitative discipline.
• 1+ year of professional data analytics experience.
• Experience with Python, SQL, R, Databricks, Power BI, Tableau, GIS.
• Experience with large, complex datasets and end-to-end analytics.

Responsibilities

• Conduct data analysis and develop analytics solutions using Python, R, Snowflake, SQL, Databricks, Power BI, GIS.
• Partner with utility clients and subject matter experts to define objectives and recommendations.
• Design, build, test, and implement data, analytics, and AI-enabled solutions.
• Convert business needs into scalable data workflows, dashboards, and decision-support tools.
• Present findings to technical and non-technical audiences to support data-driven decisions.

Skills

Communication skills

Consulting skills

Problem solving

Education

Bachelor’s degree

Tools

Python

SQL

R

Databricks

Power BI

Tableau

GIS

Job description

Guidehouse is seeking a Data Scientist, Consultant to support utility clients with analytics and AI-enabled solutions. This onsite role in New York, NY focuses on turning client business needs into scalable data products, dashboards, and decision-support capabilities, with clear communication for both technical and non-technical stakeholders.

In this position, you will collaborate with utility teams and Guidehouse subject matter experts to define objectives, select analytical approaches, and deliver actionable recommendations. Work will include developing and implementing solutions end to end, from analysis and testing through deployment.

Responsibilities

• Conduct data analysis and develop analytical solutions using tools such as Python, R, Snowflake, SQL, Databricks, Power BI, GIS, and other modern analytics platforms to address client business challenges.
• Partner with utility clients and Guidehouse subject matter experts to establish business objectives, analytical methods, technical requirements, and recommendations.
• Design, build, test, and implement data, analytics, and AI-enabled solutions aligned to utility client priorities.
• Convert business needs into scalable analytical workflows, data products, dashboards, visualizations, and decision-support tools.
• Present findings and recommendations to technical and non-technical audiences to support confident, data-driven decision-making.

Requirements

• Bachelor’s degree in a related quantitative discipline (Data Science, Analytics, Statistics, Mathematics, Operations Research, Computer Science, Information Systems, Engineering, Economics, or similar).
• 1+ years of professional experience applying data analytics, business intelligence, data science, or related quantitative techniques to solve complex business problems.
• Experience with analytical and data management tools such as Python, SQL, R, Databricks, Power BI, Tableau, GIS, or comparable technologies.
• Experience working with large and complex datasets, delivering analytical solutions from concept through implementation.

Technologies

• Python
• R
• Snowflake
• SQL
• Databricks
• Power BI
• GIS
• Tableau

Benefits

• Medical, Rx, Dental & Vision Insurance
• Personal and Family Sick Time & Company Paid Holidays
• Position may be eligible for a discretionary variable incentive bonus
• Parental Leave and Adoption Assistance
• 401(k) Retirement Plan
• Basic Life & Supplemental Life
• Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts
• Short-Term & Long-Term Disability
• Student Loan PayDown
• Tuition Reimbursement, Personal Development & Learning Opportunities
• Skills Development & Certifications
• Employee Referral Program
• Corporate Sponsored Events & Community Outreach
• Emergency Back-Up Childcare Program
• Mobility Stipend

Travel, Clearance, and Nice to Have

• Travel required: Up to 10%
• Clearance required: None

• Experience supporting electric, gas, water, or other energy-sector organizations.
• Strong communication and consulting skills, including translating technical concepts into business insights and recommendations.
• Ability to manage multiple priorities while collaborating with clients, stakeholders, and multidisciplinary teams.
• Familiarity with utility business functions such as customer programs, DERs, electrification, asset management, and operations, regulatory planning.
• Experience with cloud-based analytics platforms, data engineering, AI, machine learning, geospatial analytics, or optimization techniques.
• Experience developing dashboards, data products, or decision-support applications for business users.
• Experience working in a consulting or client-facing environment.
• Master’s degree or relevant certifications in analytics, cloud technologies, or data engineering.

Compensation: USD 89,000 - 148,000 per yearly.