Sales & Estimating Business Analyst

PowerGrid Services; Hartselle (AL); On-site; USD 70,000 - 100,000; Full time

Job summary

PowerGrid Services is seeking a Sales & Estimating Business Analyst to translate commercial processes into effective CRM solutions. You will partner with Sales, Estimating, Finance and Operations, supporting Salesforce, ZoomInfo, Dynamics, estimating workflows, and reporting.

Advanced Excel modeling and data governance will drive pipeline visibility and forecasting. You will define requirements, write user stories, test plans, and coordinate UAT and adoption activities across systems while

Qualifications

• Bachelor's degree or equivalent with 5+ years in business analysis, CRM, or related consulting.
• Proven ability translating business requirements into application specifications and coordinating cross-functional changes.
• Strong experience with Salesforce and enterprise CRM processes.

Responsibilities

• Serve as the primary BA for Sales and Estimating application initiatives with cross-functional teams.
• Analyze current and future processes for lead, opportunity, data, estimating, and reporting workflows.
• Translate objectives into requirements, user stories, data definitions, and integration needs.

Skills

Salesforce

ZoomInfo

Microsoft Dynamics

Excel

Education

Bachelor's degree

Tools

Power BI

Job description

The Sales & Estimating Business Analyst serves as the primary functional applications partner for Sales and Estimating, translating commercial processes and business requirements into effective application solutions. The role supports Salesforce, ZoomInfo, Microsoft Dynamics, estimating workflows, related integrations, and reporting needs from discovery through testing and adoption. This position works directly with Sales, Estimating, Finance, and Operations stakeholders, uses advanced Excel to transform and model commercial data, and helps improve pipeline visibility, estimating efficiency, data quality, and downstream handoffs.

Responsibilities

• Serve as the primary Business Analyst for Sales and Estimating application initiatives, partnering with commercial leaders, Finance, Operations, Marketing, and technology teams to understand priorities and desired business outcomes.
• Analyze current-state and future-state processes for lead management, opportunity management, account and contact data, estimating, pricing, approvals, proposal workflows, commercial handoffs, and related reporting.
• Translate business objectives into requirements, process flows, business rules, user stories, acceptance criteria, data definitions, integration requirements, and measurable success criteria.
• Perform functional analysis and support solution design across Salesforce, ZoomInfo, Microsoft Dynamics, estimating or quoting applications, and connected field-service, finance, and integration capabilities.
• Support commercial data governance by defining ownership, required fields, quality rules, duplicate-management practices, and consistent business definitions for pipeline, conversion, estimates, backlog, margin, and forecast information.
• Plan and coordinate user acceptance testing, regression testing, defect review, release readiness, training, communications, and adoption activities for Sales and Estimating application changes.
• Use advanced Microsoft Excel to transform and clean commercial data, build dynamic pipeline, pricing, estimating, margin, backlog, and forecast models, perform scenario analysis, reconcile information across systems, and present findings clearly to stakeholders.
• Analyze handoffs and integrations among CRM, estimating, ERP, field service, Finance, and reporting systems; identify breakdowns that create duplicate entry, missing information, delayed work, or inconsistent reporting.
• Maintain and prioritize the Sales and Estimating application backlog using business value, revenue impact, process risk, dependencies, effort, data readiness, and adoption capacity.
• Create and maintain process documentation, decision records, training materials, testing scenarios, release communications, and user guidance that support CRM adoption and consistent commercial processes.

Qualifications

Bachelor’s degree in business, information systems, finance, sales operations, engineering, or a related field, or an equivalent combination of education and relevant professional experience. Minimum of 5 years of progressive experience in business analysis, CRM, sales operations, estimating operations, enterprise application implementation, revenue operations, or related consulting. Demonstrated experience translating commercial processes into application requirements and coordinating cross-functional system changes is required.

Required Skills

• Strong functional experience with Salesforce and enterprise CRM processes.
• Experience using data-enrichment or prospecting platforms such as ZoomInfo.
• Advanced Microsoft Excel skills, with emphasis on data transformation, dynamic modeling, scenario analysis, reconciliation, and clear presentation of commercial information.
• Expected Excel capabilities include advanced formulas and lookup logic, PivotTables/PivotCharts, dynamic arrays, Power Query or comparable transformation techniques, and structured models for pipeline, pricing, estimates, margin, backlog, and forecasting.

Preferred Skills

• Experience with Microsoft Dynamics and estimating or quoting applications is strongly preferred.
• Power BI exposure is a nice-to-have rather than a core requirement.
• Familiarity with field service, OneStream, enterprise integrations, and an enterprise ticketing or ITSM system such as ServiceNow is beneficial.

Equal Opportunity Statement

We are committed to diversity and inclusivity in our hiring practices.