Senior Master Data Analyst - onsite Toledo, OH - Yardi experience preferred

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.  

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.

• →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.

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.

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
• 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.  

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