
Junior BI Analyst
inChurch
full-time
Posted on:
Location Type: Hybrid
Location: Rio de Janeiro • 🇧🇷 Brazil
Visit company websiteJob 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