Senior Data Analyst - Corporate Intelligence Platform
Epsilon · Chicago, IL · Today
HybridInformation Technology$89k/yrFull-time
Overview Company Description 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. Responsibilities 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. Qualifications 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 (Databricks or similar required) and a solid understanding of data warehouse/lake concepts (familiarity with Lakehouse/Delta Lake, medallion architectures). You may have some experience with Python or data visualization tools, and you’re always eager to learn new technologies (including using AI tools to accelerate data analysis).Detail-Oriented & Quality-Focused: You are obsessed with data accuracy and consistency. You have experience setting up data quality checks, verifying results against source systems, and ensuring that dashboards are error-free. You understand the importance of data governance, and you naturally document your work so others can trust and build upon it.Metrics & Business Savvy: You understand business metrics and can engage with business partners to refine them. You excel at asking the right questions to ensure a metric truly reflects business reality. Your analytical skills help you connect the dots between data points and business outcomes, so you can support collaborators in interpreting results and finding opportunities or issues.Collaborative & Communicative: You work best in a team environment, closely partnering with data engineers, product managers, and other analysts. You can communicate complex data findings in simple terms, helping non-technical colleagues understand what the numbers mean and why they matter. Education: Bachelor’s degree in a quantitative field (Statistics, Computer Science, Data Analytics, Finance, etc.) or equivalent experience. Professional certifications or training in data analysis/BI (e.g., data analytics certifications) are a plus. Click here to view how Epsilon transforms marketing with 1 View, 1 Vision, 1 Voice. Additional Information When You Join Us, We’ll Create Something EPIC Together Epsilon is a global data, technology and services company that powers the marketing and advertising ecosystem. For decades, we’ve provided marketers from the world’s leading brands the data, technology and services they need to engage consumers with 1 View, 1 Vision and 1 Voice. 1 View of their universe of potential buyers. 1 Vision for engaging each individual. And 1 Voice to harmonize engagement across paid, owned and earned channels. Epsilon’s comprehensive portfolio of capabilities across our suite of digital media, messaging and loyalty solutions bridge the divide between marketing and advertising technology. We process 400+ billion consumer actions each day using advanced AI and hold many patents of proprietary technology, including real-time modeling languages and consumer privacy advancements. Thanks to the work of every employee, Epsilon has been consistently recognized as industry-leading by Forrester, Adweek and the MRC. Epsilon is a global company with more than 9,000 employees around the world. Our pillars aren't just words. They're how we show up every day. People centricity: We focus on employee well-being in an environment where colleagues truly care about each other.Collaboration: We work together, support one another, and collectively achieve goals.Growth: There are endless opportunities for growth through learning, development and career advancement.Innovation: We drive progress through cutting-edge solutions and forward-thinking approaches.Flexibility: We’ve created a balance between work and personal life, and we encourage adaptability to solve problems creatively. Our values guide us to create value for our clients, our people and consumers. Act with integrityWork together to win togetherInnovate with purposeRespect all voicesEmpower with accountability These pillars and values are our foundation—shaping our culture, guiding our decisions, and uniting us in common purpose. Because You Matter Benefits As an Epsilon employee, you deserve perks and benefits that put you, your family and your finances first. Our benefits encompass a wide range of offerings, including but not limited to the following: Time to Recharge: Flexible time off (FTO), 15 paid holidaysTime to Recover: Paid sick time Family Well-Being: Parental/new child leave, childcare & elder care assistance, adoption assistance Extra Perks: Comprehensive health coverage, 401(k), tuition assistance, commuter benefits, professional development, employee recognition, charitable donation matching, health coaching and counseling Epsilon benefits are subject to eligibility requirements and other terms. Epsilon is an Equal Opportunity Employer. Epsilon’s policy is not to discriminate against any applicant or employee based on actual or perceived race, age, sex or gender (including pregnancy), marital status, national origin, ancestry, citizenship status, mental or physical disability, religion, creed, color, sexual orientation, gender identity or expression (including transgender status), veteran status, genetic information, or any other characteristic protected by applicable federal, state or local law. Epsilon also prohibits harassment of applicants and employees based on any of these protected categories. Epsilon will provide accommodations to applicants needing accommodations to complete the application process. Please reach out to LeaveofAbsence@epsilon.com to request an accommodation. For San Francisco Bay and Los Angeles Areas: Epsilon will consider for employment qualified applicants with criminal histories in a manner consistent with the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance and San Francisco Police Code Sections 4901-4919, commonly referred to as the San Francisco Fair Chance Ordinance. Applicants with criminal histories are welcome to apply. Compensation Range: USD $88,900.00 - USD $165,100.00/Annually. This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. Temporary roles may be eligible to participate in our freelancer/temporary employee medical plan through a third-party benefits administration system once certain criteria have been met. Temporary roles may also qualify for participation in our 401(k) plan after eligibility criteria have been met. For regular roles, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off. The Company anticipates the application deadline for this job posting will be 9/3/2026.