Analyst, Maps & Records

Posted 6 Days Ago
New York, NY, USA
In-Office
Junior
Energy
The Role
Provide analytical, technical, and administrative support to Gas Distribution Engineering: extract and analyze data with SQL and Python, build and maintain Power BI dashboards and reports, validate and reconcile data, document data sources and business rules, support data quality and process improvements, and collaborate with stakeholders. Travel within the service territory and participate in emergency response assignments.
Summary Generated by Built In

The Analyst will be responsible for providing analytical, technical, statistical and administrative support to the Gas Distribution Engineering Organization. The candidate must be capable of working independently as well as in teams and will be required to travel to various locations throughout the Con Edison service territory.

ResponsibilitiesCore Responsibilities
  • Interact with business and technical stakeholders across multiple organizations to understand data needs, and support reporting requirements.
  • Analyze data across multiple systems to identify trends, inconsistencies, and data quality issues, and provide recommendations to improve processes and data reliability.
  • Develop and maintain SQL queries to extract, validate, and analyze data across multiple data sources.
  • Develop, maintain, and optimize reporting solutions, including dashboards, queries, and data extracts, to support operational and strategic decision-making and monitor key performance metrics.
  • Develop and maintain Python-based processes to support data transformation, automation, validation, and analysis.
  • Perform data validation, reconciliation, and root cause analysis to resolve discrepancies and improve accuracy across enterprise systems.
  • Support process improvement initiatives, including monitoring data quality, documenting business rules, and improving consistency and usability of reporting outputs.
  • Assist in developing and maintaining data quality metrics, scoring frameworks, and reporting standards to measure and track performance.
  • Maintain documentation related to data sources, workflows, reporting logic, business rules.
  • Proactively identify opportunities to improve data quality, reporting processes, and overall data usability across the organization.
  • Work independently and collaboratively to manage multiple priorities, demonstrate initiative, and contribute to team and organizational goals.
  • Perform other related analytical and administrative tasks as required.
QualificationsRequired Education/Experience
  • Bachelor's Degree and 2 years of work experience in operations, IT, data analytics, or related experience, or
  • Associate's Degree and 4 years of work experience in IT, data analytics, operations, or related experience, or
  • High School Diploma/GED and 5 years of work experience in IT, data analytics, operations, or related experience.
Preferred Education/Experience
  • Bachelor's Degree and 2 years of relevant work experience in operations, IT, data analytics, or related experience.
Relevant Work Experience
  • Experience in data analytics, data governance, database management, or a related field, required.
  • Strong SQL skills, including the ability to develop, optimize, and troubleshoot complex queries for data extraction and analysis, required.
  • Experience developing and maintaining dashboards using Power BI or similar enterprise reporting tools, required.
  • Experience with Python or similar tools to support data transformation, automation, validation, and analysis, required.
  • Strong understanding of upstream and downstream data flows and the ability to analyze data across interconnected systems, required.
  • Strong analytical, organizational, and problem-solving skills with a high level of attention to detail and commitment to data accuracy, required.
  • Ability to work independently, manage multiple priorities, and adapt to evolving business and data requirements, required.
  • Demonstrated ability to gather, interpret, and translate business requirements into technical solutions and reporting outputs, required.
  • Demonstrated curiosity, initiative and willingness to learn new technologies, systems, and business processes, preferred.
Skills and Abilities
  • Strong written and verbal communication skills
  • Demonstrated analytical skills
  • Demonstrates a high level of accuracy, even under pressure
  • Excellent organizational skills
  • Performs work independently with minimal supervision
  • Must be proficient in Microsoft Office including Word, Excel, Outlook and PowerPoint, etc.
Licenses and Certifications
  • Driver's License Required
Physical Demands
  • Sit or stand to answer a phone for the duration of the workday
  • Sit or stand to use a keyboard, mouse, and computer for the duration of the workday
Additional Physical Demands
  • The selected candidate will be assigned a System Emergency Assignment (i.e., an emergency response role) and will be expected to work non-business hours during emergencies, which may include nights, weekends, and holidays.
About Us

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.


Benefits:


