Business Intelligence Analyst
10 days ago
Atlanta
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., • 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., • 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., • 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), • 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), • 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, employees must be able to operate a motor vehicle and fly in an aircraft, both of which may require sitting for prolonged periods of time. Employees must possess vision to read printed materials and a computer screen; and hearing and speech to communicate in person, before groups and over the telephone. Standing in work areas and walking between work areas will be required. This position requires an employee to occasionally bend, stoop, kneel, crouch, crawl, climb or balance; reach, push, and pull drawers and doors open and closed. The employee must occasionally lift and/or move up to 20 pounds. PCI Professional Services (PCIPS) is an equal opportunity employer. PCIPS does not discriminate on the basis of age, sex, race, national origin, religion, marital status, sexual orientation or identity, Veterans or Disability status. Preference may be extended to qualified Native American Indian candidates in accordance with applicable federal law.