Data Analyst

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

Requirements:

• 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