Please login/register to apply for this job.
21 Apr 2026

Contract Data Analyst

Aspirecruit Inc – Posted by saumya.rawat McLean, Virginia, United States

Job Description

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.

Required Skills & Experience:

  • 7 – 10+ years in data analytics/BI/consulting (or equivalent senior-level experience).
  • Advanced SQL expertise (CTEs, window functions, complex joins, query tuning).
  • Strong experience with SQL Server (T-SQL) and performance optimization.
  • Experience with Snowflake (warehouse concepts, optimization/cost awareness, security basics).
  • Hands-on experience with Microsoft Fabric (Lakehouse/Warehouse concepts; pipelines/dataflows/notebooks; semantic modeling).
  • Strong dashboard development skills in Power BI (DAX, modeling, performance) and Tableau.
  • Proficiency in Python for analytics and automation.
  • Demonstrated ability to use AI-assisted tools productively with appropriate guardrails (validation, privacy, reproducibility).
  • Excellent stakeholder management, communication, and independent delivery skills.

How to Apply

Share your resume @ saumya.rawat@aspirecruit.com

Job Categories: Information Technology. Job Types: Contract. Salaries: 55 - 60.

Job expires in 24 days.

43 total views, 1 today

Apply for this Job