Note: The job is a remote job and is open to candidates in USA. RGP is seeking a hands-on Snowflake Data Analyst to support a high-volume financial data environment during an audit preparation initiative. The role focuses on extracting, validating, and analyzing financial data, taking ownership of Python data-transfer scripts, and partnering with finance, accounting, technical, and executive stakeholders.
Responsibilities
- 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
Skills
- The ideal candidate combines strong Snowflake, SQL, and Python expertise with demonstrated experience processing large financial and transactional datasets
- Candidates must have direct experience working with accounting-related data at scale and be comfortable operating in a fast-paced, high-expectation client environment
- 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
- 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
Benefits
- Fully remote, United States
Company Overview