Senior Analyst

AmSpec LLC.; Pasadena (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

AmSpec LLC. in Pasadena, TX is seeking a Senior Analyst to own and improve revenue and cost forecasting models.

You’ll work with large datasets from ERP and accounting systems to produce projections that guide business decisions and partner with leadership to turn analysis into clear recommendations. Responsibilities include cleaning and transforming data, maintaining forecasting models, and creating reports and dashboards for non-technical stakeholders.

Qualifications

• Bachelor’s degree in data science, statistics, economics, finance, CS, mathematics, or related field, or equivalent experience.
• 4 to 6 years of experience in data analysis.
• Proficiency in Python (pandas) or R.
• Strong SQL skills including joins, aggregations, and window functions.
• Strong Excel skills with formulas, pivot tables, and scenario modeling.
• Ability to communicate clearly in writing.

Responsibilities

• Clean, validate, and transform large datasets from ERP and accounting systems 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.

Skills

Python (pandas)

SQL

Excel

Statistics

Data analysis

Data visualization

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 Skills

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