Scopely 7 дней назад
Analytics Engineer, Finance
- Barcelona, Spain
- Гибрид
SQLGitAirflowDBTFinanceData PipelinesData QualityLooker StudioReporting
Описание
Responsibilities
- Partner with Finance stakeholders to understand business requirements, financial processes, and controls, translating them into practical technical solutions with guidance from the Lead Analytics Engineer.
- Develop, maintain, and troubleshoot data pipelines, SQL transformations, and reporting models supporting monthly close, revenue reporting, and accounting workflows.
- Investigate missing, delayed, inconsistent, or incorrect financial data, identify root causes, and implement reliable solutions.
- Help modernize legacy SQL, scheduled workflows, and manual processes into maintainable, documented, and dependency-aware pipelines using dbt.
- Build and improve automated data-quality checks, reconciliations, monitoring, and alerting to strengthen the reliability of Finance data workflows.
- Apply Git, code review, testing, and deployment practices to improve the quality and maintainability of Finance data assets.
- Support the automation of recurring spreadsheet-based processes and manual handoffs, while maintaining technical documentation, dependency maps, runbooks, and recovery procedures.
- Collaborate with the Lead Analytics Engineer to apply engineering standards and contribute to governed, reusable models within the Looker semantic and reporting layer.
Requirements
- Strong SQL skills and experience developing and maintaining production data transformations.
- Experience working with a modern cloud data warehouse such as BigQuery, Snowflake, or Redshift.
- Experience with data transformation frameworks such as dbt, Dataform, or equivalent technologies.
- Knowledge of Git, version control, code reviews, and collaborative software development practices.
- Familiarity with data-quality checks, automated testing, monitoring, or reconciliation processes.
- Strong debugging and problem-solving skills, including the ability to investigate issues in inherited or imperfectly documented systems.
- Experience working with Finance, Accounting, Revenue Accounting, month-end close, or audit-related data.
- Ability to communicate technical concepts clearly to non-technical stakeholders, collaborate with engineering colleagues, and independently progress defined technical problems while seeking guidance when appropriate.
- Openness to learning and responsibly using AI-supported tools to improve SQL development, documentation, debugging, testing, and workflow efficiency, while maintaining appropriate data security and validation practices.
Nice to have
- Familiarity with financial controls, reconciliation, general-ledger concepts, or revenue recognition.
- Experience in gaming, digital products, app-store revenue, or virtual economies.
- Experience with data lineage, CI/CD, observability, or data governance practices.
- Experience working with GCP, Airflow, Cloud Composer, or Looker.
- Experience modernizing legacy SQL pipelines or stored-procedure-heavy environments.
- Familiarity with orchestration tools for scheduling, dependency management, monitoring, and recovery.
- Experience supporting business-critical workflows with defined service-level agreements (SLAs).
- Working knowledge of Python or another programming language used for automation and data workflows.
- Experience using or integrating agentic workflows in Finance processes.
We offer
- This is a hybrid position based in Barcelona, Spain, working three days per week from the company hub.
Hiring process
- Please ensure that the résumé/CV you attach is written in English.