Youll serve as the bridge between operational data (ticketing sales inventory etc.) and financial reporting systems. Your job will be to ensure everything that happens in the business is accurately reflected in financethrough reconciliation models alerting systems and preventative data controls.
Key Responsibilities
- Data Modeling & Reconciliation: Build and maintain data pipelines that link operational systems to financial/accounting systems (GL ERP). Create reconciliation logic and define acceptable variances automating alerts for anomalies.
- Automated Testing: Develop SQL or Python-based tests to calculate data variances trigger alerts and generate audit-ready evidence. Build Power BI dashboards for exception monitoring and variance explanations.
- Marketing Data Validation: Ensure UTM tags pixels and campaign data correctly feed into revenue KPIs. Work with the marketing team to maintain proper naming conventions and tagging consistency.
- Data Contracts & Governance: Define data contracts with owners (schema nullability thresholds) and implement validation checks. Participate in root cause analyses (RCA) and update SOPs/tests accordingly.
- Cross-Team Collaboration: Join forces with finance operations and IT to resolve issues document flows and SOPs (in Confluence or similar) manage incidents (Jira/ServiceNow) and help business users adopt data quality best practices.
Core Technical Skills
- Strong experience with SQL (e.g. Snowflake or similar) and Python for automation and reconciliation tasks.
- Proficiency withPower BI (DAX / Power Query) or other BI tools to create dynamic dashboards and financial reports.
- Familiarity with digital tracking (GA4 GTM UTM tagging) and basic JavaScript debugging.
- Use of incident/ticketing tools like Jira or ServiceNow and documentation in Confluence or similar.
- Bonus: experience with data quality tools (DBT Talend Alteryx) financial systems (SAP Oracle) or data integration platforms (Fivetran SSIS).
Youll serve as the bridge between operational data (ticketing sales inventory etc.) and financial reporting systems. Your job will be to ensure everything that happens in the business is accurately reflected in financethrough reconciliation models alerting systems and preventative data controls.Key ...
Youll serve as the bridge between operational data (ticketing sales inventory etc.) and financial reporting systems. Your job will be to ensure everything that happens in the business is accurately reflected in financethrough reconciliation models alerting systems and preventative data controls.
Key Responsibilities
- Data Modeling & Reconciliation: Build and maintain data pipelines that link operational systems to financial/accounting systems (GL ERP). Create reconciliation logic and define acceptable variances automating alerts for anomalies.
- Automated Testing: Develop SQL or Python-based tests to calculate data variances trigger alerts and generate audit-ready evidence. Build Power BI dashboards for exception monitoring and variance explanations.
- Marketing Data Validation: Ensure UTM tags pixels and campaign data correctly feed into revenue KPIs. Work with the marketing team to maintain proper naming conventions and tagging consistency.
- Data Contracts & Governance: Define data contracts with owners (schema nullability thresholds) and implement validation checks. Participate in root cause analyses (RCA) and update SOPs/tests accordingly.
- Cross-Team Collaboration: Join forces with finance operations and IT to resolve issues document flows and SOPs (in Confluence or similar) manage incidents (Jira/ServiceNow) and help business users adopt data quality best practices.
Core Technical Skills
- Strong experience with SQL (e.g. Snowflake or similar) and Python for automation and reconciliation tasks.
- Proficiency withPower BI (DAX / Power Query) or other BI tools to create dynamic dashboards and financial reports.
- Familiarity with digital tracking (GA4 GTM UTM tagging) and basic JavaScript debugging.
- Use of incident/ticketing tools like Jira or ServiceNow and documentation in Confluence or similar.
- Bonus: experience with data quality tools (DBT Talend Alteryx) financial systems (SAP Oracle) or data integration platforms (Fivetran SSIS).
View more
View less