Drive impactful data analysis and reporting for asset-based finance operations. Collaborate with cross-functional teams to resolve discrepancies and enhance data pipelines. Develop expertise in SQL and dbt systems.
Data Analyst
in Information Technology PermanentJob Detail
Job Description
Data Analyst Overview
- The Data Analyst role focuses on ensuring the accuracy and integrity of collateral data for asset-based finance operations.
- Collaborate with cross-functional teams to resolve data discrepancies and enhance reporting pipelines.
- Utilize SQL and dbt pipelines to produce borrowing base reports and onboard new deals.
- Conduct root-cause analysis to trace and resolve data inconsistencies effectively.
- Prepare and deliver reporting to internal and external stakeholders, ensuring compliance with lending facility requirements.
- Document data sources, reconciliation procedures, and known issues for team reference.
- Develop proficiency in dbt pipelines and Snowflake queries to support data validation and reporting.
- Contribute to the improvement of data controls and recurring checks to enhance operational efficiency.
Data Analyst Key Responsibilities & Duties
- Reconcile weekly borrowing base reports and loan-level data against counterparty reports.
- Validate weekly loan-level position and transaction files, addressing inconsistencies and anomalies.
- Investigate discrepancies in data files, balances, or eligibility results to identify root causes.
- Write and maintain SQL queries to support reconciliations and recurring analysis tasks.
- Run and enhance dbt pipelines for borrowing base and external reporting requirements.
- Collaborate with stakeholders to resolve data issues and provide analytical support.
- Prepare and deliver required reporting for lending facilities and external parties.
- Document reconciliation procedures and known issues for team knowledge sharing.
Data Analyst Job Requirements
- Bachelor's degree in Data Science, Information Systems, Finance, Mathematics, or related field.
- 2-4 years of experience in data analytics, finance, or operations roles.
- Proficiency in SQL, including joins, aggregations, and window functions.
- Strong Excel skills, including pivot tables and clean workbook creation.
- Experience reconciling data sources and identifying discrepancies.
- Familiarity with dbt pipelines, Snowflake, and Python for data analysis preferred.
- Exceptional attention to detail and problem-solving skills.
- Clear communication skills to explain findings to non-technical stakeholders.
- ShareAustin:
