Senior SQL Developer
Posted
Who recruits here Pro
Up to three recruiters at PROVE with their work email, so you can write to a person.
Part of Pro. How it works
Description
Senior SQL Developer
Finance Data & Systems Migration
Full-time / RemoteAbout the roleWe 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
Finance Data & Systems Migration
Full-time / RemoteAbout the roleWe 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
- 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
- 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)
Skills
Sign in to read and join the discussion.