- Company Name
- Broadstreet Properties
- Job Title
- Business Intelligence Analyst
- Job Description
-
**Job Title:** Business Intelligence Analyst
**Role Summary:**
Collaborate within a centralized BI team to design, develop, and maintain data models, interactive reports, and dashboards that drive strategic decision‑making across business operations. Support budgeting, variance analysis, and data governance while ensuring data quality and automation of reporting processes.
**Expectations:**
- Deliver accurate, insightful analytics and reports on time.
- Actively participate in cross‑functional initiatives, translating business requirements into technical solutions.
- Maintain best practices in data integration, quality, and governance.
- Communicate complex findings clearly to technical and non‑technical stakeholders.
**Key Responsibilities:**
- Prepare, clean, and aggregate large, multi‑source data sets for reporting.
- Design and produce interactive Power BI dashboards and advanced Excel reports.
- Support the annual budgeting process through data consolidation, automation, and performance analysis.
- Conduct financial and operational variance analyses, uncovering trends, anomalies, and improvement opportunities.
- Define KPI requirements and collaborate with stakeholders to refine reporting metrics.
- Integrate data from various software solutions, APIs, and relational databases.
- Identify and resolve data quality issues, ensuring consistency across reports.
- Develop automated workflows and data pipelines to streamline recurring reporting tasks.
- Contribute to data governance practices, documenting data models and business logic.
- Present analytical findings in clear, visual formats to diverse audiences.
**Required Skills:**
- Proficiency in Power BI (designed, refreshed, and optimised reports).
- Advanced Microsoft Excel (Power Query, DAX, macros).
- SQL querying of relational databases.
- Knowledge of data modelling, ETL processes, and API integration.
- Experience with Microsoft Fabric (Dataflows Gen2, OneLake, DirectLake, etc.).
- Scripting ability (Python or similar) for data analysis or automation.
- Strong analytical, problem‑solving, and organisational abilities.
- Clear communication and presentation skills for non‑technical audiences.
**Required Education & Certifications:**
- Bachelor’s degree in Business Administration, Data Analytics, Computer Science, or a closely related field.
---