Sign upLog in

Senior Data Analyst

Iconma

McLean, VA

Apply
JOB DETAILS
SALARY
$60.71 Per Hour
SKILLS
Artificial Intelligence (AI), Automation, Business Intelligence, Communication Skills, Consulting, Cost Control, Data Analysis, Data Modeling, Data Quality, Data Sets, Database Extract Transform and Load (ETL), Documentation, Financial Services, Forecasting, Health Plan, Metrics, Microsoft Product Family, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Operational Support, Performance Metrics, Performance Modeling, Performance Tuning/Optimization, Power BI, Prototyping, Python Programming/Scripting Language, Real Estate, Reconciliation, Refactoring, Reporting Dashboards, Requirements Management, SQL (Structured Query Language), Star Schema, Statistics, Tableau, Training Data Sets, Warehousing
LOCATION
McLean, VA
POSTED
6 days ago
Our client, is a Real Estate and Financial Services company, is looking for a Senior Data Analyst for their McLean, VA location.
 
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.
 
Requirements:
  • 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.
  • Reliable, documented KPI definitions and curated datasets used consistently across teams.
  • High-performing, user-friendly dashboards in Power BI/Tableau with measurable adoption.
  • Reduced manual reporting through automation and reusable analytics assets.
  • Clear documentation and handoff materials enabling maintainability after contract completion.
  • 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.
  • Must be proficient in Python it is used for ETL.
  • Need to have good experience with Power BI and need to create dashboards in Power BI
  • Current team is responsible for pulling data from Workday, VNDLY and other multiple sources.
  • This is senior role and candidate must have 7+ years of experience.
  • Python
  • Power BI and Power BI dashboards
  • SQL
  • Any AI or Copilot
  • Snowflake/Fabric - Preferred not mandatory.
 
Why Should You Apply?  

About the Company

I

Iconma

ICONMA is a global information consulting management firm providing Professional Staffing Services and Project-Based Solutions for organizations in a broad range of industries.

  • Corporate Headquarters in Troy, Michigan; 20+ locations worldwide.
  • Certified Woman-Owned Business Enterprise (WBE); certified by Women’s Business Enterprise National Council, National Women Business Owners Corporation (NWBOC); and California Public Utilities Commission (CPUC).
  • Founded in 2000
  • 2000+ Employees

The company was founded on the principle that success is derived from delivering high quality service and resources in the most responsive, flexible, and innovative way. ICONMA invests in people and resources with a single goal: To provide our customers with the highest quality service in the most responsive manner. Through its network of offices, ICONMA provides the resources to help clients maintain their competitive advantage.

COMPANY SIZE
2,000 to 2,499 employees
INDUSTRY
Management Consulting Services
EMPLOYEE BENEFITS
401K, Employee Referral Program, Life Insurance
FOUNDED
2000
WEBSITE
https://www.iconma.com/

Resume Resources

Free Resume TemplatesFree Resume Builder