Business Intelligence Engineer

Merchants Fleet • Hooksett, NH

12d • Hybrid

About The Position

The Business Intelligence Engineer serves as a technical bridge between Enterprise IT/Data Architecture and Treasury. The role designs, builds, and optimizes data infrastructure, pipelines, and reporting environments that support financial operations, audit processes, and securitization modeling. The engineer works with business and technical stakeholders to ensure complex financial data is accurate, secure, scalable, and available for reporting and analysis.

The position partners with Finance and Treasury teams to translate business needs into data and reporting solutions, builds and integrates data models and reporting layers, and improves data quality through documentation, validation, monitoring, and error handling. The role is based at Merchants Fleet headquarters in Hooksett, New Hampshire, with a hybrid workplace arrangement and minimal travel potentially required. Relocation assistance and employment visa sponsorship are not available. Candidates must be authorized to work in the United States on a permanent basis.

Requirements

• 5+ years of experience as a Data Engineer, Analytics Engineer, or in a similar role; financial data and reporting experience is preferred.
• Advanced SQL expertise, including writing, debugging, and optimizing complex queries, stored procedures, common table expressions (CTEs), and window functions.
• Experience designing data models and semantic layers for business users.
• Strong understanding of data architecture, transformation, and integration principles.
• Ability to communicate implementation approaches, dependencies, and technical solutions clearly to technical and non-technical audiences.
• Knowledge of financial concepts such as forecasting, budgeting, and variance analysis.
• Strong interpersonal and communication skills, including the ability to partner directly with finance leaders and business stakeholders.
• Initiative, curiosity, and a passion for solving complex business and data challenges.
• Must be authorized to work in the United States on a permanent basis; employment visa sponsorship is unavailable.

Nice To Haves

• Experience with Snowflake is strongly preferred.
• Bachelor's degree in Computer Science, Applied Mathematics, Data Engineering, Data Science, Business Analytics, or a related technical discipline.
• Additional business education, such as Finance coursework or an MBA, or related experience.
• Experience supporting financial reporting, treasury operations, audit processes, or securitization data environments is highly desirable.

Responsibilities

• Partner with Finance and Treasury teams to understand business needs and translate them into scalable data and reporting solutions.
• Identify, explore, and integrate data from multiple systems to support financial reporting, planning, and analytics.
• Design and develop scalable data models that support business consumption and decision-making.
• Collaborate with fellow engineers to acquire, transform, and integrate source data across platforms.
• Ensure the accuracy, completeness, and consistency of enterprise data assets and reporting layers.
• Document business rules, data definitions, metrics, and logic to promote transparency and shared understanding.
• Support internal and external audits through clean reporting datasets and traceable data lineage.
• Build automated validation, monitoring, and error-handling processes to proactively identify and address data quality issues.
• Serve as a trusted data partner for finance stakeholders, bridging business requirements and technical solutions.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed