Accounting Data Analyst (Remote)

SUMMARY:

This role will bring data efficiency and modernization to the finance/accounting department at the Bank.

Candidate will oversee the creation and maintenance of the finance/accounting data warehouse. Using the warehouse as the primary data source will ensure financial statements and periodic reporting are produced according to appropriate filing requirements and provide meaningful business information. The warehouse uses Microsoft Azure and the Google Cloud Platform. Familiarity with these platforms and strong SQL experience will ensure success in the role.

As data is funneled from several distinct separate sources into the warehouse, it will ensure streamlined and consistent reporting for all parties that rely on financial data.

Due to the high reliance on this financial data, data governance will be an integral component of the role as well. As the data owner, this role will need to interface with the governance team to record proper data quality rules and attest to overall data integrity. 

PRINCIPAL DUTIES AND RESPONSIBILITIES:

• • Produce data queries to match existing source reports. This will allow for the automated production of reconciliations, summaries and analysis. Maintain underlying systems and ensure data reconciles across sources.
  • Provide recommendations for improvements in underlying data structures and systems to reduce manual interventions and improve production timelines. 
  • Document existing workflows to identify opportunities for improvement, create information flow improvement and document new results. 
  • Work with other finance units to help develop and implement finance and corporate initiatives and improve day-to-day operations.
  • Develop relationships with data, data analytics and data governance to ensure proper structuring. 
  • The remote-only environment is best suited to self-starters with strong communication skills. 
  • Utilize an understanding of information technology to better gather and manage data. Discuss relevant work experience with financial data and SQL projects. 
  • Exhibit a rudimentary knowledge of auditing theory and accounting controls to ensure proper reconciliations, avoid compliance issues and audit exceptions. 
  • Display a basic understanding of accounting principles to ensure proper reporting across a number of transaction types.
  • Apply basic modeling and analytical skills to create meaningful analysis and reporting. Communicate accounting principles and technical analysis effectively.

POSITION SPECIFICATIONS:

• • Bachelor’s degree in Accounting, Finance, Information Systems, or a related field
  • 3+ years of experience working with financial data, reporting systems, or data warehousing in a corporate or banking environment
  • Proficiency in SQL for data querying, reconciliation, and analysis
  • Strong understanding of financial reporting requirements and accounting principles
  • Familiarity with data governance practices, including data quality rules and documentation
  • Ability to work independently in a remote environment and communicate effectively across teams
  • Demonstrated experience improving data workflows, systems, or reporting processes
  • Preferred hands-on experience with cloud platforms such as Microsoft Azure and Google Cloud Platform/Looker
  • Preferred experience in Banking, Financial Services and/or supporting Accounting teams