Data/BI Analyst

Design, build, and maintain interactive dashboards and reports using Microsoft Power BI to support business decision-makingDevelop and optimize complex SQL queries, views, and stored procedures for data extraction, transformation, and analysisCreate and manage data models within Microsoft Power BI, including relationships, hierarchies, and performance tuningWrite advanced calculations and measures using DAX to deliver meaningful business insightsUse Power Query to clean, transform, and shape data from multiple sourcesIntegrate data from various systems (ERP, CRM, flat files, APIs) into cohesive reporting datasetsPerform data validation, reconciliation, and quality checks to ensure accuracy and consistencyPartner with business stakeholders to gather reporting requirements and translate them into technical solutionsAnalyze trends, patterns, and anomalies to provide actionable insights and recommendationsOptimize report performance, including dataset design, query efficiency, and refresh strategiesMaintain documentation for data sources, models, and reporting logicSupport ad hoc data requests and exploratory analysisCollaborate with data engineering and IT teams on data pipelines, warehousing, and governance initiatives