[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.
Responsibilities
- Partner 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 tools
- Conduct 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 leadership
- Design, 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 warehouse
- Implement data quality checks and monitoring within the dbt framework to ensure the integrity and trust of our core business datasets
- Maintain clear and comprehensive documentation for all data models, metrics, and transformation logic
- Act as a subject matter expert for data and analytics, helping analysts and stakeholders use the trusted datasets effectively
- Effectively organize and manage projects to completion, driving towards timely and effective outcomes
Skills
- 4+ years of professional experience in a Data Analyst, BI Developer, or Analytics Engineer role
- Expert-level proficiency in writing complex, highly performant SQL queries, including window functions, CTEs, and various join types
- Proven, hands-on experience with dbt (data build tool) for data modeling, orchestration, and testing
- Advanced 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 field
Company Overview