Data Analysis SME

Stock Group Analytics; Washington, Northern (District of Columbia, KY); Hybrid; USD 120,000 - 180,000; Full time

Job summary

Stock Group Analytics in Washington, DC is seeking an experienced Data Analysis SME to design, develop, and deliver enterprise analytics solutions, including KPI dashboards, real-time visualizations, and advanced analytics products for Government stakeholders.

You will lead dashboards in Power BI, define KPIs, perform trend analyses, implement ETL with SQL/Python, migrate reports from legacy tools, and enable self-service analytics while guiding data visualization best practices.

Qualifications

• Bachelor's degree in data-related field; master's preferred.
• 10+ years in data analytics and KPI dashboards.
• CompTIA Security+ certification required; Power BI cert preferred.

Responsibilities

• Design and develop interactive, real-time dashboards using Power BI for executive and operational stakeholders.
• Define and document KPIs aligned with Government objectives.
• Perform deep-dive and trend analyses on historical data to uncover actionable patterns.
• Implement data cleaning, transformation, and validation to ensure data accuracy.
• Develop ETL processes using SQL, Python, or Azure Data Factory.
• Migrate reports from legacy tools (Tableau, Excel) to Power BI and enable self-service analytics.
• Integrate predictive analytics models into visualization tools.
• Provide guidance on data visualization best practices.
• Support ad-hoc data analysis requests from Government leadership.
• Document KPI formulas, data sources, and dashboard configurations.
• Conduct training sessions for Government personnel on analytics tools and capabilities.

Skills

Power BI dashboarding

SQL querying

Python for data analysis

Data visualization best practices

KPI development

Education

Bachelor's degree in data-related field

Master's degree preferred

Tools

Power BI

Tableau

Excel

Azure Data Factory

Azure Synapse

Job description

Position Summary

Data Analysis SMEs serve as senior experts responsible for designing, developing, and delivering enterprise analytics solutions including KPI dashboards, real-time visualizations, and advanced analytical products. These individuals work directly with Government stakeholders to define metrics, implement data visualization best practices, and enable data-driven decision-making across the Bureau.

Key Responsibilities

• Design and develop interactive, real-time dashboards using Microsoft Power BI for executive and operational stakeholders
• Define and document Key Performance Indicators (KPIs) aligned with Government's strategic objectives
• Perform deep-dive analyses and trend analysis on historical data to uncover actionable patterns
• Implement data cleaning, transformation, and validation processes to ensure data accuracy
• Develop and maintain Extract-Transform-Load (ETL) processes using SQL, Python, or Azure Data Factory
• Transition existing reports and dashboards from legacy tools (Tableau, Excel) to Power BI
• Enable self-service analytics capabilities by developing data models and templates for power users
• Integrate predictive analytics models into visualization tools
• Provide technical guidance on data visualization best practices
• Support ad-hoc data analysis requests from Government leadership
• Document all KPI formulas, data sources, and dashboard configurations
• Conduct training sessions for Government personnel on analytics tools and capabilities

Required Qualifications

• Education: Bachelor's degree in Data Science, Statistics, Computer Science, Business Analytics, or related field (Master's preferred)
• Experience: 10+ years of experience in data analytics, business intelligence, and KPI dashboarding
• Certifications:
  • CompTIA Security+ (required)
  • Microsoft Power BI certification preferred
  • Relevant data analytics certifications (e.g., Microsoft Data Analyst Associate)
• Technical Skills:
  • Expert proficiency in Microsoft Power BI (dashboard development, DAX, Power Query)
  • Advanced SQL skills for data querying and manipulation
  • Experience with Tableau and Excel-based reporting
  • Proficiency in Python or R for data analysis
  • Knowledge of ETL processes and data integration tools
  • Understanding of statistical analysis and trend forecasting

Preferred Qualifications

• Experience supporting federal government analytics programs
• Familiarity with manufacturing or production analytics use cases
• Experience with Azure Data Factory, Azure Synapse, or similar cloud data platforms
• Knowledge of Natural Language Query capabilities in BI tools