[Remote] Senior Data Analyst

Note: The job is a remote job and is open to candidates in USA. Nexcess provides specialty cloud solutions for organizations where performance and compliance have to coexist. They are seeking a highly skilled Senior Data Analyst to transform raw business data into actionable datasets that drive strategic decision-making and maintain the core logic used to calculate important KPIs and financial metrics.ResponsibilitiesPartner with business leaders (e.g., Finance, Sales, Product) to define, document, and standardize key financial and operational metrics and KPIs. Ensure these metrics are calculated consistently across all reporting toolsConduct deep-dive analyses using Excel and reporting tools (we use PowerBI, but tools like Looker, Tableau, or Sigma are just as relevant) to translate data trends into clear, actionable insights and recommendations for leadershipDesign, develop, and maintain robust data transformation pipelines using dbt (data build tool) and SQL to create accurate and easily consumable data models within our data warehouseImplement data quality checks and monitoring within the dbt framework to ensure the integrity and trust of our core business datasetsMaintain clear and comprehensive documentation for all data models, metrics, and transformation logicAct as a subject matter expert for data and analytics, helping analysts and stakeholders use the trusted datasets effectivelyEffectively organize and manage projects to completion, driving towards timely and effective outcomesSkills4+ years of professional experience in a Data Analyst, BI Developer, or Analytics Engineer roleExpert-level proficiency in writing complex, highly performant SQL queries, including window functions, CTEs, and various join typesProven, hands-on experience with dbt (data build tool) for data modeling, orchestration, and testingAdvanced proficiency in Microsoft Excel or Google Sheets for modeling, deep-dive analysis, forecasting, and presenting data (e.g., Pivot Tables, complex functions like INDEX/MATCH, array formulas)Strong understanding of core business and financial metrics, particularly those relevant to SaaS or recurring revenue models (e.g., ARR, MRR, Churn, LTV, CAC, Margin)Experience with a cloud data warehouse platform (e.g., Snowflake, Google BigQuery, Amazon Redshift)Familiarity with modern BI tools (e.g., Looker/LookML, Tableau, Power BI)Experience working with version control (Git)A degree in Computer Science, Finance, Economics, Statistics, or a related quantitative fieldCompany OverviewSpecialized cloud solutions for organizations in highly regulated, compliance-driven industries that prioritize performance & control. It was founded in 2000, and is headquartered in Lansing, Michigan, USA, with a workforce of 1001-5000 employees. Its website is https://www.nexcess.com/.