Senior Data & Analytics Engineer
MG PropertiesSan Diego, California, United States · Posted 2 days agoDescription
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.
About the Role
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.
What You’ll Do
- 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.
What You’ll Bring
- Eight or more years of experience in data, analytics, or business intelligence, with progressively increasing responsibility and direct ownership of an enterprise platform.
- Hands-on experience with Microsoft Fabric, including lakehouses, OneLake, semantic models, SQL Analytics endpoints, and Direct Lake mode.
- Advanced Power BI experience, including semantic model development, workspace and tenant governance, row-level security, and enterprise dashboard delivery.
- Experience administering capacity and environments, including utilization monitoring, refresh management, access control, performance troubleshooting, and workspace lifecycles.
- Proficiency in SQL, DAX, and Power Query.
- Demonstrated experience replacing manual, Excel-based reporting with governed solutions that users successfully adopted.
- Ability to communicate effectively with senior stakeholders and translate business needs into clear technical solutions.
- Comfort independently owning a platform, establishing standards, and making architectural decisions.
- Strong judgment regarding when to build internally, involve an external partner, or recommend an alternative approach.
Preferred Qualifications
- Microsoft certifications in data, analytics, or the Power Platform.
- Knowledge of ELT concepts and medallion lakehouse architecture.
- Experience with Power Apps and Power Automate.
- Experience building AI-enabled or natural-language querying capabilities over a data platform.
- Background in real estate, property management, or another operations-focused industry.
- Experience with Yardi Voyager or a comparable property management platform.
- Experience mentoring others or expanding analytics capabilities across an organization.
Compensation and Benefits
- $140k-$155k DOE
- Company profit sharing
- Accrues 10 days Paid time off per year
- 10 Paid Holidays and 2 Paid Personal Days per year
- 40 Hours of Paid Sick Time
- 401K with employer match
- Medical, Dental, Vision, Employee Assistance Program
- Life Insurance
- Flexible Spending Account, Dependent Care Spending Account
MG Properties is proud to be an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We are a drug-free workplace, participate in E-Verify, and are an at-will employer. If identified for a position, you will be asked to submit to a background check and drug-screen.
View our CCPA Policy HERE
Similar jobs
Est. 75,500 USD
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 prope…
Est. 150,000 USD
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 prope…
Est. 45,840 USD
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 prope…
Est. 82,500 USD
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 prope…
Est. 80,000 USD
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 prope…
Est. 57,600 USD
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 prope…
Est. 45,920 USD
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 prope…
Est. 44,800 USD
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 prope…
Est. 62,400 USD
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 prope…
Est. 44,880 USD
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 prope…
Est. 54,720 USD
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 prope…
Est. 80,640 USD
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 prope…
Est. 60,000 USD
The Real Estate Property Accounting Analyst plays a critical role in supporting accurate, timely, and consistent asset-level financial reporting across the portfolio. This position serves as a bridge between property acc…
Est. 57,600 USD
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 prope…
Est. 85,000 USD
Are you looking for an opportunity to work on a highly collaborative team where partnership drives performance? Berkadia’s investment sales platform offers the highest-quality deal marketing resources, technology that ma…
Est. 85,000 USD
Are you looking for an opportunity to work on a highly collaborative team where partnership drives performance? Berkadia’s investment sales platform offers the highest-quality deal marketing resources, technology that ma…
Est. 44,840 USD
About MidPen At MidPen, we build communities that change lives. Since 1970, we have been committed to our mission: to provide safe, affordable housing of high quality to those in need; establish stability and opportunity…
Est. 35,000 USD
Are you looking for an opportunity to define your future in the commercial real estate industry based on your own unique skills and experience? The Senior Administrative Assistant plays a crucial role in supporting execu…
Est. 62,400 USD
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 prope…
Est. 54,160 USD
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 prope…
Est. 62,400 USD
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 prope…
Est. 45,840 USD
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 prope…
Est. 118,000 USD
At Cortland, we operate with a forward-thinking approach that challenges conventional norms and actively seeks insights beyond traditional industry boundaries. As a recognized leader in the multifamily sector, our focus…
Est. 69,360 USD
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 prope…
Est. 84,832 USD
About MidPen At MidPen, we build communities that change lives. Since 1970, we have been committed to our mission: to provide safe, affordable housing of high quality to those in need; establish stability and opportunity…
Est. 80,000 USD
Company Overview Asset Living is a third-party management firm with a proven partner in fostering thriving communities nationwide. Founded in 1986, Asset Living has decades of experience delivering exceptional value to o…
Est. 90,000 USD
Are you looking for an opportunity to work on a highly collaborative team where partnership drives performance? Berkadia’s investment sales platform offers the highest-quality deal marketing resources, technology that ma…
Est. 80,000 USD
About MidPen At MidPen, we build communities that change lives. Since 1970, we have been committed to our mission: to provide safe, affordable housing of high quality to those in need; establish stability and opportunity…
Est. 85,000 USD
About MidPen At MidPen, we build communities that change lives. Since 1970, we have been committed to our mission: to provide safe, affordable housing of high quality to those in need; establish stability and opportunity…
Est. 44,840 USD
About MidPen At MidPen, we build communities that change lives. Since 1970, we have been committed to our mission: to provide safe, affordable housing of high quality to those in need; establish stability and opportunity…