For Employers

Prove Partners

Senior SQL Developer

Posted 18 minutes ago
5-10 years experience
Apply Now

Please mention DailyRemote when applying

?Not checked yet0100
Resume Match Score

See how much of this job your resume covers, and what’s missing.

Want a recruiter to go through it line by line?

Get professional review

Tailor your resume to this job

One click makes a copy of your resume for this role, scores it against the posting, and proposes edits line by line. Your default resume is never changed.

  • Job match score for this posting
  • Edits you accept or skip, no invented facts
  • Download it when it reads right: TXT free, PDF with Premium

Create a cover letter for this job

Upload your resume and we draft a letter for this exact role, tailored to what it asks for.

  • Tailored to this role
  • Based on your resume
  • Fully editable
AI Summary

You will serve as the technical owner of the SQL platform, managing system migrations and building integrations between SQL, Salesforce, and other financial systems. Additionally, you will automate data-quality checks and produce reporting for credit facilities, lenders, and investors.

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.
 

Automatically Apply to the Best Remote Jobs

Stop the endless job search. Our AI finds and applies to the best jobs for you.

Try it Now
Keep looking

Similar Jobs

See all Remote Software Development jobs →

DevOps Developer

Full Time Belgium Software Development

Senior DevOps Engineer

Full Time United States $160K - $180K per year Software Development

AS400 Programmer

Full Time United States Software Development

Senior Data Engineer

Full Time United States $120K - $160K per year Software Development

Software Engineer

Full Time Finland Software Development

Remote IP Network Engineer II (SD-WAN Palo Alto & Firewall Engineering)

Freelance United States $50 - $61 per hour Software Development
Apply Now

Personalize your Remote Job Search in 3 Easy Steps!

Featuring 214,569+ Jobs in Software Development

Answer easy questions

Answer easy questions

214,569+ jobs across 15+ categories

Get your best job matches

Get your best job matches

Only hand-screened, legit jobs

Find a remote job faster

Find a remote job faster

No ads, scams, or junk

“I was the first applicant for a remote marketing position that got listed on the company website the same day I applied. Had an interview within 48 hours!”

Sarah J. — Sarah J. · Marketing Manager ★★★★★ Verified