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

Role Description Join Ferguson’s Decision Support Center (DSC) and help shape how we deliver data-driven insights and process improvements across the enterprise. This role will focus on designing advanced data solutions, building impactful analytics, and driving operational efficiency through insightful reporting. - Design, develop, and deploy advanced Power BI dashboards, reports, and scorecards with high business impact. - Write and optimize complex SQL queries to extract, transform, and prepare data from different sources for analysis. - Integrate data from various sources, including Azure Synapse, SharePoint, SQL databases, and Databricks to power analytics solutions. - Collaborate with business partners to gather and understand data needs, particularly in operational contexts. - Apply advanced DAX to create dynamic calculations, critical metrics, and measures within Power BI. - Serve as a key partner in business analysis to translate operational needs into technical reporting solutions. - Proactively find opportunities to streamline processes and improve data visibility for Field Purchasing and other key business units. - Provide technical guidance and mentorship to junior developers and share knowledge across the team. - Manage multiple project timelines and priorities independently, ensuring alignment with business objectives. - Communicate clearly with both technical teams and non-technical partners to ensure alignment and clarity. - Apply Lean thinking principles to identify inefficiencies and propose practical, data-informed improvements. - Troubleshoot and performance-tune Power BI solutions for scalability and responsiveness. - Leverage AI and machine learning capabilities to enhance analytics solutions, including: - Integrating predictive models and forecasting into reporting. - Using AI-assisted tools to accelerate development and improve code quality (e.g., Copilot, automated code generation). - Identifying opportunities to embed AI-driven insights directly into dashboards and business workflows. Qualifications - Bachelor’s degree in Business Administration, Computer Science, Information Technology, or a related field; or equivalent experience preferred. - 6+ years of hands-on experience developing and deploying Power BI solutions with deep knowledge of DAX and SQL. - Solid background in working with operational data and a preference for candidates who have supported Field Purchasing teams or functions. - Experience with data integration across multiple sources including cloud-based databases. - Demonstrated ability to solve problems independently and creatively in complex data environments. - Strong project and time management skills, with the ability to balance multiple priorities in a fast-paced setting. - Excellent communication and interpersonal skills, with comfort interacting across business and technical teams. - Leverage artificial intelligence (AI) capabilities to enhance analytics solutions, including: - Integrating predictive models and forecasting into reporting. - Using AI-assisted tools to accelerate development and improve code quality (e.g., Copilot, Gemini, automated code generation). - Finding opportunities to embed AI-driven insights directly into dashboards and business workflows. - Familiarity with Lean or continuous improvement methodologies is highly desirable. - Self-starter with a passion for continuous learning and a focus on delivering real-world results. Benefits - Health, dental, and vision insurance. - Paid time off. - Life insurance. - 401(k) with a company match. - Mental health coverage. - Gender affirming and family building benefits. - Paid parental leave. - Associate discounts. - Community involvement opportunities. Pay Range Actual pay rate may vary depending upon location. The estimated pay range for this position is below. The specific rate will depend on a candidate’s qualifications and prior experience. - $6,000.30 - $13,016.30 (Estimated Ranges displayed are Monthly for Salaried roles or Hourly for all other roles). - This role is Bonus or Incentive Plan eligible. - The Company complies with all wage regulations. The starting wage may be higher in certain locations based on local or state wage requirements. Equal Employment Opportunity The Company is an equal opportunity employer as well as a government contractor that shall abide by the requirements of 41 CFR 60-300.5(a), which prohibits discrimination against qualified protected Veterans and the requirements of 41 CFR 60-741.5(A), which prohibits discrimination against qualified individuals on the basis of disability. Ferguson Enterprises, LLC. is an equal employment employer F/M/Disability/Vet/Sexual Orientation/Gender Identity.