onsite
Accounting Data Analyst
Data Analyst
Analyze and validate accounting data using Amazon Redshift and Google BigQuery, build robust data models, and create interactive dashboards to ensure data integrity and support financial decision‑making.
About the role
Key Responsibilities
- Design, develop, and maintain data pipelines in Amazon Redshift and Google BigQuery to ingest and transform accounting data.
- Build and optimize data models that reflect financial structures, ensuring accuracy and scalability.
- Create interactive dashboards and reports for finance stakeholders, highlighting key metrics and trends.
- Perform data quality checks, reconcile discrepancies, and implement controls to maintain data integrity.
- Collaborate with accounting, finance, and engineering teams to translate business requirements into technical solutions.
Requirements
- Strong proficiency in SQL and experience with Amazon Redshift and Google BigQuery.
- Hands‑on experience in data modeling for financial or accounting data.
- Proven ability to develop dashboards using tools such as Tableau, Looker, or Power BI.
- Solid understanding of data integrity principles and experience implementing data validation processes.
- Familiarity with Python for data manipulation and automation is a plus.