Data Analytics Specialist - Digital Product Data Team

Job Info

Mar 25, 2024


Posting Expiration Date: May 31, 2024

Schedule Type: Full-Time

Minimum Salary: $80000

Maximum Salary: $100000

Organization: Customer Energy Solutions

Department: Digital Products&Demo Projects

Section: CES Digital Products

Location: NY-New York-4 Irving Pl Headquarters

Job Description

Mission Statement

  • Consolidated Edison Company of New York, Inc. (Con Edison), Orange & Rockland Utilities (O&R), and Consolidated Edison Transmission (CET) employees are required to follow health, safety, and environmental policies, EEO, Standards of Business Conduct, and all other applicable company policy and procedures. We all share a responsibility to advance the company’s mission by excelling at our three corporate priorities – safety of our people and the public, operational excellence in all that we do, and ensuring the best possible customer experience.

Core Responsibilities

  • Con Edison, a multibillion-dollar energy utility, is leading the clean energy transition in New York City and Westchester County. We are investing hundreds of millions of dollars annually to integrate distributed resources into our electric and gas systems, support electric vehicle charging infrastructure, and scale adoption of energy efficiency and clean heating technologies across our customers.
  • This is a great role to demonstrate your ability to drive results, demonstrate application of cross-disciplinary skills to the clean energy space and gain firsthand experience with the clean energy transition.
  • Collaborate with cross-functional teams to understand business needs and devise possible solutions.
  • Design and develop interactive, user-friendly Power BI dashboards and reports that accurately represent complex data sets. Ensure the integrity, accuracy, and security of data used in dashboards and reports.
  • Automate and streamline reporting processes to enhance business intelligence capabilities.
  • Participate in the design and implementation of MLOps workflows, ensuring seamless integration between development and deployment of machine learning models.
  • Contribute to the development of automated data preprocessing, feature engineering, training, and deployment processes using Azure Machine Learning pipelines and related services.
  • Use different machine learning models to increase and optimize customer experiences, revenue generation, ad targeting, and other business outcomes.
  • Mine and analyze data from company databases to drive optimization and improvement of product development, marketing techniques, and business strategies.
  • Coordinate with different functional teams to implement solutions and monitor outcomes.
  • Design, construct, and manage ETL data pipelines within the Azure Databricks environment.
  • Ensure the efficient extraction, transformation, and loading of data from various sources into Azure Data Lake or other designated storage solutions.

Required Education/Experience

  • Bachelor's Degree and a minimum of 2 years relevant experience.

Preferred Education/Experience

  • Master's Degree in Computer Science, Information Technology, Engineering, Math, Business, or applicable degree and 5 years related work experience in a system engineering/analysis area

Relevant Work Experience

  • Proficient in SQL Required
  • Proficient in Python Required
  • Deep understanding of Machine Learning algorithms and concepts Required
  • Experience in at least 1 machine learning projects (regression/ classification model). Required
  • Experience with building dashboards. Required
  • Experience with Cloud Computing Technologies. Preferred
  • Experience with Agile project management. Preferred
  • Familiarity with natural language processing (NLP) or Machine Learning Operations. Preferred
  • Experience with energy efficiency, demand-side management, electric vehicles, and/or other clean energy program from a utility or participating vendor perspective. Preferred
  • Familiar with New York State's Climate Leadership and Community Protection Act (CLCPA), Con Edison's rate case, New Efficiency New York, and/or other relevant clean energy regulations or proceedings. Preferred
  • Strong skills and experience with the MS Office suite: Word, Excel, PowerPoint, Visio, and Project. Preferred

Preferred Qualifications

  • Azure Databricks Data Scientist CertificateAzure Databricks Data Engineer Certificate

Skills & Ability

  • Excellent interpretation of complex statistical data
  • Demonstrated problem solving skills
  • Strong written and verbal communication skills
  • Excellent collaboration and team building skills
  • Possesses flexibility to work in a fast paced, dynamic environment

Licenses & Certifications

  • Driver's License Required

Other Physical Demands

  • Must be able to respond to Company emergencies by performing a System Emergency Assignment to restore service to our customers.

Technical Difficulty Statement

Equal Opportunity Employer

  • Consolidated Edison Company of New York, Inc. (Con Edison), Orange & Rockland Utilities (O&R), and Consolidated Edison Transmission (CET) are equal opportunity employers. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of the individual’s actual or perceived disability, protected veteran status, race, color, creed, religion, sex, age, national origin, gender, gender identity, gender expression, genetic information, marital status, sexual orientation, citizenship, domestic violence victim status, or any other actual or perceived status protected by law.