Summer Associate Internship (Business Intelligence Analyst)

Overview

The Summer Associate Program is a 12-week internship program beginning in May 2027 and ending in August 2027. Students will work on impactful projects and meaningful work during their internship. To qualify for this position, applicants must be currently pursuing a degree from an accredited college or university and have an anticipated graduation date of December 2027 or later.

The Summer Associate will support business decisions by providing quantitative and qualitative data analysis and reporting of patterns, insights, and trends to leadership via data modeling, dashboards, and reports. Analyze business problems and issues using business intelligence tools that incorporate data from internal and external sources. Conduct routine work assignments of limited scope and complexity and under close supervision. Entry level professional with developing skill set and a basic understanding of procedures and analysis techniques.

Poetntial Projects Include:

Report Automation and Process Streamlining - support efforts to reduce manual reporting work for recurring and ad hoc outputs. Activities may include documenting current processes, identifying automation opportunities, validating outputs, and helping convert repeatable reporting steps into more scalable Power BI, Databricks, or workflow-based solutions.

BI Pipeline and Semantic Model Modernization - collaborate with BI analysts, data engineers, and other team members to help modernize data pipelines, source tables, and Power BI semantic models for AI-readiness. This may include supporting reusable data structures, improving metric consistency across dashboards, organizing fact and dimension tables, and documenting business definitions, measures, and relationships.

Dashboard and Documentation Support - contribute to interactive dashboards, reporting assets, and supporting documentation such as KPI definitions, data mapping guides, process workflows, and refresh/maintenance notes to improve clarity, consistency, and handoff across Member BI projects.

Responsibilities

• Follow standard procedures to create, update, and enhance basic reports and dashboards, including AI-ready design considerations where appropriate.
• Identify trends or patterns and help prepare ongoing reports and data visualizations in order to support business decisions.
• Contribute to reports that show key performance indicators, identify areas of improvement into current operations, and display root cause analysis of problems.
• Partner with leaders and senior staff to define specifications for reports, analysis, and AI-enabled self-service use cases based on business needs and available data elements.
• Utilize and adhere to data governance documents and procedures; validate data, AI-assisted outputs, and report results for accuracy, and alert supervisor if an inconsistency or inaccuracy is discovered.
• Work closely with BI analysts, data engineers, and other team members to support various Member BI projects.
• Assist in the design and development of interactive dashboards and reports using Power BI, Tableau, or Databricks.
• Conduct data exploration and preliminary analyses to identify trends, patterns, and correlations within member data.
• Collaborate with data engineers to optimize data pipelines, ensuring timely and accurate data delivery.
• Assist with data engineering tasks such as preparing, cleaning, joining, and transforming source data to support repeatable reporting, dashboard development, and downstream analytics.
• Support the creation and modernization of reusable, AI-ready data assets, including source tables, curated datasets, and semantic model inputs, while documenting data lineage, business logic, validation steps, descriptions, and business-friendly definitions.
• Participate in the development and maintenance of ETL processes to support data integration and transformation.
• Explore AI-enabled BI capabilities, such as Power BI Copilot, Databricks Genie, Tableau AI features, natural language analytics, prompt-based exploration, and automated insight summaries, to identify opportunities to improve development efficiency and user experience.
• Assist with preparing semantic models and dashboards for AI-supported use by adding clear measure descriptions, business definitions, synonyms, metadata, and documentation that improve interpretability and consistency.
• Prepare summary reports and presentations to communicate insights and project progress to team members and management.

Qualifications

• Technical experience building Power BI semantic/Tableau data models, including fact and dimension tables, relationships, and DAX measures
• Analytical experience in data analysis and reporting, with knowledge of a business area and the ability to connect analysis to business goals
• Experience writing SQL, PySpark, Python, or R to explore, transform, and model data in Databricks, with familiarity across relational databases, data pipelines, metadata, or AI-ready data structures
• Experience working with large-scale datasets (Delta/partitioned tables, or Spark) and independently joining, cleaning, and shaping source data
• Experience applying statistical methods, mathematical techniques, forecasting, and cost-benefit analysis
• Ability to take data problems from an ambiguous ask to a completed deliverable with limited guidance
• Ability to gather requirements from business stakeholders and translate them into clear specifications for reports, dashboards, and analysis

Desired Qualifications

• Ability to translate analysis into clear, compelling narratives for non-technical and leadership audiences
• Documentation skills, including writing KPI definitions, metric logic, and model assumptions that support self-service analytics
• Apply AI responsibly to analytics workflows, including prompt-based exploration, AI-assisted report development, automated summaries, and validation of AI-generated outputs; exposure to tools such as Power BI Copilot, Databricks Genie, or Tableau AI/Pulse preferred
• Familiarity with GitHub/version control and reproducible, well-documented work that supports reusable, AI-ready data assets; exposure to Tableau a plus
• Exposure to managing or coordinating small analytical projects

Additional Information

Hours:

• Monday - Friday, 8:00 AM - 4:30 PM

Location:

• 820 Follin Ln SE, Vienna, VA 22180

About Us