Data Analyst — Business & Investment Analytics

Data Analyst — Business & Investment Analytics

A&P Investment Partners LLC

Greater Hartford, CT Hybrid / In-person

ABOUT US

A&P Investment Partners LLC is a privately held investment firm that acquires and operates small businesses and commercial real estate across Connecticut. Our portfolio spans multiple operating companies — gas stations, convenience stores, a liquor store, and a restaurant — each generating rich transactional data across point-of-sale, fuel, banking, and payroll systems, alongside a growing real estate portfolio. We are building a data-driven decision-making function from the ground up, and this role sits at the center of it.

POSITION SUMMARY

We are hiring a Data Analyst to design and own the analytics, reporting, and forecasting infrastructure for a multi-entity business and real estate portfolio. You will work with large, real-world datasets — POS transactions, fuel margins, banking and payroll records, cost data, and property and market data — and turn them into automated dashboards, predictive models, and quantitative analyses that drive operating and investment decisions. This is a hands-on, quantitative role reporting directly to ownership, with the autonomy to build the data stack and analytical methods from the ground up.

KEY RESPONSIBILITIES

Data Engineering & Analytics (Core Focus)

• Consolidate and clean data from multiple source systems (POS, fuel, banking, payroll, accounting) into structured, reliable datasets for analysis.
• Design and maintain automated data pipelines that replace manual, spreadsheet-based reporting.
• Apply statistical analysis and data-mining techniques to surface trends, anomalies, and margin-improvement opportunities across the portfolio.

Business Intelligence & Reporting

• Build and maintain interactive dashboards and KPI reporting in Power BI, Tableau, or similar tools.
• Develop automated performance reporting on fuel margins, store sales, basket s...