Business Intelligence Analyst

The Business Intelligence Analyst will support the NCEH/ATSDR IT Compliance and IT Support effort by designing, developing, and maintaining high-quality data visualizations, dashboards, and analytical products that enable leadership, program managers, and technical teams to make informed decisions. The role operates at the intersection of IT governance
, EPLC/CPIC reporting
, information security
, and operational performance
, translating complex program and system data into clear, actionable insights.

This position works closely with program management, information security, IT services, and governance stakeholders to ensure that reporting products align with CDC, HHS, and OMB requirements and support monthly, quarterly, and ad hoc reporting obligations.

• Design and develop interactive dashboards, scorecards, and visual analytics to support program performance, IT governance, EPLC, CPIC, and operational reporting.
• Build and maintain BI dashboards using multiple data sources (SharePoint lists, SQL databases, Excel files, service desk systems, and security tools).
• Translate complex technical, financial, and compliance data into clear, executive-level visuals for leadership briefings and governance boards.
• Ensure visualizations follow best practices for accessibility, clarity, and usability
  , including Section 508 considerations where applicable.

• Extract, transform, and analyze structured and semi-structured data from:
• SharePoint (2016 and SharePoint Online)
• Excel and CSV-based reporting
• Service management and ticketing systems
• Develop supporting data models, calculated measures, and KPIs aligned to CDC and HHS reporting standards.
• Validate data accuracy and consistency across multiple reporting sources.

• Support EPLC and CPIC reporting
  , including schedules, milestones, risks, issues, and performance metrics.
• Assist with monthly status reports (MSRs), task summary reports (TSRs), quarterly risk reports, and annual/final reports through automated or semi-automated visual reporting solutions.
• Provide analytical support for Info Sec, governance, and asset oversight reporting needs.
• Support ad‑hoc data calls from CDC OD, HHS, and OMB by rapidly developing one-off analytical views or visual summaries.

• Work directly with program managers, business analysts, Info Sec staff, and system owners to define reporting requirements.
• Present findings and dashboards to both technical and non-technical audiences.
• Maintain documentation for dashboards, data sources, assumptions, and refresh schedules.

• Power BI (required) and R Shiny
  :
  Data modeling, DAX, report/dashboard design
• Data visualization best practices (KPI scorecards, trend analysis, risk dashboards)
• Excel (advanced formulas, pivot tables, data transformation)

• SQL Server (2012–2017 or later): querying, joins, views
• Share Point (2016 and SharePoint Online): lists, libraries, data integration
• Familiarity with dashboarding or analytics tools such as:
• Tableau
• SSRS (SQL Server Reporting Services)
• Power Platform components (Power Automate, Power Apps — preferred)

• Understanding of EPLC
  , CPIC
  , and IT governance reporting
• Familiarity with federal IT environments
  , including CDC, HHS, or similar agencies
• Awareness of security, privacy, and data handling requirements in regulated environments (PII, FISMA, FedRAMP concepts)

• 5+ years of experience in data visualization, business intelligence, or analytics
• Demonstrated experience translating program, financial, or IT operational data into executive-ready visual products
• Experience supporting government or large enterprise IT programs
• Experience working with cross-functional teams (PMs, Info Sec, developers, leadership)

• Experience supporting CDC, HHS, or other federal health agencies
• Familiarity with IT service management data (incidents, changes, vulnerabilities)
• Knowledge of Section 508 accessibility requirements
• Experience contributing to dashboard automation and reporting optimization
• Strong visual storytelling and…