inChurch

Junior BI Analyst

inChurch

full-time

Posted on:

Location Type: Hybrid

Location: Rio de Janeiro • 🇧🇷 Brazil

Visit company website
AI Apply
Apply

Job Level

Junior

Tech Stack

PythonSQL

About the role

  • Serve as the technical owner of financial workflow automation (n8n) and the data layer for dashboards and KPIs, ensuring reliability, traceability, and scalability.
  • Design, implement, and maintain mission-critical n8n workflows (integrations, queues, reprocessing, idempotency, version control).
  • Integrate data sources (APIs, databases, spreadsheets, internal tools) and ensure data quality (validations, reconciliation, audit trail).
  • Build SQL queries and pipelines for analytical stores and controls (views, support tables, aggregations).
  • Use Python where appropriate (data processing, connectors, validations, automations outside n8n).
  • Develop dashboards in Power BI (modeling, DAX, incremental refresh, publishing, KPI governance).
  • Define and maintain operational Finance KPIs (e.g., DSO, aging, delinquency, collections, reconciliation, close accuracy, workflow performance).
  • Implement monitoring: alerts, logs, metrics, health dashboards for workflows (SLAs, failures, bottlenecks).

Requirements

  • Previous practical experience in BI/Analytics/Automation (even if brief but hands-on).
  • n8n, Power BI, Python, Excel, and SQL (all required).
  • Solid database fundamentals: modeling, integrity, reconciliation, basic query performance.
  • Hands-on approach to support Finance tasks (AR/AP/Financial close/Collections/Receivables).

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
n8nPythonSQLDAXdata processingdata qualityworkflow automationdatabase modelingdata validationdata reconciliation
Soft skills
hands-on approachproblem-solvingattention to detailorganizational skillscommunication skills