Ventas, Inc. is seeking a Manager, Reporting & Analytics to lead their reporting and analytics initiatives, enhance reporting and analytics capabilities, and promote a culture of analytical excellence and self-service data access.
Requirements
- Proficiency in PowerBI, including DAX and Power Query
- Strong understanding of data modeling using tabular and multi-dimensional models, ETL processes, and data warehousing concepts
- Experience with T-SQL, MDX, and relational databases
- Knowledge of AnaplanXL and other BI tools and/or platforms is a plus
- 8-10 years of experience in developing reporting solutions and dashboards
- 3-5 years of experience in leading reporting and analytics teams
- Excellent analytical and problem-solving skills with the ability to interpret complex data sets
Responsibilities
- Lead the reporting & analytics team to design, create, and maintain interactive, user-friendly dashboards and reports to provide actionable insights
- Design and manage data models, including relationships, hierarchies, and measures to ensure data integrity and optimal performance
- Extract, Transform, and Load (ETL) data from various sources into reporting models. This includes working with databases, multi-dimensional models, spreadsheets, and other data storage solutions.
- Analyze complex datasets to identify trends, patterns, and insights that can support decision-making processes
- Interact with business stakeholders, data analysts, and other IT team members to understand requirements and deliver solutions that meet business needs
- Define governance approaches and act as a business and/or technical expert to attain objectives, including gateway setups, capacity & license planning, optimization, etc.
- Continuously monitor and improve BI solutions for performance, usability, and reliability
Other
- Execute on a business intelligence strategy aligned with Ventas’s strategic goals.
- Advocate for the effective use of BI tools in decision-making and promote adoption across departments.
- Coach functional power users to be able to derive the full value of reporting solutions
- Mentor and manage reporting portfolio and workload for other BI developers
- Create and maintain comprehensive documentation for BI reports, data models, and processes
