Business Systems Analyst

Lument Real Estate Capital•Dallas, NY

4d•$110,000 - $130,000•Hybrid

About The Position

Purpose and Job Summary: Improve efficiency to existing processes by developing and implementing technology solutions. Currently, many finance processes are manual. With significant improvements in technology across Lument, this role will leverage the progress made in other areas of the firm to improve the accuracy and efficiency of the FP&A function. FP&A can focus on analysis instead of manual processes that take up valuable time. Essential Duties and Responsibilities: Project manager for new technology solutions and product manager post implementation. Gather and analyze business challenges and goals to identify and implement technology solutions. Work with stakeholders to design and configure new systems and enhance existing applications to meet evolving business requirements. Oversee and conduct testing to ensure new systems are working correctly. Troubleshoot system issues and develop enhancements to improve efficiency and performance and provide support to end users. Design and build data warehouses. Design and build BI reporting dashboards. Support compensation planning and administration, including enhancement of third-party commission tool. Support ad-hoc and strategic projects. Maintain documentation regarding various processes and solutions. Serve as liaison between FP&A, business users, and technology teams across the organization. Staying up-to-date on the latest IT advancements to automate and modernize systems. Travel Requirements - 0%.

Requirements

Bachelor’s degree in Information Technology, or related field preferred.
Minimum 3-5 years of professional experience in a Business Systems Analyst role.
Experienced in Power BI solutions design, DAX, SQL Queries, SQL Server Reporting, SQL Integration Services and Excel Power Query and Power Pivot.
Proven ability to design and implement technology solutions that automate, streamline, and enhance financial reporting and business analysis.
Must be experienced with project management and leading technology projects from requirements gathering to implementation.
Hands-on experience with data preparation, data gateway and data warehousing projects.
Excellent communication skills.
Must have consistent high attention to detail.
Results driven individual who can operate with autonomy in leveraging data and problem-solving skills.
Able to work effectively under pressure and in a rapidly changing environment to meet deadlines.
A great attitude and strong work ethic.

Nice To Haves

CPA or MBA a plus
Knowledge of GAAP accounting and corporate finance concepts.
Experience in real estate and/or financial services sectors preferred.
Experience working with Oracle EPM and ERP software preferred.

Responsibilities

Project manager for new technology solutions and product manager post implementation.
Gather and analyze business challenges and goals to identify and implement technology solutions.
Work with stakeholders to design and configure new systems and enhance existing applications to meet evolving business requirements.
Oversee and conduct testing to ensure new systems are working correctly.
Troubleshoot system issues and develop enhancements to improve efficiency and performance and provide support to end users.
Design and build data warehouses.
Design and build BI reporting dashboards.
Support compensation planning and administration, including enhancement of third-party commission tool.
Support ad-hoc and strategic projects.
Maintain documentation regarding various processes and solutions.
Serve as liaison between FP&A, business users, and technology teams across the organization.
Staying up-to-date on the latest IT advancements to automate and modernize systems.