Data Analyst

High Trail; King of Prussia (PA); On-site; USD 75,000 - 90,000; Full time

Job summary

A leading organization in real estate investment is seeking a Data Analyst to join their IT team in King of Prussia, Pennsylvania. The ideal candidate will be responsible for building and maintaining data warehouses, developing insightful dashboards using Power BI, and leveraging SQL for data analysis. A Bachelor's degree in a related field and 3+ years of relevant experience are essential. This role demands strong analytical skills and familiarity with Azure technologies.

Qualifications

• 3+ years of experience in data analysis and visualization.
• Strong experience with Power BI and advanced SQL skills.
• Familiarity with Azure environments preferred.

Responsibilities

• Build and maintain data warehouses and reporting solutions.
• Develop dashboards and ad hoc reports using Power BI.
• Write and optimize SQL queries for data extraction and analysis.

Skills

Data analysis

Visualization

SQL skills

Power BI

Analytical skills

Education

Bachelor’s degree in Computer Science, Statistics, Mathematics, or related field

Tools

Power BI

SQL Server

SSRS

SSIS

Excel

Power Query

Power Pivot

Microsoft Fabric

Azure

Azure DevOps Git

Job description

Our client, a leading organization in the real estate investment and property management sector, is seeking a Data Analyst to join their IT team. This role will focus on building and maintaining data solutions, developing dashboards, and delivering actionable insights to support business decision-making across the organization.

Responsibilities

• Build and maintain data warehouses and reporting solutions
• Develop dashboards and ad hoc reports using Power BI
• Write and optimize SQL queries for data extraction and analysis
• Partner with stakeholders to gather and translate reporting requirements
• Troubleshoot and resolve data and reporting issues
• Support internal users with reporting tools and best practices
• Contribute to data governance and process improvements
• Stay current with Microsoft Fabric, Azure, and related technologies

Qualifications

• Bachelor’s degree in Computer Science, Statistics, Mathematics, or related field
• 3+ years of experience in data analysis and visualization
• Strong experience with Power BI
• Advanced SQL skills
• Experience with SQL Server, SSRS, SSIS, Excel, Power Query, and Power Pivot
• Experience with Microsoft Fabric preferred
• Familiarity with Azure environments preferred
• Experience with Azure DevOps Git is a plus
• Strong analytical, problem-solving, and communication skills