Analyst, Maps & Records
About The Position
The Analyst provides analytical, technical, statistical, and administrative support to the Gas Distribution Engineering Organization. The role works with business and technical stakeholders to understand data needs and support reporting, analyzing data across systems, maintaining SQL and Python processes, and developing reporting solutions that support operational and strategic decision-making. The candidate must be able to work independently and collaboratively and must travel to various locations throughout the Con Edison service territory. The position also supports data validation, reconciliation, root cause analysis, and process improvement; maintains documentation of data sources, workflows, reporting logic, and business rules; and helps develop data quality metrics and reporting standards. The selected candidate will have a System Emergency Assignment and may be expected to work nights, weekends, or holidays during emergencies.
Requirements
- Bachelor's degree and 2 years of work experience in operations, IT, data analytics, or a related area; or an associate's degree and 4 years of relevant work experience; or a high school diploma/GED and 5 years of relevant work experience.
- Experience in data analytics, data governance, database management, or a related field.
- Strong SQL skills, including developing, optimizing, and troubleshooting complex queries for data extraction and analysis.
- Experience developing and maintaining dashboards using Power BI or similar enterprise reporting tools.
- Experience with Python or similar tools for data transformation, automation, validation, and analysis.
- Strong understanding of upstream and downstream data flows and ability to analyze data across interconnected systems.
- Strong analytical, organizational, and problem-solving skills; attention to detail and commitment to data accuracy.
- Ability to work independently, manage multiple priorities, and adapt to evolving business and data requirements.
- Ability to gather, interpret, and translate business requirements into technical solutions and reporting outputs.
- Strong written and verbal communication skills.
- Demonstrated analytical skills and a high level of accuracy, including under pressure.
- Excellent organizational skills and ability to work independently with minimal supervision.
- Proficiency in Microsoft Office, including Word, Excel, Outlook, and PowerPoint.
- Valid driver's license required.
Nice To Haves
- Bachelor's degree and 2 years of relevant work experience in operations, IT, data analytics, or a related area.
- Curiosity, initiative, and willingness to learn new technologies, systems, and business processes.
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 recommend improvements to processes and data reliability.
- Develop and maintain SQL queries to extract, validate, and analyze data from multiple sources.
- Develop, maintain, and optimize dashboards, queries, and data extracts to support operational and strategic decisions and monitor key performance metrics.
- Develop and maintain Python-based processes for 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, monitor data quality, document business rules, and improve reporting consistency and usability.
- Assist in developing and maintaining data quality metrics, scoring frameworks, and reporting standards.
- Maintain documentation related to data sources, workflows, reporting logic, and business rules.
- Identify opportunities to improve data quality, reporting processes, and data usability.
- Manage multiple priorities independently and collaboratively, demonstrate initiative, and contribute to team and organizational goals.
- Perform other related analytical and administrative tasks as required.
- Travel to various locations throughout the Con Edison service territory.
- Work non-business hours during emergencies, potentially including nights, weekends, and holidays.
Benefits
- Medical and pharmacy benefits, including vision benefits
- Dental benefits
- Health Savings Accounts
- Health Care and Dependent Care Flexible Spending Accounts
- 401(k) with matching
- Employer-paid pension plan
- Employee Stock Purchase Plan with matching contribution
- Employee Assistance Program
- Paid parental leave
- Paid time off and paid holidays
- Emergency backup child and elder care assistance
- Social responsibility and volunteer opportunities
- Employee discount program
- Commuter benefits
- Career development and learning opportunities
- Tuition reimbursement
- Recognition program
- Life and long-term disability benefits
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
