Analyst, Commercial Analytics
Fluidra’s looking for an Analyst, Commercial Analytics to join our team in Carlsbad, CA.What You Will ContributeFluidra North America is the commercial force behind some of the most recognized brands in the pool and wellness industry. With a broad portfolio of premium equipment and a growing dealer network across North America, we compete at scale in a market that rewards speed, precision, and insight. Revenue Operations is the team that makes our commercial engine run smarter.Fluidra is in the middle of a meaningful analytics transformation: moving from a fragmented landscape of Excel-based reports and manual dashboards into a unified, scalable Power BI environment built to support a high-velocity commercial organization. This role exists because we need someone who can build it right - not just migrate files, but architect insight.You will be the analytics engine embedded within the Revenue Operations team - fluent in both Power BI and Excel, and sharp enough to know which tool serves the moment. You will decode market dynamics, surface the commercial signals that drive growth, and translate raw data into the clear, consumable insights that enable our sales teams to move faster and compete smarter.Working closely with the Revenue Insights Manager, you will own the migration from legacy reporting into a modern BI environment - while never losing sight of the ad hoc, fast-turn analytical work that keeps the commercial org running day to day.RoleThis is a role with real scope. The insights you produce will shape how Fluidra NAM reads the market, identifies growth leverage, and puts the right information in front of the right people at the right time. Additionally, you will:Sales Performance & Growth IntelligenceDig into sell-through trends, market dynamics, and territory performance to surface the signals that tell our sales leaders where growth is happening, where it's stalling, and where the opportunity is being left on the tableBuild white space analyses that identify cross-sell and upsell opportunity within our dealer and distributor base - translating account patterns into actionable growth targets for the fieldDevelop and maintain sales forecasting models and seasonal trend analyses in both Power BI and Excel - choosing the right tool for the question, not the most familiar oneTrack and communicate rep performance analytics: quota attainment, activity trends, and conversion patterns presented in formats that sales managers can act on immediatelyDistribution, Dealer & Channel AnalyticsMonitor dealer and distributor trends across the channel - sell-through velocity, portfolio mix, program participation, and loyalty indicators - to help commercial leaders understand how the network is performing and where it needs attentionBuild and maintain dealer scorecards and channel health dashboards in Power BI that give field teams and sales leadership a clear, current view of their account baseAnalyze distributor compliance with program terms, identify buying pattern anomalies, and surface risk signals before they become revenue problemsCommercial Program & Performance AnalyticsMeasure the effectiveness of dealer loyalty programs, promotional campaigns, and trade investments - going beyond spend tracking to answer whether the investment is actually changing behavior and driving incremental volumeAnalyze contract effectiveness and rebate performance, building the Excel models and Power BI reporting that track payout accuracy, program attainment, and ROI against design intentSupport compensation and customer rebate calculations with structured, auditable Excel models that Finance and Sales can trust and validate independentlyDeliver program performance summaries that go beyond the numbers - telling the story of what's working, what isn't, and what should change next cycleReporting Infrastructure & BI DevelopmentLead the migration of legacy Excel dashboards and reports into Power BI - rationalizing what gets migrated, what gets retired, and what stays in Excel because a dashboard isn't the right tool for the jobArchitect robust Power BI data models with optimized DAX measures and Power Query transformations that are built to scale, built to last, and built for someone else to maintainOwn the end-to-end publishing lifecycle: workspace governance, row-level security, refresh scheduling, and stakeholder distribution - the infrastructure that makes insights accessible to the right people at the right timeDocument data definitions, model logic, and report methodology so the analytics we produce carry institutional credibility, not just individual expertiseData Governance & EnablementOwn and manage the analytics request intake process - triaging incoming requests, setting realistic timelines, and maintaining a prioritized backlog so the team delivers the highest-impact work firstValidate data pipelines and reports before they reach leadership - performing user acceptance testing, cross-checking source data, and catching discrepancies before they become credibility problemsTrain commercial stakeholders on self-service report navigation so they can answer their own questions faster, reducing noise for the analytics team and building genuine data literacy across the orgFlag data quality issues upstream and serve as the commercial organization's advocate for clean, analytics-ready data - because the best analysis is only as good as the data underneath itWhat We SeekBusiness Intelligence - Power BI4+ years of hands-on Power BI development as your primary craft - not a secondary tool you reach for occasionallyDeep, production-tested DAX proficiency: CALCULATE, RANKX, time intelligence, virtual table functions - applied in real commercial reporting environments, not just tutorialsStrong Power Query / M code proficiency - you can build and debug multi-step transformations and know when to push logic to the source vs. handle it in the modelProven experience migrating Excel-based reports and dashboards into Power BI at an organizational level - not just individual filesWorkspace governance fluency: row-level security, workspace structure, refresh scheduling, naming standards, and publishing lifecycle ownershipAnalytical & Modeling - Excel + SQLAdvanced Excel proficiency as a distinct, relied-upon skill - dynamic arrays, XLOOKUP, complex nested formulas, Power Query in Excel, and financial/commercial modelingComfortable building clean, structured Excel models from scratch for pricing analysis, territory planning, promotional evaluation, and trend assessment - fast, reliable, and presentation-readyPower Pivot and Excel data modeling experience for scenarios where a full BI deployment is overkillSQL fluency sufficient to write, read, and optimize queries against a cloud data warehouse (e.g. Snowflake, Redshift, BigQuery, or equivalent)Commercial & InterpersonalCommercial curiosity: you ask why a metric matters before building the visual for it, and you push back when a request is solving the wrong problemAbility to communicate data clearly to non-technical commercial audiences, including VP and C-suite stakeholders - presenting findings, not just publishing reports.Stakeholder management and prioritization discipline - comfortable managing competing requests from Sales, Finance, Marketing, and field teams with clarity and without dramaExperience in a B2B environment with multi-channel distribution, commercial KPIs, or sales analyticsPreference Microsoft Certified: Data Analyst Associate (PL-300) or equivalent Power BI certification strongly preferred. VBA or macro experience for automating Excel-based workflowsExperience building forecasting or predictive models using statistical methods in Excel or Power BISalesforce data familiarity - pulling CRM pipeline and activity data into BI modelsExperience supporting a Revenue Operations, Commercial Excellence, or Sales Analytics functionEDUCATIONBachelor's degree in Business Analytics, Information Systems, Finance, or a related field - or equivalent demonstrated experienceWhat We OfferFluidra is not a company that talks about digital transformation - we are in the middle of it. You will join a Revenue Operations function that has executive sponsorship, a modern and growing data infrastructure, and a commercial team that genuinely wants to use data to compete better. This is a greenfield opportunity: the standards you set will define how Fluidra NAM measures commercial performance for years ahead.Fluidra offers competitive compensation, strong benefits, a culture built around accountability and innovation, and the scale of a global company with the agility of a performance-driven North American commercial team.Total Rewards Package That IncludesFlexible vacation9/80 work week schedule (EVERY OTHER FRIDAY OFF!) with subsequent Fridays WFH 11 paid HolidaysFull range of health benefits including medical, dental & vision, short & long-term disability401(K) matching (100% of first 3% contributed, 50% of the next 2%)Health and wellness programs / gym reimbursementOnsite gymEducational assistance up to $7,000 per yearOn-site self-service café / free gourmet coffee stations Company sponsored FUN events!Generous product discountsProfessional development and certification support (including Power BI / Microsoft certifications)Who We AreFluidra is a publicly listed company focused on developing innovative products, services and IoT solutions for the residential, commercial and wellness pool markets, globally. The company operates in over 45 countries, has over 7,000 employees and owns a portfolio of some of the industry’s most recognized and trusted brands: Polaris®, Jandy®, CMP, S.R. Smith, and Zodiac®. We also sell products under the Cover‐Pools®, iAquaLink®, Grand Effects®, Dell® and Nature2® names. With these combined resources we’re able accelerate innovation in critical areas like energy-efficiency, robotics and the Internet of Things.Our focus is on creating the perfect pool and wellness experience responsibly. We take our mission to heart, and our employees embody these guiding principles in everything we do: passion for success, honesty & trust, customer collaboration, teamwork and inclusion, learn and adapt, excellence and innovation.Don't meet every single requirement listed? At Fluidra, we thrive on building an inclusive workspace, so if you are excited about this role and your past experience doesn't align perfectly, we encourage you to apply anyways! You may be just the right candidate for this role or another role in the organization. Fluidra is proud to be an equal opportunity employer. Fluidra recruits, employs, trains, compensates and promotes regardless of race, religion, color, national origin, sex, disability, age, veteran status, or any legally protected characteristic.Expected salary range is $90,000 - $105,000. Fluidra offers a comprehensive total rewards / benefits program that includes base salary, annual bonus based on performance of individual and company objectives, competitive 401K matching, paid vacation and sick time, full range of health benefits, educational assistance, etc. The actual salary offer will carefully consider a wide range of factors, including skills, qualifications, experience and location. Your recruiter will provide additional details on our compensation and total rewards program.