Sales and Estimating Business Analyst

PowerGrid Services; Hartselle (AL); On-site; USD 85,000 - 110,000; Full time

Job summary

PowerGrid Services is seeking a seasoned Business Analyst to lead Sales and Estimating initiatives, collaborating with commercial leaders, Finance, Operations, Marketing, and technology teams to align priorities with desired business outcomes.

You will map current and future processes for lead and opportunity management, estimating, pricing, approvals, and workflows, translating objectives into requirements, user stories, data definitions, and measurable success criteria while ensuring data

Qualifications

• Translate commercial objectives into requirements, rules, user stories, and acceptance criteria.
• Define data definitions, integration needs, and success metrics.
• Plan UAT, regression testing, and release readiness for CRM initiatives.
• Ensure data quality and governance across CRM, estimating, and reporting systems.

Responsibilities

• Serve as the primary Business Analyst for Sales and Estimating 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.

Skills

Salesforce CRM

Excel modeling

Data governance

Requirements gathering

Stakeholder communication

Education

Bachelor's degree or higher

Tools

ZoomInfo

Microsoft Dynamics

Power BI

Job description

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

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

Education And Experience

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.

Platform & Technology Experience

Candidates should have strong functional experience with Salesforce and enterprise CRM processes, along with experience using data-enrichment or prospecting platforms such as ZoomInfo. Experience with Microsoft Dynamics and estimating or quoting applications is strongly preferred. Advanced Microsoft Excel skills are required, 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. 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.

CORE COMPETENCIES Commercial process and CRM knowledge Business requirements and process design Advanced Excel data transformation and modeling CRM data quality and governance
UAT and release coordination Cross-functional facilitation and prioritization Analytical problem solving Documentation and stakeholder communication

Key Success Measures

• CRM adoption, data quality, and process consistency
• Improvement in opportunity and estimating process efficiency
• Quality and completeness of requirements and release outcomes
• Accuracy and usefulness of commercial analysis and models
• Reduction in duplicate entry and handoff failures
• Stakeholder confidence across Sales, Estimating, Finance, and Operations