Senior Data Analyst
Nexcess · United States
- Hybrid
- Full-time
- $100,000 / year
- United States
Tailored resume — keyword-matched to this role.
Hiring manager — we find who's hiring.
Intro email — drafted to reach them directly.
Job highlights
- Analyze and transform business data into actionable datasets.
- Design and build core logic for KPIs and financial metrics.
- Utilize dbt and SQL for data modeling and transformation.
- Conduct deep-dive analysis using Excel and BI tools.
- Ensure data integrity through quality checks and documentation.
About the role
About Nexcess
Nexcess provides specialty cloud solutions for organizations where performance and compliance have to coexist. We serve businesses worldwide, from agencies scaling client sites to enterprises running mission-critical operations. We've built our reputation on deep technical expertise and genuine partnership with every client we work with. Behind every environment we manage is a team of people who take the craft seriously and keep showing up when it matters.
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.
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.
Key skills/competency
- Senior Data Analyst
- SQL
- dbt
- Data Modeling
- Business Analysis
- KPI Development
- Excel
- Data Transformation
- Cloud Data Warehouse
- BI Tools
Skills & topics
- Senior Data Analyst
- Data Analysis
- Analytics Engineering
- SQL
- dbt
- Data Modeling
- KPI Development
- Business Intelligence
- SaaS
- Cloud Solutions
How to get hired
- Tailor your resume: Highlight your 4+ years of experience, SQL mastery, and dbt proficiency. Quantify achievements in KPI development and business analysis.
- Showcase technical skills: Emphasize experience with dbt, SQL, and advanced Excel. Mention familiarity with cloud data warehouses and BI tools like Power BI, Looker, or Tableau.
- Demonstrate business acumen: Clearly articulate your understanding of SaaS financial metrics (ARR, MRR, Churn, LTV).
- Prepare for interviews: Be ready to discuss complex SQL queries, dbt project structures, and how you've driven strategic decisions through data.
Technical preparation
Master complex SQL queries with window functions.,Practice building data models with dbt.,Develop advanced Excel/Sheets analytical models.,Familiarize yourself with cloud data warehouses.
Behavioral questions
Describe a time you defined a key KPI.,How do you handle data quality issues?,Explain a complex data analysis to a non-technical stakeholder.,How do you manage project timelines and deliverables?
Frequently asked questions
- What are the key responsibilities of a Senior Data Analyst at Nexcess?
- As a Senior Data Analyst at Nexcess, you will be responsible for transforming raw business data into trusted datasets. This includes designing, building, and maintaining the core logic for KPIs and financial metrics, conducting deep-dive analyses, developing data transformation pipelines with dbt and SQL, and ensuring data reliability and documentation.
- What technical skills are most important for this Senior Data Analyst role at Nexcess?
- The most critical technical skills for this role include expert-level proficiency in SQL, hands-on experience with dbt for data modeling, and advanced proficiency in Excel or Google Sheets for analysis. Familiarity with cloud data warehouses (Snowflake, BigQuery, Redshift) and BI tools (Power BI, Looker, Tableau) is also highly valued.
- What kind of business metrics will a Senior Data Analyst at Nexcess work with?
- A Senior Data Analyst at Nexcess will work with core business and financial metrics, particularly those relevant to SaaS and recurring revenue models. This includes metrics such as Annual Recurring Revenue (ARR), Monthly Recurring Revenue (MRR), Churn, Customer Lifetime Value (LTV), Customer Acquisition Cost (CAC), and Margin.
- Is this Senior Data Analyst position remote or on-site at Nexcess?
- The job description indicates that the role can be performed in a traditional climate-controlled office environment or from home, suggesting a hybrid or remote work arrangement is possible for this Senior Data Analyst position at Nexcess.
- What is the expected salary range for the Senior Data Analyst position at Nexcess?
- The base salary for this Senior Data Analyst role at Nexcess is expected to be between $90,000 and $100,000 annually.