Company Overview:
- We are a fast-growing toll management company operating a data-intensive toll platform that ingests, matches, and reconciles high volumes of toll, fleet, and transaction data.
- We are looking to bring on a dedicated Senior Data Analyst as a consultant to turn that data into reliable reporting, actionable insight, and repeatable data processes across the business.
- We are open to engaging this resource through a consulting or staffing firm that can source, onboard, and support the placement.
Role Summary:
- This is a hands-on analyst role.
- The right person moves fluidly between writing SQL, building processes and dashboards, digging into data-quality issues, and presenting findings to the leadership team.
- They take ownership end-to-end, and thrive in a startup environment.
- We want someone who can go from a raw question to a trustworthy answer without waiting for a perfectly defined spec.
- No analysis is too small.
- If it makes the business smarter with data, it is in scope.
Toll & Transaction Data Analysis:
- Analyze toll transaction, fleet, and plate data to surface trends, anomalies, and root causes.
- Reconcile toll charges, transponder/plate activity, and authority invoices to validate accuracy and flag discrepancies.
- Investigate data-quality and matching issues, such as unmatched plates, duplicate or missing transactions, and quantify their business impact.
- Turn ad-hoc business questions into clear, defensible analyses under tight timelines.
Reporting & Business Intelligence:
- Build and maintain dashboards and reports in Power BI or a similar BI tool for operations, finance, and leadership.
- Automate recurring reports so they run reliably with minimal manual effort.
- Present findings clearly to both technical and non-technical audiences, with a recommended action, not just numbers.
- Define and document metric logic so a KPI means the same thing across every report.
Data Processes & Pipelines:
- Design, document, and maintain repeatable data processes for pulling, cleaning, joining, and transforming operational data.
- Write and optimize SQL queries and views against the platform database to power reporting and analysis.
- Establish data-validation and QA checks to catch bad data before it reaches a report or a decision.
- Identify manual, error-prone data steps and streamline or automate them.
KPI & Performance Analysis:
- Define, track, and report the KPIs that measure toll platform health, such as match rates, reconciliation accuracy, processing volumes, exception rates, and cost per transaction.
- Monitor KPI trends over time, explain movements, and alert the team early when something drifts.
- Build the analytical backbone for pilot reviews and business performance reporting.
General Analytics Support:
- Take on new analytical initiatives as the business and platform grow.
- Partner with operations, product, and finance to scope questions and deliver the data they need.
- Act as a reliable data right hand across shifting priorities.
Ideal Profile:
- Analytical rigor: structures messy questions, checks their own work, and trusts the numbers only after validating them.
- Startup mindset: adaptable, self-directed, and comfortable operating without a rigid role definition.
- Entrepreneurial spirit: treats the business like their own; sees a gap in the data or a question worth asking and acts on it.
- Ambitious: wants to be part of a founding team and something big, and to grow as the company grows.
- Multi-tasker: juggles multiple analyses and workstreams without dropping the ball.
- Strong communicator: translates data into a clear story and a recommendation, across teams and external partners.
- Independent driver: takes initiative, owns outcomes, and follows through unprompted.
- Detail-oriented: accuracy in queries, reconciliations, metric definitions, and reporting.
Must-Have Requirements:
- 4-7 years in data analysis, business intelligence, or a closely related analytical role at a senior level.
- Bachelor's degree in a quantitative, business, or related field or equivalent experience.
- SQL expertise: fluent writing and optimizing queries, including joins, aggregations, window functions, and CTEs, to pull and transform data for reporting and analysis.
- Power BI or a similar BI/visualization tool like Tableau or Looker: able to build, publish, and maintain production dashboards.
- Advanced Excel and Google Sheets: pivot tables, complex formulas, lookups, and building clean, reusable models and reports.
- Fluent, professional English, written and spoken: non-negotiable; the role involves regular communication and presenting findings to US-based teams and external partners.
- Ability to work US Eastern time zone business hours.
Nice to Have:
- Familiarity with toll, fleet, mobility, logistics, or payments data.
- Comfort with a scripting language for data work, such as Python, for cleaning and automation.
- Exposure to data modeling, ETL/ELT concepts, or working with data warehouses.
- Experience defining KPIs and reporting frameworks from scratch in an early-stage company.
- Explains the so what: we need an analyst who ends with a recommendation and a dollar or impact figure, not a dashboard hand-off.
- Repeatability mindset: favor candidates who naturally productize their analyses.