Data Reporting Analyst
The Palisades Group, LLC (“Company”), an Austin-based investment firm, is looking for a Data Reporting Analyst to join its growing and dynamic team. As part of the Data & Analytics team, your responsibilities will include managing and enhancing the in-house mortgage loan database, creating performance and investor reports and dashboards, implementing data management protocols and systems, and writing queries to generate ad-hoc reports for research as needed. Analysts must be proficient at manipulating and analyzing large sets of data and have a good knowledge of fixed income mathematics and statistics. This is a small team and any candidate must be a team-player, able and willing to work on cross-over projects, able to pick up complex concepts and communicate effectively to both internal and external constituents. The position will allow the candidate to collaboratively work across the Company’s cross-functional teams (Data Research & Reporting, Trading & Analytics, Asset Management, Capital Markets, Transaction Management, and Collateral Management) and to learn from the firm’s industry leading professionals. The ideal candidate will be intellectually curious, a self-starter, have a strong attention to detail, and be able to work under time sensitive deadlines.
As of December 31, 2021, Palisades manages mortgage, real estate and fixed income assets that amount to over $5.3 billion in notional balance through a combination of discretionary funds and separate accounts for globally recognized asset managers, private equity, family office, bank, broker dealer and insurance companies.
• Learning and maintaining proprietary mortgage database in Microsoft SQL.
• Working with application development personnel to enhance and streamline quantitative tools.
• Support Trading & Analytics personnel to ensure essential data is captured, analyzed, and curated for broader consumption.
• Running analyses using in house software tools and models.
• Creating and managing data pipelines, data dashboards, and reports for our investors and advisory clients.
• Delivering high quality, accurate technical reports based on thorough analysis of data pipelines and portfolios.
• Effectively manage relationships clients and data counterparts.
• Support development of analysis methods and tools to improve productivity.
• Any ad hoc analysis that may be requested.
• Strong knowledge of Excel/VBA; working knowledge of SQL, and proven track record of learning new programming techniques to analyze and manage data.
• Experience using BI tools and building dynamic reporting dashboard (Tableau, superset, etc.)
• Working knowledge of Python is a plus.
• Exceptional verbal, written and interpersonal communication skills with the ability to apply common sense to carry out instructions and instruct others, train personnel, write reports, correspondence and procedures, speak clearly to customers and employees.
• Ability to deal with advanced problems involving multiple facets and variables in standardized or specialty situations.
• Excellent written and verbal communication skills are required.
Education: Bachelor's degree from a top undergraduate program.
Experience: 4-6 years of experience with data analytics.