Lument · 9 hours ago
Business Systems Analyst
Columbus, OH
Full-time
Hybrid
Mid Level
$110K/yr - $130K/yr
3+ years expLument is focused on improving efficiency in finance processes by developing and implementing technology solutions. The Business Systems Analyst will manage projects for new technology solutions, gather and analyze business challenges, and enhance existing applications to optimize the FP&A function.
Commercial Real EstateFinanceReal Estate
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
Qualification
Required
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
Preferred
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
Benefits
Cash bonuses
Long term incentives
Health insurance
Accident and life insurance
Retirement benefits
Competitive vacation policy
Floating personal holidays
Extensive leave options
Annual observed holidays
Infertility coverage
Adoption support
Child and elder care
Fully paid maternity
Generous parental leave benefits
Hybrid working model
Company
Lument
Lument offers custom capital solutions for investors in the multifamily, affordable housing, healthcare and commercial real estate sector.
501-1000 employees
H1B Sponsorship
Lument has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2022 (1)
Funding
Current Stage
Late StageTotal Funding
$160.3MKey Investors
Steve McGee
2022-02-01Debt Financing· $115M
2021-03-18Debt Financing· $33M
2021-03-17Debt Financing· $12.3M
Leadership Team
James P. (Jim) Flynn
Chief Executive Officer
Robert (Bob) Kirkwood
Chief Financial Officer
Recent News
2025-09-04
2025-04-21
2025-01-16
Company data provided by crunchbase