Senior Data Analyst

Work sponsorship is available for this position

Title : Data Analyst Senior

Location: Mclean, VA - 5 days onsite

• The candidate must have experience with the following:
• Python (ETL and Analytics)
• Advanced Power BI and Tableau
• SQL querying, SQL Server and Snowflake
• Experience with Microsoft Fabric, AI tools / Copilot and industry experience is nice to have.

Must Have Qualifications: The ideal candidate must have working knowledge of Python, SQL, Power BI, and Snowflake, develop Power BI dashboards, and write SQL queries. Must have familiarity in AI and Copilot

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.

Benefits: We offer a benefits package including medical, dental, vision, and 401(k).

Compensation: $50.00 – $60.00 per hour. This is the targeted compensation range for this role per year. Please note that this range is provided as a guideline and the final offer will be based on several factors, including but not limited to, skillset and competencies, level of experience, education, certifications, and location.

We are an equal opportunity employer. We do not discriminate on the basis of race, color, religion, sex, national origin, age, disability, genetic information, veteran status, sexual orientation, gender identity, or any other characteristic protected by applicable federal, state, or local law.