Sr. Data Analyst

Key Responsibilities

• Gather requirements, define KPIs, and translate business needs into scalable analytics deliverables (datasets, semantic models, dashboards, and insights).
• Write and optimize advanced SQL across SQL Server, Snowflake, and Microsoft Fabric (Warehouse/Lakehouse).
• Design and maintain analytics-ready data models (dimensional/star schemas, curated layers, reusable views/tables).
• Build, enhance, and performance-tune dashboards and reporting in Power BI (DAX, Power Query, semantic models) and Tableau.
• Use Python (e.g., pandas, NumPy; optional scikit-learn/statsmodels) for data wrangling, statistical analysis, forecasting, experimentation support, and automation.
• Implement data validation and quality controls (reconciliation, anomaly checks, refresh monitoring, metric certification).
• Develop within Microsoft Fabric using relevant components (e.g., notebooks, Dataflows Gen2, pipelines, Lakehouse/Warehouse, semantic models) as applicable.
• Leverage Microsoft Copilot and AI tools (e.g., Copilot for Power BI/Fabric/M365 and other approved assistants) to:
  • accelerate SQL/DAX generation and refactoring,
  • speed up dashboard prototyping and narrative insights,
  • draft documentation and data dictionaries,
  • support stakeholder Q&A and self-service enablement, while ensuring correctness through testing and peer/stakeholder validation.
• Communicate findings clearly, create concise executive narratives, and recommend actions backed by data.
• Maintain documentation for metric definitions, logic, lineage, and operational runbooks to support handoff.