Sr System Analyst - Data Activation Engineer, Enterprise Data & Analytics

Consolidated Edison Company of New York; New York (NY); On-site; USD 120,000 - 160,000; Full time

Job summary

Consolidated Edison Company of New York is seeking a Sr System Analyst, Data Activation Engineer within Enterprise Data & Analytics to design and build data integration pipelines that connect source systems to analytics platforms like Google Cloud Platform.

You will own data contracts, schemas, and validation, ensure data quality end-to-end, and implement monitoring and observability across interfaces. This role partners with solution engineers and business SMEs to deliver trusted data.

Qualifications

• 2+ years experience with a Master's or 3+ with a Bachelor's in a relevant field.
• Hands-on data integration pipeline design across batch, streaming, API, CDC.
• Strong data contracts, schema design, and technical specs.

Responsibilities

• Design and build data pipelines from source systems to analytics platforms.
• Define and maintain data contracts for schema, frequency, quality, ownership.
• Produce interface designs with mappings, logic, and field specs.
• Evaluate data sensitivity and apply appropriate controls.
• Select patterns (batch/streaming/API/CDC) per use case.
• Collaborate with engineers and SMEs to translate requirements into plans.
• Validate end-to-end data integrity with checks and reconciliations.
• Incorporate monitoring/observability for freshness and schema drift.
• Troubleshoot pipeline issues and lead root-cause analysis.
• Document interfaces, lineage, and runbooks for supportability.

Skills

Communication skills

Time management

Problem solving

Multi-project delivery

Detail oriented

Education

Master's Degree in CS/Engineering/Math/Business

Bachelor's Degree in CS/Engineering/Math/Business

Tools

Azure Data Factory

SSIS

Google Cloud data tools (Dataflow/Dataform/Data Transfer Service/gcloud)

Databricks

Job description

Overview

The Sr System Analyst, Data Activation Engineer, Enterprise Data & Analytics is responsible for building the data integration pipelines and data contracts that connect our target analytics platforms (primarily Google Cloud Platform, other supported platforms are C3.ai, and Azure Databricks) to source systems and middleware. The role owns the functional and technical design of these interfaces, including identifying required tables and columns, validating data sensitivity and handling requirements, and selecting the right integration methodology based on platform capabilities. Data integrity is a core deliverable, not an afterthought, and the engineer is accountable for it across every stage of the pipeline.

This is a collaborative role. The engineer partners closely with solution engineers, source system owners, and business subject matter experts to confirm data needs and shape use case delivery. They also design and implement the monitoring and observability layers on each interface, making sure data arrives intact, complete, and on time end to end. Success in this role means dependable pipelines, clear contracts between systems, and analytics consumers who can trust the data theyre working with.

This position does not provide employment pursuant to the terms of a STEM OPT Training Plan.

Responsibilities

Core Responsibilities

• Design and build data integration pipelines that move data reliably from source systems and middleware into the target analytics platform (primarily Google Cloud Platform; other platforms are Azure Databricks & C3.ai)
• Define and maintain data contracts that set clear expectations for schema, frequency, quality, and ownership between producers and consumers
• Produce functional and technical interface designs, including source-to-target mappings, transformation logic, and field-level specifications
• Evaluate data sensitivity and classification requirements, applying the right controls for protected, confidential, or regulated data
• Select integration patterns and methodologies (batch, streaming, API-based, CDC, etc.) that fit the use case and align with supported platform capabilities
• Partner with solution engineers, source system owners, and business SMEs to translate use case requirements into concrete data delivery plans
• Validate data integrity end to end through reconciliation checks, row counts, checksums, and other verification techniques
• Build monitoring and observability into every interface, with alerting on freshness, completeness, schema drift, and failure conditions
• Troubleshoot pipeline issues and lead root cause analysis when data arrives late, incomplete, or malformed
• Document interfaces, lineage, and operational runbooks so that pipelines remain supportable and auditable over time

Qualifications

Required Education/Experience

• Master's Degree in Computer Science, Engineering, Math, Business, or technology-centric field and a minimum of 2 years relevant full time work experience or
• Bachelor's Degree in Computer Science, Engineering, Math, Business, or technology-centric field and a minimum of 3 years relevant full-time work experience

Relevant Work Experience

• Hands-on experience designing and building data integration pipelines across batch, streaming, API, and change data capture patterns, with one or more of: Azure Data Factory, SSIS, Google Cloud data integration services (Dataflow, Dataform, Data Transfer Service, gcloud CLI), or comparable tooling, required
• Strong background in source to target mapping, schema design, and writing technical specifications that engineers and analysts can both work from, required
• Working knowledge of modern data platforms and integration tooling, with the judgment to match the right pattern to the right use case, required
• Track record of partnering across solution engineers, source system owners, and business SMEs to turn fuzzy requirements into reliable, production-grade data delivery, required
• Practical understanding of data sensitivity, classification, and handling requirements, including how to apply controls for protected or regulated data, preferred
• Experience defining and operationalizing data contracts, including schema versioning, ownership boundaries, and quality expectations between teams, preferred
• Proven ability to implement monitoring and observability on data pipelines, covering freshness, completeness, schema drift, and failure alerting, preferred

Skills and Abilities

• Strong written and verbal communication skills
• Possesses flexibility to work in a fast paced, dynamic environment
• Ability to work within tight timeframes and meet strict deadlines
• Demonstrated problem solving skills
• Effective interpersonal skills
• Ability to drive multiple projects to successful completion
• Demonstrated time management and priority setting skills
• Ability to drive multiple projects to successful completion
• Well organized, detail oriented and flexible to handle multiple assignments

Licenses and Certifications

• Driver's License Required
• Other: Technical certification(s) in IT Preferred
• Other: Google Professional Data Engineer Preferred
• Other: Google Associate Data Practitioner Preferred
• Other: Databricks Associate Data Engineer Preferred
• Other: Databricks Professional Data Engineer Preferred

Physical Demands

• 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.
• Available to work off hours as operationally required