Role Description - Design, develop, and deploy Power BI dashboards and reports - Create and optimize data models, including relationships and calculated fields - Write and optimize DAX measures and calculated columns - Use Power Query (M language) for data transformation and cleansing - Integrate data from multiple sources (SQL Server, Excel, SharePoint, APIs, Azure, etc.) - Implement row-level security (RLS) and manage report access - Ensure performance optimization of reports and datasets - Collaborate with business users to gather requirements and deliver insights - Maintain documentation, data definitions, and best practices - Support data refresh schedules and troubleshoot reporting issues Company Description At Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. - At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus. - Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. - Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself. - We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. - We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. - All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.

• Design, build, and maintain BI reports and dashboards • Analyze business requirements and translate them into reporting solutions • Work with stakeholders to define KPIs, metrics, and data logic • Write and optimize SQL queries • Validate data accuracy and investigate inconsistencies • Support data modeling and reporting layer improvements • Collaborate with Data Engineers, Business Analysts, PMs, and customer-side stakeholders • Prepare documentation for reports, metrics, and data sources • Contribute to BI best practices within the unit

• Own and evolve the core business scorecards, dashboards, and ad-hoc analyses leaders use to monitor subscriber growth, revenue, billing health, retention, engagement, content performance, and monetization trends. • Translate ambiguous questions from stakeholders into structured analytical plans, clear findings, and actionable recommendations that inform real decisions. • Build deep expertise in Philo's billing and subscription ecosystem, including trials, conversion, renewals, churn, reactivation, plan migration, add-on attach, refunds, credits, failed payments, involuntary churn, and direct vs. partner billing flows. • Identify the operational and product levers that improve subscriber health, reduce friction, and strengthen revenue retention across the lifecycle. • Partner with Growth and Lifecycle Marketing on acquisition quality, funnel performance, cohort health, promotional effectiveness, winback programs, and LTV/CAC context. • Partner with Product, Design, and Data Science on customer journey analysis, feature adoption, experimentation readouts, and insight generation across the viewing and account experience. • Partner with Content, Programming, and Marketing to understand which channels, titles, and viewing patterns drive acquisition, engagement, retention, upsell, and free-to-paid conversion opportunities. • Support customer-facing and operational teams with insights into support contact drivers, account issues, billing friction, and subscriber pain points where analytical clarity can improve the customer experience. • Build executive-ready materials that connect numbers to narrative, synthesize tradeoffs, and help technical and non-technical stakeholders make decisions with confidence. • Improve the quality and trustworthiness of business data by partnering with analytics engineering and data engineering on instrumentation, metric governance, source-of-truth logic, and data quality issues. • Help raise the analytical bar across the organization through clear documentation, thoughtful prioritization, and a pragmatic balance of speed and rigor.

Role Description The Applications Development Senior Programmer Analyst is an intermediate level position responsible for participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to contribute to applications systems analysis and programming activities. - Conduct tasks related to feasibility studies, time and cost estimates, IT planning, risk technology, applications development, model development, and establish and implement new or revised applications systems and programs to meet specific business needs or user areas. - Monitor and control all phases of development process and analysis, design, construction, testing, and implementation as well as provide user and operational support on applications to business users. - Utilize in-depth specialty knowledge of applications development to analyze complex problems/issues, provide evaluation of business process, system process, and industry standards, and make evaluative judgement. - Recommend and develop security measures in post implementation analysis of business usage to ensure successful system design and functionality. - Consult with users/clients and other technology groups on issues, recommend advanced programming solutions, and install and assist customer exposure systems. - Ensure essential procedures are followed and help define operating standards and processes. - Serve as advisor or coach to new or lower level analysts. - Has the ability to operate with a limited level of direct supervision. - Can exercise independence of judgement and autonomy. - Acts as SME to senior stakeholders and/or other team members. - Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency. Qualifications - 5-8 years of relevant experience. - Experience in systems analysis and programming of software applications. - Experience in managing and implementing successful projects. - Working knowledge of consulting/project management techniques/methods. - Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements. Requirements - Bachelor’s degree/University degree or equivalent experience. Company Description Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law. If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi. View Citi’s EEO Policy Statement and the Know Your Rights poster.