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

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.

• 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
• 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