Prove Partners

Prove Partners

·Today

Senior sql developer

Apply now

Location

remote, United States

Commitment

Full Time

Level

Senior (5+ years)

Required skills

SQLT-SQLSalesforceData ModelingETLELTData IntegrationFinancial ReportingProject ManagementDatabase Performance TuningSource ControlAccounting DataAPI IntegrationData MappingReconciliation

Job Description

Senior SQL Developer

Finance Data & Systems Migration

Full-time / Remote

About the role

We are looking for a Senior SQL Developer to be a part of PROVE Partner's parent company Allira’s team (remote). We are making SQL the single source of truth for all of our data. Every report, reconciliation and financial statement will run from SQL, while Salesforce and Pulse remain our working systems and feed SQL, until better systems are identified. You will be the hands-on technical owner of the SQL platform. You will also scope the system migration across our Salesforce orgs, build integrations that write from SQL back to Salesforce and other systems, and manage the project day to day, working closely with Finance, Operations and our Salesforce team.

What you'll do

  • Scope the system migration across our Salesforce orgs: data mapping, sequencing, effort, risks and cutover approach
  • Design and build the SQL data model: staging, cleansed core tables and reporting marts
  • Build and schedule data loads from Salesforce, Pulse, the general ledger, loans and the loan ledger, and other sources
  • Rebuild our Salesforce reports in SQL, including accruals, repayments, settlements, clearing reports and weekly journal entries
  • Write tie-out logic that reconciles SQL to the general ledger on every load and every close
  • Turn manual exception reports into automated data-quality checks and alerts
  • Produce credit facility, lender and investor reporting by entity and funding vehicle
  • Build integrations that write from SQL back to Salesforce and other systems, with clear system-of-record and reconciliation rules
  • Manage the project: plan, timeline, status reporting, risks and coordination with Finance, Operations and the Salesforce team
  • Work with our Salesforce team on data mapping and on changes that affect SQL
  • Tune performance, manage code in source control, and document everything you build
  • Partner with the Controller and accounting team during month-end close

What you bring

  • Completed at least one project of similar scope from start to finish, such as a Salesforce-to-SQL migration that included reporting and finance close
  • Hands-on two-way integration experience: writing data from SQL to Salesforce and other systems (Salesforce APIs, Bulk API or middleware)
  • Project management skills: scoping, planning, running timelines and status, managing risks and stakeholders
  • 5+ years writing production SQL (T-SQL / SQL Server preferred): stored procedures, views, functions, indexing and query tuning
  • Experience building ETL / ELT pipelines (SSIS, Azure Data Factory, Fivetran or similar)
  • Dimensional modeling: fact and dimension tables, history tracking
  • Hands-on experience extracting and modeling Salesforce data
  • Strong understanding of accounting data: journal entries, accruals, trial balance, subledger-to-GL reconciliation
  • Experience supporting a financial close or building finance reporting
  • Clear communicator who can work directly with accountants and operations staff

Nice to have

  • Specialty finance, lending or asset management experience (advances, receivables, payoffs, fee accruals)
  • Credit facility, borrowing-base or static pool reporting
  • Power BI or SSRS report development
  • Salesforce administration or development experience
  • Git, CI/CD for database deployments
  • Project management certification (PMP or similar)

Why join

You'll build the data platform from the ground up and own it, with direct visibility to Finance leadership and a clear impact on how the firm closes its books.

Ready to join the team?

Apply now