inChurch

Analyst

• 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).

Junior BI Analyst