Data Analyst

in Information Technology
  • New York, New York View on Map
  • Salary: $100,000.00 - $120,000.00
Permanent

Job Detail

  • Experience Level Mid Level
  • Degree Type Bachelor of Science (BS)
  • Employment Full Time
  • Working Type On Site
  • Job Reference 0000022794
  • Salary Type Annually
  • Industry Financial Services;Private Equity
  • Selling Points

    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.

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:

Related Jobs

  • Lead impactful technology modernization initiatives in a dynamic family office environment. Drive cybersecurity enhancements and operational efficiency through innovative strategies. Collaborate with executives to deliver high-touch technology solutions.