The Data Analyst will support audit preparation by extracting, validating, and analyzing high-volume financial and transactional data within Snowflake. They will also take ownership of Python-based data extraction scripts and collaborate with finance and executive stakeholders to ensure data accuracy.
Fully Remote
Full time
New York City New York United States
Consulting
On Demand Talent
About This Role
RGP is seeking a hands-on Snowflake Data Analyst to support a high-volume financial data environment during an audit preparation initiative. This individual will take ownership of Python-based data extraction currently handled by the Corporate Controller and work directly with finance, accounting, and executive stakeholders.
The ideal candidate combines strong Snowflake, SQL, and Python expertise with demonstrated experience processing large financial and transactional datasets. This is not a general analytics role. Candidates must have direct experience working with accounting-related data at scale and be comfortable operating in a fast-paced, high-expectation client environment.
Location: Fully Remote, United States
Schedule: Full-time contract; ability to work Eastern Time hours required
Initial Duration: Through the end of March, with potential for extension
Target Pay Range: $90–$100 per hour, W2
What You Will Work On
Support audit preparation by extracting, validating, and analyzing financial and transactional data stored in Snowflake.
Take ownership of existing Python scripts used to transfer data from Snowflake into the accounting system.
Write and optimize complex SQL queries to retrieve large volumes of financial data.
Review and enhance current data-extraction processes for accuracy, reliability, and audit readiness.
Work within an interconnected data environment that includes change data capture, Snowflake, Python, and downstream accounting systems.
Process data associated with approximately 780,000 invoices annually and millions of underlying transaction lines.
Partner directly with finance, accounting, technical, and executive stakeholders.
Translate financial and audit requirements into practical data solutions.
Clearly communicate findings, risks, dependencies, and technical issues to both technical and nontechnical audiences.
Potentially support broader enterprise data transformation initiatives following the initial audit assignment.
What You Will Bring
Strong hands-on experience with native Snowflake development and data operations.
Advanced SQL skills, including experience querying and validating large datasets.
Strong Python scripting experience, particularly for data extraction, transformation, and system-to-system data movement.
Direct experience processing high-volume financial, accounting, invoice, or transactional data.
Experience working with large-scale transactional systems or accounting-system integrations.
Ability to validate data completeness, accuracy, and consistency for audit or financial reporting purposes.
Demonstrated experience working in fast-paced finance or accounting environments.
Strong stakeholder-management and client-facing communication skills.
Ability to communicate technical concepts directly, clearly, and concisely.
Professional maturity and executive presence.
Ability to work independently, take ownership of deliverables, and navigate demanding stakeholder expectations.
Availability to work Eastern Time hours.
Preferred Qualifications:
Experience supporting financial audits, audit readiness, or financial-data reconciliation.
Experience transferring data between Snowflake and ERP, accounting, or financial reporting systems.
Familiarity with change data capture environments.
Experience improving or taking ownership of Python scripts originally developed by finance or accounting stakeholders.
Background supporting organizations with large invoice volumes and millions of transaction-level records.
Experience with enterprise data transformation or financial-data modernization initiatives.
Ability to support evolving data needs beyond the initial audit engagement.
“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!”