Analyst Data Analytics- Converse TX

Position: Analyst I Data Analytics- Converse TX
Essential Duties & Responsibilities

Operational Production Tracking

* Track subcontracted production quantities against issued purchase commitments and customer-issued funding constraints.

* Monitor and reconcile subcontractor commitments to ensure spending remains within approved customer authorization limits.

* Maintain accurate production tracking logs for aerial, underground, directional drilling, trenching, fiber splicing, restoration, and related telecom construction activities.

* Validate daily, weekly, and monthly production quantities submitted by subcontractors and field teams.

* Compare subcontractor production against customer-approved production reporting and internal operational records.

* Identify production discrepancies, overages, duplicate billing, unsupported quantities, or scope inconsistencies and escalate findings appropriately.

Invoice Validation & Processing Support

* Review subcontractor invoices after Project Management approval to ensure all billed production is properly supported and documented.

* Validate that invoiced quantities align with:

* Executed purchase commitments

* Approved production quantities

* Customer funding limitations

* Internal production records

* Supporting field documentation

* Enter approved and substantiated production into customer production tracking systems and logs.

* Maintain organized supporting documentation packages for customer audit and financial reconciliation purposes.

* Annotate or stamp subcontractor invoices indicating:

* Production has been entered into customer logs

* Supporting backup has been verified

* Invoice is ready for final approval and payment processing

* Coordinate with Finance and Accounts Payable teams to ensure timely and accurate payment processing.

Reconciliation & Financial Coordination

* Reconcile contracted work quantities against:

* Customer-approved quantities

* Subcontractor commitments

* Actual field production

* Project budgets

* Assist with identifying required purchase order increases, overages, and change order requests.

* Support preparation and tracking of contractor change orders and funding adjustments.

* Monitor project financial exposure related to subcontractor commitments and production trends.

* Work closely with Finance to support accurate forecasting, accruals, billing support, and cost tracking.

* Assist in identifying operational inefficiencies, production variances, and financial risks.

Reporting & Communication

* Prepare and distribute daily operational and production communications to project teams and leadership.

* Generate recurring reports related to:

* Production status

* Commitment utilization

* Invoice tracking

* Customer reporting

* Change order status

* Financial exposure

* Communicate professionally with customers, customer agents, subcontractors, field leadership, and internal stakeholders.

* Support customer audits and requests for documentation or production backup.

* Participate in operational meetings and provide analytical support to leadership.

Administrative & Systems Support

* Maintain accurate project records, logs, spreadsheets, databases, and reporting tools.

* Assist with continuous improvement of operational reporting and reconciliation processes.

* Support implementation and maintenance of operational controls and documentation standards.

* Utilize Excel and other internal/customer systems to analyze and manage operational data.

* Ensure all documentation is maintained in accordance with customer and company standards.

Required Qualifications

* High school diploma or equivalent required; associate's or bachelor's degree in Business, Finance, Accounting, Construction Management, Data Analytics, or related field preferred.

* Minimum 2 years of experience in operations support, project controls, construction administration, finance coordination, invoicing, or data analytics preferred.

* Experience in utility construction, telecommunications, infrastructure, or subcontractor management environments strongly preferred.

* Strong understanding of production tracking, invoicing workflows, and financial reconciliation processes.

* Advanced proficiency in Microsoft Excel, including:

* Pivot tables

* VLOOKUP/XLOOKUP

* Data validation

* Reporting and reconciliation functions

* Strong organizational and multitasking skills.

* Excellent written and verbal communication skills.

* Ability to manage sensitive financial and operational information confidentially.

* Strong attention to detail and high level of accuracy.

* Ability to work independently while also collaborating effectively with Operations and Finance teams.

* Must live near San Antonio, TX

Preferred Qualifications

* Experience with customer production systems and utility construction reporting.

* Familiarity with telecom construction methods including:

* Directional drilling

* Aerial fiber installation

* Open cut trenching

* Fiber splicing and testing

* Experience with ERP, accounting, or project management systems.

* Experience working with subcontractor billing and change order management.

Key…