San Francisco Staffing
Data Reconciliation Specialist
San Francisco Staffing, San Francisco, California, United States, 94199
Data Reconciliation Specialist
Our client is looking for a Data Reconciliation Specialist. This is a long-term contract role, where you'll play a pivotal part in ensuring the accuracy and integrity of financial and trading data while contributing to process improvements. If you have a passion for data analysis, thrive in spreadsheets, and enjoy refining workflows, this is an excellent opportunity to make a meaningful impact. Responsibilities: Reconcile data across multiple platforms, including databases, Google Sheets, Snowflake, and Looker, ensuring consistency and accuracy. Review financial transactions, categorize them appropriately, and verify compliance with reporting standards. Validate trade records by cross-referencing payments data, transaction IDs, and blotter tools to maintain operational accuracy. Conduct quality assurance checks to confirm dataset integrity and identify discrepancies. Analyze the current reconciliation processes to seamlessly integrate and identify opportunities for improvement. Develop new QA protocols to flag errors or discrepancies proactively during daily reconciliations. Collaborate on refining and restructuring reconciliation workflows to enhance efficiency and scalability. Take ownership of reconciliation processes, ensuring they are performed accurately and on schedule. Contribute to innovative solutions for process enhancement and automation where applicable. Requirements: Proven experience in data reconciliation and proficiency with tools such as pivot tables and Google Sheets. Exceptional attention to detail and a systematic approach to validating large datasets. Strong analytical skills and a passion for optimizing workflows and processes. Familiarity with Microsoft SQL and BusinessObjects Technologies. Knowledge of data analysis and business intelligence (BI) tools. Experience with Erwin Data modeling tools. Hands-on expertise with Snowflake and Looker is a plus. Basic programming knowledge in Python for automation or scripting tasks is desirable.
Our client is looking for a Data Reconciliation Specialist. This is a long-term contract role, where you'll play a pivotal part in ensuring the accuracy and integrity of financial and trading data while contributing to process improvements. If you have a passion for data analysis, thrive in spreadsheets, and enjoy refining workflows, this is an excellent opportunity to make a meaningful impact. Responsibilities: Reconcile data across multiple platforms, including databases, Google Sheets, Snowflake, and Looker, ensuring consistency and accuracy. Review financial transactions, categorize them appropriately, and verify compliance with reporting standards. Validate trade records by cross-referencing payments data, transaction IDs, and blotter tools to maintain operational accuracy. Conduct quality assurance checks to confirm dataset integrity and identify discrepancies. Analyze the current reconciliation processes to seamlessly integrate and identify opportunities for improvement. Develop new QA protocols to flag errors or discrepancies proactively during daily reconciliations. Collaborate on refining and restructuring reconciliation workflows to enhance efficiency and scalability. Take ownership of reconciliation processes, ensuring they are performed accurately and on schedule. Contribute to innovative solutions for process enhancement and automation where applicable. Requirements: Proven experience in data reconciliation and proficiency with tools such as pivot tables and Google Sheets. Exceptional attention to detail and a systematic approach to validating large datasets. Strong analytical skills and a passion for optimizing workflows and processes. Familiarity with Microsoft SQL and BusinessObjects Technologies. Knowledge of data analysis and business intelligence (BI) tools. Experience with Erwin Data modeling tools. Hands-on expertise with Snowflake and Looker is a plus. Basic programming knowledge in Python for automation or scripting tasks is desirable.