Senior Data Analyst

AmSpec Group; Pasadena (TX); On-site; USD 85,000 - 120,000; Full time

Job summary

AmSpec Group in Pasadena, TX is seeking a Senior Analyst to own and enhance revenue and cost forecasting models. You will work with large datasets to project business outcomes and partner with leadership to translate analysis into clear recommendations.

You will build reports and dashboards for non-technical stakeholders, document data sources and model logic, and help improve data pipelines to ensure accuracy and repeatability across forecasting efforts.

Qualifications

• Bachelor’s degree or equivalent experience in a quantitative field.
• 4–6 years of experience in data analysis.
• Proficiency in Python (pandas) or R.
• Strong SQL skills (joins, aggregations, window functions).
• Advanced Excel skills (formulas, pivot tables, scenario modeling).
• Solid understanding of statistics (variance, regression).
• Experience handling large datasets and clear written communication.

Responsibilities

• Clean, validate, and transform large datasets for analysis.
• Own and maintain revenue and cost forecasting models.
• Create reports and dashboards for non-technical stakeholders.
• Document data sources, assumptions, and model logic for repeatability.
• Flag data quality issues and help improve data pipelines.

Skills

Python (pandas)

R

SQL

Excel

Statistics

Data analysis

Communication

Education

Bachelor’s degree in data science, statistics, economics, finance, CS, mathematics, or related field

Tools

Power BI

Tableau

Looker

Git

Job description

About The Role

We’re looking for a Senior Analyst to own and improve our revenue and cost forecasting models. You’ll work with large datasets to produce projections that guide business decisions, and you’ll partner closely with leadership to turn analysis into clear recommendations.

Responsibilities

• Clean, validate, and transform large datasets from ERP and accounting system for analysis
• Own and maintain revenue and cost forecasting models
• Create reports and dashboards that present results clearly to non-technical stakeholders
• Document data sources, assumptions, and model logic so work is repeatable
• Flag data quality issues and help improve data pipelines

Required Qualifications

• Bachelor’s degree in data science, Statistics, Economics, Finance, Computer Science, Mathematics, or a related field (or equivalent experience)
• 4 to 6 years of experience in data analysis
• Working proficiency in Python (pandas) or R
• Solid SQL skills (joins, aggregations, window functions)
• Strong Excel skills, including formulas, pivot tables, and scenario modeling
• Strong understanding of statistics (variance, regression)
• Comfort working with large datasets
• Attention to detail and clear written communication

Preferred Qualifications

• Experience with a BI tool such as Power BI, Tableau, or Looker
• Basic understanding of financial concepts: revenue, COGS, fixed vs. variable costs, margins
• Familiarity with Git or version control