Overview
We are seeking a Data Analyst to join a dynamic market data initiative focused on real estate analytics. This role offers the opportunity to take ownership of data products in a startup-like environment, where you will collaborate with various teams and utilize advanced tools to shape data strategy and visualization. As a key contributor, you will help improve data workflows and dashboards essential for business insights and decision-making.
Responsibilities
- Manage the ingestion and transformation of Excel-based datasets using SharePoint and Power BI dataflows.
- Ensure consistency in formatting, templates, and field definitions across multiple data sources.
- Identify inefficiencies and implement process improvements to enhance operational efficiency.
- Monitor data quality, resolve errors, and develop dashboards to uphold data accuracy and governance.
- Build and maintain data transformation logic utilizing Power Query and SQL.
- Collaborate with engineering teams and external data providers to address discrepancies and integration challenges.
- Support the creation of actionable Power BI dashboards for strategic insights and decision-making.
Requirements
- Strong experience with Excel, Power Query, SQL, and Power BI.
- Knowledge of ETL processes, data modeling, and multi-layered architecture.
- Familiarity with real estate data structures and data warehouse environments.
- Experience with SharePoint is essential; GIS knowledge is a plus.
- Detail-oriented with strong problem-solving skills and effective communication abilities.
- Passion for maintaining data integrity and quality.