Senior Data & Analytics Engineer

About the role

With over 30 years of experience in the acquisition, development, rehabilitation, and management of apartment communities across the Western United States, we are a trusted partner in the real estate investment and property management industry. At MG Properties, we focus on enriching lives – physically in our community buildings, philanthropically through giving back to our local communities, and through development and growth of our employees.

MG Properties is seeking a Senior Data & Analytics Engineer to lead the development and long-term ownership of our enterprise data and analytics platform. This senior individual contributor will manage everything downstream of data delivery, including the Microsoft Fabric environment, lakehouse, semantic models, reporting, governance, access controls, and AI-enabled analytics. This is an opportunity for an experienced data and analytics professional to build a modern, governed platform that transforms how teams access information, make decisions, and use data across the organization. This position is primarily onsite, with the potential for a hybrid work schedule based on business needs.

Responsibilities

• Own and administer the Microsoft Fabric environment, including lakehouses, OneLake storage, workspaces, SQL Analytics endpoints, capacity, performance, refresh operations, and access controls.
• Design, build, and maintain scalable semantic models, Power BI reports, and dashboards for finance, investor relations, investments, and operations.
• Lead the migration of existing Yardi-native Power BI reporting to the new Microsoft Fabric platform.
• Replace manual, Excel-driven reporting with governed and scalable solutions.
• Establish consistent definitions, reporting standards, and trusted data sources across the organization.
• Partner with department leaders to understand business needs and translate them into a prioritized analytics roadmap.
• Establish governance standards for data access, row-level security, workspace administration, report lifecycles, lineage, and content certification.
• Build AI-enabled analytics, natural-language querying, and data agents in partnership with the Director of IT.
• Evaluate and implement Microsoft Copilot capabilities and custom agents where they provide meaningful business value.
• Create documentation, guides, and training to support business users and responsible self-service analytics.
• Serve as the primary escalation point for data and AI initiatives across departments.
• Expand the platform over time to incorporate SharePoint, operational systems, and other data sources.