Data Analyst
Morgan Properties · Conshohocken, PA, US ·
- Category
- Data analytics
- Experience
- 3+ years
Morgan Properties · Conshohocken, PA, US ·
Position Summary
The Data Analyst plays a critical role in enabling data-driven decision-making across the organization by delivering trusted, scalable, and visually compelling business intelligence solutions. This position partners closely with business stakeholders, data teams, and functional leaders to translate complex reporting and analytics needs into accurate, well-governed, and actionable Power BI dashboards, reports, and datasets.
This role is responsible for designing and maintaining high-quality BI assets, applying strong data modeling and visualization best practices, and ensuring alignment with governance and security standards. Success in this position requires a detail-oriented, analytical, and collaborative mindset, with a strong focus on continuous improvement and usability. Through close cross-functional collaboration and technical expertise, this role supports the organization’s core mission of improving insight accessibility, consistency, and confidence in enterprise reporting.
Essential Duties
Power BI Development & Data Modeling
Design, build, and maintain Power BI dashboards, paginated reports, and reusable datasets that support business and operational needs.
Develop scalable, high-performing data models using DAX, Power Query (M), and Power BI best practices.
Apply visualization standards, accessibility principles, and data storytelling techniques to create clear and intuitive dashboards.
Develop and maintain reusable Power BI templates and standardized report layouts to promote consistency.
Data Analysis, Quality & Performance
Write, optimize, and maintain SQL queries to support reporting and analytical use cases.
Perform data validation, reconciliation, and quality checks to ensure accuracy and consistency across reports.
Troubleshoot report issues, data refresh failures, performance concerns, and access requests.
Identify opportunities to automate reporting processes and improve data accessibility and efficiency.
Governance, Security & Standards
Contribute to Power BI workspace management, dataset reuse strategies, and role-based security configurations.
Support governance alignment by maintaining metadata connections to datasets, data sources, and reporting tools.
Assist in documenting data definitions, business glossaries, KPI logic, and basic lineage relationships.
Support data quality rule configuration and validation under guidance from senior team members.
Business Partnership & Collaboration
Partner with business users to gather requirements, understand reporting needs, and identify gaps or enhancement opportunities.
Translate business requirements into clear technical specifications for Power BI solutions.
Participate in cross-functional initiatives requiring BI or analytics support.
Train and support internal users on Power BI dashboards and self-service analytics tools.
Documentation & Continuous Improvement
Document technical designs, data models, and report logic to support ongoing maintenance and knowledge sharing.
Stay current on Power BI enhancements, Microsoft Fabric capabilities, and analytics best practices.
Proactively recommend improvements to BI processes, standards, and reporting approaches.
Additional Duties: Tasks or duties not outlined in this job description may be required to contribute to the organization's success and efficiency.
Qualifications
Education & Experience:
Bachelor’s degree in Computer Science, Information Systems, Statistics, or a related field.
Minimum of 3 years of experience developing Power BI dashboards, reports, and analytics solutions.
Strong proficiency in DAX, Power Query (M), and dimensional data modeling best practices.
Advanced SQL skills, including writing and optimizing queries for reporting and analysis.
Demonstrated analytical thinking, strong attention to detail, and problem-solving capabilities.
Experience with Microsoft Fabric, including lakehouses, pipelines, or semantic models.
Familiarity with Azure cloud services and modern data architectures preferred.
Experience using Azure DevOps Git or similar version control tools preferred.
Exposure to data governance concepts, including metadata management, data quality, and lineage.
Certificates, Licenses, Registrations
Microsoft Power BI or data analytics certification preferred.
Tools & Systems:
Proficiency in Microsoft Power BI, including dashboards, datasets, paginated reports, and workspace management.
Strong experience with SQL-based databases and data sources.
Familiarity with Microsoft Fabric, Azure services, and enterprise BI ecosystems preferred.
Proficiency in Microsoft Office Suite (Word, Excel, PowerPoint, Outlook).