The Mortgage Warehouse Lending Data Analyst will support BankUnited's Warehouse Lending Group by turning data into reliable reporting, dashboards, and analytics that help monitor portfolios and guide business decisions. This onsite role in Melville, NY focuses on scalable reporting automation, performance metrics, and process improvements that reduce manual effort.
What you'll do
- Design, develop, automate, and maintain recurring reports, dashboards, and management information packages.
- Extract, validate, transform, and analyze data from multiple internal and external sources to support business decisions.
- Create analytical models, reporting tools, and performance metrics to improve operational efficiency and reduce manual processes.
- Build dashboards and visualizations using Power BI, Tableau, or similar business intelligence platforms.
- Find opportunities to streamline workflows through automation, advanced analytics, artificial intelligence, and other emerging technologies.
- Produce management reports, portfolio analytics, and presentation materials for senior leadership and committee meetings, including analysis of key insights and trends.
- Partner with business stakeholders to understand reporting needs and deliver scalable data and analytics solutions.
- Support the development of AI-powered tools, intelligent agents, automated workflows, and other technology solutions to enhance reporting and decision-making.
- Document data sources, reporting processes, methodologies, and procedures to support consistency and data integrity.
- Monitor industry trends and emerging technologies, and recommend innovations to strengthen business processes and analytical capabilities.
- Follow applicable federal and state laws, regulations, and guidance, including requirements related to anti-money laundering (Bank Secrecy Act, US PATRIOT Act, etc.).
- Adhere to Bank policies and procedures and complete required training.
- Identify and report suspicious activity.
Requirements
- Bachelor's degree in Computer Science, Data Analytics, Information Systems, Engineering, Mathematics, Statistics, Economics, Finance, or a related field (equivalent education and relevant experience will be considered).
- Strong analytical, quantitative, and problem-solving skills.
- Ability to translate complex data into actionable business insights and recommendations.
- Strong verbal and written communication skills, including the ability to prepare reports, presentations, and executive-level summaries.
- Ability to manage multiple priorities in a fast-paced environment.
- Curiosity and willingness to learn new technologies, tools, and business processes.
- Demonstrated interest in data analytics, automation, artificial intelligence, and process improvement.
- Ability to collaborate across business, technology, and operational teams.
- Self-motivated with a continuous improvement mindset and attention to detail.
- Python (Pandas, NumPy, data visualization, automation, and data analysis libraries) and SQL.
- Power BI, Tableau, or similar business intelligence and data visualization tools.
- Advanced Microsoft Excel, including Power Query, data modeling, and complex data analysis.
- Power Automate, VBA, or other process automation tools.
Technologies
- Python, Pandas, NumPy
- Power BI, Tableau
- Microsoft Excel, Power Query
- Power Automate, VBA
- SQL
- AWS, Power Apps, SharePoint
- Large language models (LLMs), intelligent agents, AI-enabled workflow solutions
Compensation and location
- Location: Melville, NY (onsite)
- Salary: USD 85,000 to 95,000 per year
Career development opportunities
- Gain exposure to mortgage warehouse lending operations and portfolio management.
- Participate in customer diligence meetings and management discussions.
- Develop knowledge of financial statement analysis and counterparty risk assessment.
- Support portfolio monitoring and risk measurement and management activities.
- Progress into more advanced analytical, risk management, and underwriting responsibilities.
Experience
- 3 years extracting, transforming, validating, and analyzing data from multiple internal and external sources.
- 3 years developing automated reports, dashboards, analytical models, and business intelligence solutions.
- 3 years identifying and implementing opportunities to streamline workflows and improve operational efficiency through automation and technology.
- Familiarity with AI tools, large language models (LLMs), intelligent agents, or AI-enabled workflow solutions is preferred.
- Familiarity with AWS, Power Apps, SharePoint, or other data management and workflow platforms is preferred.
Additional information: Candidates residing in locations within BankUnited's footprint may be given preference.