We are dedicated to supporting the physical, mental, and financial health of our employees and their families. This commitment extends beyond the workplace to foster personal growth and holistic wellbeing. Our life-changing rewards package includes:


  • Rich medical & pharmacy benefits, including vision benefits
  • Dental benefits
  • Health Savings Accounts
  • Health Care and Dependent Care Flexible Spending Accounts
  • 401(k) with robust matching
  • Employer paid Pension Plan
  • Employee Stock Purchase Plan with a generous matching contribution
  • State of the art Employee Assistance Program
  • Paid Parental Leave
  • Generous paid time off plus paid holidays
  • Family support: emergency backup child, & elder care assistance
  • Social responsibility and volunteer opportunities
  • Employee discount program
  • Commuter Benefits
  • Culture of growth and learning: career development; tuition reimbursement; recognition program
  • Life and Long-Term Disability Benefits


*Please be aware that some benefits may not apply to provisional or part-time job titles.

About the Team

EEO Statement:

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.

 

Technical Difficulty Statement:

For technical issues, please contact us at [email protected]


Skills Required

  • Bachelor's Degree and 2 years' experience in operations, IT, data analytics, or related OR Associate's Degree and 4 years OR High School Diploma/GED and 5 years
  • Experience in data analytics, data governance, or database management
  • Strong SQL skills (develop, optimize, troubleshoot complex queries)
  • Experience developing and maintaining dashboards using Power BI or similar tools
  • Experience with Python for data transformation, automation, validation, and analysis
  • Strong understanding of upstream and downstream data flows across systems
  • Strong analytical, organizational, and problem-solving skills with high attention to data accuracy
  • Ability to work independently, manage multiple priorities, and adapt to evolving requirements
  • Ability to gather, interpret, and translate business requirements into technical reporting solutions
  • Proficiency with Microsoft Office (Word, Excel, Outlook, PowerPoint)
  • Driver's license
  • Willingness/ability to travel within Con Edison service territory
  • Assigned to System Emergency Assignment—work non-business hours during emergencies (nights, weekends, holidays)
  • Demonstrated curiosity, initiative, and willingness to learn new technologies, systems, and processes
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: New York, NY
7,742 Employees

What We Do

We provide power to more than 10 million people and businesses across NYC and Westchester. Reliability and accessibility are central to what we do and how we provide energy service. Leading the industry to power tomorrow is our other focus- we are committed to aggressively transitioning away from fossil fuels to a net-zero economy by 2050. To help achieve this we collaborate with customers, regulators, policymakers, engineers, and other stakeholders to ensure our clean energy future is informed by principles of affordability, equity, and environmental justice. We’re also heavily investing in new technologies and the infrastructure that can get us there. What are a few things we have achieved so far? • Since 2009, our energy efficiency programs have prevented 11 million metric tons of carbon emissions – the same amount it would take to power 1.4 million homes for a year • We’re currently the second largest producer of solar energy in North America • Recently, we’ve embarked on an 8-year project to make our systems more resilient in the face of extreme weather events

Similar Jobs

Navan Logo Navan

Senior Manager, Business Operations, Specialty Travel & Events

Fintech • Information Technology • Payments • Productivity • Software • Travel • Automation
Easy Apply
Hybrid
New York, NY, USA
3300 Employees
81K-180K Annually

BlackRock Logo BlackRock

Quantitative Researcher

Fintech • Information Technology • Financial Services
In-Office
New York, NY, USA
25000 Employees
133K-162K Annually

Comcast Logo Comcast

Sr. Director-Technology, Platforms, and Gaming

Digital Media • Information Technology • News + Entertainment
Hybrid
New York, NY, USA
115000 Employees
147K-293K Annually
Hybrid
New York, NY, USA
289097 Employees

Similar Companies Hiring

UL Solutions Thumbnail
Automotive • Professional Services • Software • Consulting • Energy • Chemical • Renewable Energy
Chicago, IL
15000 Employees
Runwise Thumbnail
Greentech • Hardware • Real Estate • Software • Energy • PropTech
New York, NY
199 Employees
Energy CX Thumbnail
Greentech • Professional Services • Business Intelligence • Consulting • Energy • Financial Services • Utilities
Chicago, IL
108 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account