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

About the role

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.

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.

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

Qualifications

• Experience with Alteryx, Python, or Snowflake (plus, but not required)
• Experience with Yardi (plus)

Benefits

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

Pay

Competitive Base Salary + Annual Bonus