Senior Data Analyst

Nexcess

$90K — $100K *
US-AnywhereRemote in United States
Enterprise Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 4+ years experience in Data Analyst, BI Developer, or Analytics Engineer roles.
  • Expert-level SQL skills for advanced query writing and performance optimization.
  • Hands-on experience with dbt for data modeling and orchestration.
  • Advanced proficiency in Excel or Google Sheets for data analysis and modeling.
  • Strong business understanding of SaaS metrics such as ARR, MRR, and Churn.

Responsibilities

  • Define and standardize financial and operational KPIs in collaboration with business leaders.
  • Conduct in-depth analyses to translate data trends into actionable insights for leadership.
  • Design and maintain data transformation pipelines using dbt and SQL.
  • Implement quality checks to ensure data integrity within datasets.
  • Document all data models and transformation logic comprehensively.
  • Support analysts by acting as a subject matter expert on data usage and analytics.
  • Organize and manage projects effectively to drive timely outcomes.

Benefits

  • Flexible remote work arrangements.
  • Access to advanced analytical tools and technologies.
  • Opportunity to work closely with various business stakeholders.
  • Career growth potential within a dynamic team.
  • Engagement in challenging and impactful projects.
Full Job Description
About The Role
We are seeking a highly skilled Senior Data Analyst (with a strong background in Analytics Engineering principles) to join our growing Performance Management team. This critical role will be instrumental in transforming raw business data into trusted, organized, and actionable datasets that drive strategic decision-making.

You will be the vital link between our business stakeholders and our data warehouse, responsible for designing, building, and maintaining the core logic used to calculate our most important Key Performance Indicators (KPIs) and financial metrics. The ideal candidate will be equally comfortable performing deep-dive analysis in Excel and modeling complex data structures using dbt and SQL.

Compensation: The base salary for this role is between $90k-$100k

Responsibilities:

  • KPI Development:
    • 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.
  • Business Analysis:
    • 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.
  • Data Modeling & Transformation:
    • 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.
  • Data Reliability:
    • Implement data quality checks and monitoring within the dbt framework to ensure the integrity and trust of our core business datasets.
  • Documentation:
    • Maintain clear and comprehensive documentation for all data models, metrics, and transformation logic.
  • Cross-Functional Support:
    • Act as a subject matter expert for data and analytics, helping analysts and stakeholders use the trusted datasets effectively.
  • Project Management:
    • Effectively organize and manage projects to completion, driving towards timely and effective outcomes


Skills, Competencies, and Qualifications:

  • Experience: 4+ years of professional experience in a Data Analyst, BI Developer, or Analytics Engineer role.
  • SQL Mastery: Expert-level proficiency in writing complex, highly performant SQL queries, including window functions, CTEs, and various join types.
  • Analytics Engineering Tooling: Proven, hands-on experience with dbt (data build tool) for data modeling, orchestration, and testing.
  • Spreadsheet Fluency: 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).
  • Business Acumen: 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).


Preferred Qualifications:

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


Physical Requirements and Work Environment:

The physical demands described here are representative of those that must be met by an individual to successfully perform the essential duties of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential duties.

  • While performing the essential duties of this job, the individual is regularly required to speak and hear
  • While performing the essential duties of this job, the individual is regularly required to use hands for keyboarding, gross manipulation, and fine manipulation
  • The individual frequently is required to stand and walk
  • Works at a desk and computer screen for extended periods of time
  • Works in a traditional climate controlled office environment or from home
  • Works in a highly stressful environment dealing with a wide variety of challenges, deadlines and diverse employee population


Disclaimer:

This job description is only a summary of the typical functions of the position. It is not intended to be an exhaustive or comprehensive list of all job responsibilities, tasks, or duties. Additional duties and tasks may be assigned as part of the job function. Liquid Web Inc. reserves the right to modify, interpret, or apply this job description in a way that best supports the organizational needs. The job description in no way creates or implies an employment contract. The employment contract remains "at will".

#LI-REMOTE

Similar Jobs

More Jobs at Nexcess

More Enterprise Technology Jobs

Find similar Senior Data Analyst jobs: