Job Specifications
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.
Key Responsibilities
Data Visualization & Reporting
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.
Data Integration & Analysis
Extract, transform, and analyze structured and semi-structured data from:
SQL Server databases
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.
Program & Compliance Support
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 InfoSec, 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.
Collaboration & Stakeholder Engagement
Work directly with program managers, business analysts, InfoSec 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.
Required Technical Skills
Data Visualization & BI Tools
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)
Data & Platform Experience
SQL Server (2012–2017 or later): querying, joins, views
SharePoint (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)
Compliance & Governance Knowledge
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)
Required Experience
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, InfoSec, developers, leadership)
Preferred Qualifications
Experience supporting CDC, HHS, or other federal health agencies
Familiarity with IT service management data (incidents, changes, vulnerabilities)
Knowledge of Section 508 accessibility requirements
Prior experience supporting labor‑hour or time‑and‑materials contracts
Experience contributing to dashboard automation and reporting optimization
Soft Skills & Competencies
Strong visual storytelling and communication skills
Ability to simplify complex technical and compliance data
High attention to detail and data accuracy
Ability to work independently in a regulated environment
Excellent written and verbal communication skills
Physical Requirements
The physical demands described herein are representative of those which must be met by an employee to successfully perform the essential functions of the job. Employees must possess the ability to work in a standard office or conference room setting and use standard office equipment, including a computer.
To visit other company sites, em