Job description

WELLTOWER – REIMAGINE REAL ESTATE WITH US At Welltower, we’re transforming how the world thinks about senior living and wellness-focused real estate. As a global leader in residential wellness and healthcare infrastructure, we create vibrant, purpose-driven communities where housing, healthcare, and hospitality converge. Our culture is fast-paced, collaborative, and endlessly ambitious—guided by our mantra: The only easy day was yesterday. We’re looking for bold, independent thinkers who thrive on challenge, embrace complexity, and are driven to deliver long-term value. Every team member is empowered to think like an owner, innovate fearlessly, and lead from where they stand. If you're passionate about outcomes and inspired by the opportunity to shape the future of healthcare infrastructure, we want you on our best-in-class team. JOB SUMMARY The primary responsibility of this role is assisting the team in monitoring and analyzing master data within the organization, building the reporting that surfaces that data, and driving efficiencies through automation within the Accounting department. This role sits at the intersection of accounting and technology and partners daily with Accounting, FP&A, Tax, IT, and Software Engineering. KEY RESPONSIBILITIES • Ensure master data integrity in key systems as well as maintaining the processes to support the data quality. • Ensure quality of master data in key systems, as well as development and documentation of processes with other functional data owners to support ongoing maintenance and data integrity. • Gain and maintain proficiency and expertise in relevant financial and accounting systems with ability to ensure data alignment and consistency, review in detail, drive process changes, and communicate to the different groups in the appropriate vernacular. • Assist in the day-to-day administration of multiple financial systems including Yardi, Blackline and Alteryx Server. • Incorporate additional subledger modules from Yardi into Blackline • Perform requirements gathering, analysis, implementation, testing and deployment of ETL processes and scripts. • Write, optimize, and troubleshoot SQL against Yardi and other enterprise financial databases to support reporting, reconciliations, data validation, and ETL, including complex multi-table joins, CTEs, window functions, and stored procedures. • Provide timely and effective technical support to internal customers to troubleshoot system issues and minimize downtime for the end user. Assist with data/problem/issue resolution, process improvement and resolving root causes for end user issues. • Identify and implement opportunities for process improvement, including determining ways to automate financial reports from accounting systems. • Build and maintain SQL-based reports and interactive dashboards in Sigma and Power BI, and support the migration of existing reporting and workflows off Alteryx as we are retiring the use of the platform. • Partner closely with Accounting, FP&A, Tax, IT, and Software Engineering to gather reporting requirements, translate them into technical solutions, and communicate results to both technical and non-technical audiences. OTHER DUTIES Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of this employee for this job. Duties, responsibilities, and activities may change at any time with or without notice. TRAVEL Limited travel is expected for this role MINIMUM REQUIREMENTS • Bachelor’s degree in Accounting/Finance/Information Systems/Data Management/Computer Science • 3-5 years work experience • Proven ability to manage and gather data across multiple systems and data sets • Proficient with Microsoft SQL Server — able to independently write and troubleshoot complex SQL (multi-table joins, CTEs, aggregation, window functions) against large transactional datasets • Alteryx, Python, Snowflake is a plus, but not required • Experience with Yardi is a plus • Intellectual curiosity towards learning business processes and implementing efficiencies • Strong communication – presentation, written, and verbal • Strong team player with a focus towards customer service • Strong attention to detail • Ability to self-motivate and work in a dynamic environment • Ability to work independently • A positive and professional attitude • Willingness travel to Toledo office periodically (if not located in Toledo) Employment is contingent upon the successful completion of a background check, drug screening, and verification of employment, education, and other credentials relevant to the position. WHAT WE OFFER • Competitive Base Salary + Annual Bonus • Generous Paid Time Off and Holidays • Employee Stock Purchase Program – purchase shares at a 15% discount • Employer-matching 401(k) Program + Profit Sharing Program • Student Debt Program – we’ll contribute up to $10,000 towards your student loans! • Tuition Assistance Program • Comprehensive and progressive Medical/Dental/Vision options • Professional Growth • And much more! welltower.com ABOUT WELLTOWER Welltower® Inc. (NYSE: WELL) an S&P 500 company, is the world's preeminent residential wellness and healthcare infrastructure company. Our portfolio of 1,500+ Seniors and Wellness Housing communities is positioned at the intersection of housing, healthcare, and hospitality, creating vibrant communities for mature renters and older adults in the United States, United Kingdom, and Canada. We also seek to support physicians in our Outpatient Medical buildings with the critical infrastructure needed to deliver quality care. Our real estate portfolio is unmatched, located in highly attractive micro-markets with stunning built environments. Yet, we are an unusual real estate organization as we view ourselves as a product company in a real estate wrapper driven by relationships and unconventional culture. Through our disciplined approach to capital allocation powered by our data science platform and superior operating results driven by the Welltower Business System, we aspire to deliver long-term compounding of per share growth and returns for our existing investors – our North Star. Welltower is committed to leveraging the talent of a diverse workforce to create great opportunities for our business and our people. EOE/AA. Minority/Female/Sexual Orientation/Gender Identity/Disability/Vet

Requirements

Must-haves

Ensure master data integrity in key systems as well as maintaining the processes to support the data quality.
Ensure quality of master data in key systems, as well as development and documentation of processes with other functional data owners to support ongoing maintenance and data integrity.
Assist in the day-to-day administration of multiple financial systems including Yardi, Blackline and Alteryx Server.
Incorporate additional subledger modules from Yardi into Blackline
Perform requirements gathering, analysis, implementation, testing and deployment of ETL processes and scripts.
Identify and implement opportunities for process improvement, including determining ways to automate financial reports from accounting systems.
Build and maintain SQL-based reports and interactive dashboards in Sigma and Power BI, and support the migration of existing reporting and workflows off Alteryx as we are retiring the use of the platform.
Partner closely with Accounting, FP&A, Tax, IT, and Software Engineering to gather reporting requirements, translate them into technical solutions, and communicate results to both technical and non-technical audiences.
Limited travel is expected for this role
Bachelor’s degree in Accounting/Finance/Information Systems/Data Management/Computer Science
3-5 years work experience
Proven ability to manage and gather data across multiple systems and data sets
Proficient with Microsoft SQL Server — able to independently write and troubleshoot complex SQL (multi-table joins, CTEs, aggregation, window functions) against large transactional datasets
Intellectual curiosity towards learning business processes and implementing efficiencies
Strong communication – presentation, written, and verbal
Strong team player with a focus towards customer service
Strong attention to detail
Ability to self-motivate and work in a dynamic environment
Ability to work independently
A positive and professional attitude
Willingness travel to Toledo office periodically (if not located in Toledo)
Employment is contingent upon the successful completion of a background check, drug screening, and verification of employment, education, and other credentials relevant to the position.

Nice-to-haves

Alteryx, Python, Snowflake is a plus, but not required
Experience with Yardi is a plus

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlpython

Platform: ukg
Effort: medium

Benefits

Benefits detected in the listing.

Dental

Vision

401(K)

Paid Time Off

Wellness