Location: Mclean,VA – onsite – Must be local
Longterm
Required Skills and Qualifications
- Proficiency in SQL and proven experience designing and implementing data models and schemas
- Strong understanding of data warehousing concepts (dimensional modeling, star/snowflake schemas)
- Hands-on experience with Power BI, including dashboard development and UX-focused data visualization
- Proven ability to transform and optimize large, raw datasets into structured, analytics-ready formats
- Excellent communication skills with the ability to effectively engage and present to project stakeholders
- Strong analytical thinking and problem-solving abilities with attention to detail
Key Responsibilities
- Design, develop, and maintain data models and schemas to support business intelligence and analytics initiatives
- Leverage SQL to query, transform, and optimize large datasets for reporting and analysis
- Build and enhance Power BI dashboards and reports, applying UX and data visualization principles to ensure clarity and usability
- Implement and manage ETL processes to ensure data accuracy, consistency, and reliability across systems
- Collaborate with business stakeholders to gather requirements, define KPIs, and deliver actionable insights that drive decision-making
- Apply data warehousing concepts such as dimensional modeling and star/snowflake schemas to structure data efficiently
- Partner with data engineers, analysts, and business teams to ensure seamless data integration and reporting workflows
- Troubleshoot data quality issues, identify process improvements, and ensure data governance standards are upheld
Preferred Experience
- Experience working in cross-functional data environments
- Familiarity with other data visualization or ETL tools is a plus
- Background in business analysis, data engineering, or analytics consulting
