Senior Data Analyst - Corporate Intelligence Platform

Company Description Overview

As a Senior Data Analyst on the Corporate Intelligence Platform team, you will be the analytic engine and data steward ensuring CIP’s outputs are accurate, reliable, and meaningful. This role is all about making our data sing - you will dive deep into enterprise source systems (HR, Finance, project tracking, etc.) to understand and document data, then shape it into trusted analytical datasets and dashboards that drive executive decisions.

By painstakingly validating data quality, defining core metrics, and building intuitive dashboard views, you’ll transform raw data into insights that Epsilon’s leaders rely on. Your work will bridge the gap between data engineering and business teams, ensuring that CIP not only centralizes data but also delivers answers to key business questions with confidence and clarity.

• Source Data Mastery: Become the subject-matter expert on CIP’s source data. Work with IT and system owners to map out all relevant fields and data flows from our internal systems (e.g., HRIS, financial databases, project management tools) into the CIP environment. Document data definitions, schemas, and business logic, making sure the team and end-users understand the context and limitations of each data source.
  
  Identify any data gaps or integrity issues early and recommend solutions or workarounds.
• Refined Data Products & Metrics: Collaborate with data engineers and the product manager to transform raw data into business-ready "Silver" and "Gold" layer datasets. Validate that data cleansing and transformation rules produce accurate results. Help design dimensional data models and aggregated views that support common analytics needs (for example, workforce cost by product/initiative, project delivery timelines, or revenue by product). Ensure each curated dataset has clear business context, defined metrics, and documentation so that it’s immediately useful and trustworthy for analysis.
• Metrics Definition & Consistency: Define and maintain the catalog of key business metrics and KPIs within CIP. Work with partners in Finance, Product, and Operations to agree on a single definition for critical measures (e.g., "fully-loaded cost", "utilization rate", "bookings vs revenue") and implement these calculations in CIP’s data models. Create and manage a semantic layer or metrics repository that ensures all reports and dashboards use consistent formulas.
  
  By driving this consistency and clarity, you’ll prevent divergent numbers and solidify CIP’s reputation as the single source of truth for internal analytics.
• Data Quality & Validation: Establish rigorous data quality checks to catch issues like missing data, inconsistencies, or anomalies. Regularly reconcile CIP’s aggregated results with source system records (e.g., compare CIP’s finance totals with official finance system outputs) to ensure everything lines up. Investigate discrepancies to find root causes – whether a pipeline issue, data entry error, or definition mismatch – and work with data engineers to implement fixes.
  
  You will also monitor data freshness and reliability, giving partners confidence that CIP’s insights are accurate and up-to-date.
• Analytics & Dashboard Development: Design and deliver insightful analytics and dashboards on top of CIP’s datasets. Use your data exploration skills (e.g., advanced SQL in Databricks SQL/GenAI tools) to answer ad-hoc executive questions and to shape the content of dashboards. For example, you might build a dashboard that highlights key product investment metrics or perform analyses to support long-term planning discussions.

• Analytical Expert: You have 5+ years of experience as a data analyst, business intelligence analyst, or similar role, working with large-scale data sets and complex business metrics. You have a strong track record of turning data into insights used by business teams, and you’re excited by the challenge of making sense of diverse internal data.
• SQL & Data Proficiency: You are a SQL expert – comfortable writing advanced queries to join, aggregate, and analyze data. You have hands‑on experience with modern data platforms…