Data Engineer

PALISADES OVERVIEW:

Palisades Group is an alternative asset manager in the global residential credit markets having managed more than $35.8 billion of loans, real estate, and fixed income securities since its 2012 inception. It employs a top-down asset allocation approach across residential whole loans, real estate, opportunistic credit, and fixed income markets in the United States, Europe, and Latin America. The Firm provides clients with a control-oriented management style anchored in asset level risk management, loss mitigation, and value-add strategies.

As of June 30, 2024, Palisades manages mortgage, real estate and fixed income assets that amount to over $18.2 billion in notional balance through a series of separate accounts and discretionary investment funds for globally recognized asset managers, private equity, family office, bank, broker dealer and insurance companies.

Palisades offers individuals an exciting and challenging career in a collegial and collaborative environment. We aim to recruit and retain talented individuals who have demonstrated integrity and intellectual curiosity. We seek individuals who are willing to speak up, constantly striving to improve processes, genuinely excited to tackle complex challenges, technically proficient, transparent, collaborative, highly organized, capable of managing multiple tasks simultaneously, detail-oriented with a focus on both form and substance and driven to fulfilling their commitments.

POSITION SUMMARY:

Palisades is seeking a Data Engineer to join its growing and dynamic team.

As part of the Data Management & Business Intelligence Team, your core responsibilities will include managing and enhancing the in-house enterprise data warehouse, creating data pipelines for 3rd party data providers, troubleshooting the daily data warehouse loading processes, recommending new methods to improve data integration processes and overall data warehouse operations, and building out comprehensive data surveillance tools.

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 work collaboratively 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. 

ESSENTIAL DUTIES:

• Managing and enhancing the Palisades SQL Server based mortgage data warehouse.

• Creating and maintaining ETL/SSIS packages along with APIs to bring data from mortgage servicers and vendors into the data warehouse.

• Working closely with the business teams to transform complex business rules into technical specifications.

• Monitoring the daily/month end data warehouse loading processes, promptly resolving issues.

• Helping with the performance tuning of SQL Server and the data warehouse.

• Helping with data reconciliation of various sources and conforming them in data marts.

• Contributing to defining SSAS Tabular Mode/cubes to serve various reporting needs.

• Documentation of data logic, methods, key data sets, data flows and processes.

EXPERIENCE, QUALIFICATIONS, AND SKILLS:

• Education: Bachelor's degree in Computer Science or related field.

• Experience: 0-3 years of experience with SQL, Data warehouses, SSIS, SQL Server, cloud databases, and Python.

• Knowledge of Data Warehouses and a good understanding of Kimball and Inmon data warehouse methodologies.

• Experience designing, implementing, and optimizing data marts, and star schemas.

• Ability to create and manage large ETL jobs.

• Ability to quickly troubleshoot and resolve any issues with ETL/SSIS packages.

• Experience with big data sets, knowledge of tuning and optimizing large table/data set performances.

• Ability to work with business teams to transform definitions/rules into technical specifications.

• Excellent written and verbal communication skills.

• Knowledge and experience with visualization tools and large analytical tools such as Cubes is a plus.

BENEFITS:

• Medical, dental, and vision insurance

• 401(k) retirement plan matching

• Charitable giving employee matching program

• Continuing education and professional certification expense reimbursement

• Wellness stipend (monthly)

• 13 paid holidays

• 3 weeks of PTO

• Friday hours

• Summer Friday hours

• Friday team lunches

Palisades is committed to maintaining a positive and collaborative work environment that is safe and respectful of others; our shared success depends on it. Accordingly, we do not tolerate workplace discrimination, violence, or harassment.

We are proud to create a diverse environment and are proud to be an equal opportunity employer.

Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.