Highnote is looking to solve the business problem of ensuring financial integrity in high-volume card payment transactions by reconciling network and platform data.
Requirements
- Write, optimize, and maintain complex SQL queries to analyze large-scale transactional data and support reconciliation, reporting, and audit activities.
- Modeling and designing modern data structures in SQL/NoSQL databases, ensuring optimal performance and scalability.
- Developing and maintaining dashboards using tools like Looker, Looker Studio, and other BI platforms to visualize high-volume data effectively.
- Crafting and optimizing complex SQL queries to handle high-volume data efficiently.
- Strong technical proficiency in SQL, reporting, Excel, and data analytics tools such as Looker, Looker Studio, Tableau, or similar BI platforms.
- Experience with Python or other scripting languages for data analysis and automation.
Responsibilities
- Run daily and periodic reports to reconcile card payment transactions between network data (Visa, Mastercard, etc.) and platform data, ensuring accuracy, completeness, and financial integrity.
- Write, optimize, and maintain complex SQL queries to analyze large-scale transactional data and support reconciliation, reporting, and audit activities.
- Understand, validate, and ensure accurate execution of card payment and money movement rules within system workflows and data pipelines.
- Collaborate with engineering, operations, and finance teams to investigate discrepancies, mitigate risks, and resolve transaction or money movement issues.
- Develop deep expertise in payment domains—including transaction, reconciliation, and fund movement.
- Collect and apply feedback from stakeholders to enhance data models, reconciliation processes, and reporting frameworks.
- Modeling and designing modern data structures in SQL/NoSQL databases, ensuring optimal performance and scalability.
Other
- 5+ years of experience in data analysis or reporting within the payments or financial services domain.
- Background in Accounting or Finance, either through formal education or professional experience.
- Collaborating with internal business teams and external stakeholders to define requirements and deliver impactful reporting solutions.
- We’re looking for builders who thrive in ambiguity.
- Positions located in San Francisco are hybrid and include core working days of Tuesday, Wednesday, Thursday in office.
