Data Analyst

About the role

• Howard Financial is seeking for Data Science, Computer/Systems Engineering, Mathematics, Statistics, Physics or Economics professional to join our operations team. This role is critical for the scalability of Howard Financial, focusing on the manual and automated migration of robust databases (100k+ rows) and the design of technological solutions to eliminate human error in the accounting workflow. Your mission is to transform manual processes into efficient, programmable, and high-quality automated workflows.

What you'll do

• Design and execute internal automated processes to eliminate manual intervention and eradicate errors in financial data handling.
• Implement code components using languages such as Python or SQL to transform and analyze data according to the integration requirements of the ecosystem.
• Perform rigorous testing and debugging to ensure every automation is stable and accurate before being deployed into production.

• Lead the technical migration of client databases exceeding 100,000 rows, guaranteeing the total integrity of every record.
• Act as the "data guardian," validating that property and entity mapping is 100% accurate between sub-ledgers and the ERP (Sage Intacct).
• Create and update mapping guides to standardize the onboarding of new clients into the financial ecosystem.

• Oversee the seamless data flow between Guesty (PMS), Ramp (AP), Paylocity (Payroll), and Sage Intacct.
• Develop automated "three-way reconciliation" processes to manage high-volume bank and system transaction matching.
• Validate balances in clearing accounts and resolve daily sync failures to ensure accounting is ready by the start of the U.S. business day.

Qualifications

Required

• Bachelor's or technical degrees in Systems or Software Engineering, Data Science, Statistics or Mathematics, Economics or Finance
• Minimum of 2 years in data analysis, data engineering, or similar roles with a strong focus on automation.
• SQL & Programming: Expert ability to write complex queries (JOINs, CTEs) and develop automation scripts.
• Advanced Excel: Mastery of VBA/Macros and Power Query to handle robust datasets (100k+ rows).
• English Level B2+

Prefered:

• Financial Tools: Previous experience with Ramp, Paylocity, Guesty, or similar ERP/Integration systems is highly valued.
• Accounting Logic: Understanding of Accrual Basis Accounting to ensure that all developed scripts respect financial logic.

Benefits

• Competitive pay – based on experience and role.
• Quarterly performance bonus – tied to team and individual results.
• Unlimited paid time off after six months of being employed.
• Remote work – collaborate with a global team from wherever you are.
• 10 paid holidays per year – local or U.S. holidays, your choice.
• Annual performance reviews – with clear feedback and salary discussions.
• Career growth opportunities – we support your development and next steps.
• Learning culture – we value curiosity, feedback, and continuous improvement.
• Supportive team – sharp, friendly people who care about great work.