Data Analytics & Insights Specialist

CDC Foundation; Atlanta, Northern (GA, KY); Hybrid; USD 85,000 - 100,000; Full time

Job summary

The CDC Foundation in Atlanta, GA, is seeking a Data Analytics & Insights Specialist to develop data solutions, dashboards, and reports. You will work with Smartsheet and BI tools to translate program data into actionable insights for leadership and program teams.

The role requires expertise in data analysis, data visualization, and cross-functional collaboration, with a focus on improving program performance and mission impact. Hybrid schedule with relocation not provided.

Qualifications

• Bachelor’s degree in data analytics, public health, program evaluation, information systems, business, computer science, statistics, or a related field, or equivalent relevant experience.
• At least three (3) years of experience in data analysis, business intelligence, reporting, program analytics, business systems support, or a related field.
• Experience analyzing data and translating findings into reports, visualizations, and practical insights.
• Experience developing reports or dashboards using Smartsheet, Power BI, Tableau, Salesforce, Excel, or a comparable platform.
• Experience designing end-to-end Smartsheet solutions incorporating forms, reports, dashboards, formulas, cross-sheet references, automations, and advanced platform capabilities.

Responsibilities

• Analyze operational and program data to identify trends, patterns, risks, and opportunities.
• Perform data exploration, manipulation, validation, and evaluation to support recurring and ad hoc reporting needs.
• Assist stakeholders in interpreting data and understanding the factors that affect program and organizational performance.
• Prepare summaries of analytical findings and communicate results in clear, practical language.
• Support the development and monitoring of key performance indicators, objectives and key results, and other performance measures.
• Contribute to organizational reporting by compiling, validating, and analyzing data from multiple sources.
• Provide data-informed observations and recommendations under the guidance of program, analytics, or operational leadership.
• Design, build, and maintain dashboards, reports, and data visualizations using Smartsheet and other approved reporting or business intelligence tools.
• Transform operational and program data into clear visualizations and reports for leadership, program teams, and other stakeholders.
• Develop recurring reports that provide timely information about program activity, operational performance, and organizational priorities.
• Apply established data visualization and reporting standards to promote consistency, clarity, accuracy, and accessibility.
• Build, configure, and maintain Smartsheet forms, sheets, reports, dashboards, workflows, automations, and cross-sheet formulas.
• Support the development and maintenance of user-friendly Smartsheet toolkits that align with defined program and business processes.
• Assist with mapping current workflows and identifying opportunities to improve efficiency, reduce manual work, and strengthen reporting.
• Participate in the testing and quality assurance of new solutions, updates, automations, and reporting logic.
• Support the IT department with troubleshooting routine Smartsheet, dashboard, reporting, and workflow issues and elevate complex technical matters as appropriate.
• Assist with connecting information from Smartsheet, customer relationship management (CRM) systems, financial systems, and other approved data sources.
• Support solution enhancements and system updates using established change management, testing, and documentation practices.
• Perform quality assurance checks to verify that reports, dashboards, and source data are complete, accurate, consistent, and timely.
• Assist with identifying and resolving data-quality issues in collaboration with system owners and business stakeholders.
• Document report definitions, calculations, data sources, workflows, business rules, and operating procedures.
• Follow established data governance, privacy, security, and records management requirements.
• Support data audits, reconciliations, and other quality-control activities as assigned.
• Contribute to the development and maintenance of reporting standards, data dictionaries, user guides, and technical documentation.
• Collaborate with cross-functional teams to support reporting, analytics, solution implementation, and continuous improvement initiatives.
• Provide training, office hours, and one-on-one support to users with varying levels of technical expertise.
• Develop and maintain training materials, job aids, and other resources that support effective use of Smartsheet and reporting tools.
• Explain technical concepts, reporting logic, and analytical findings to nontechnical audiences.
• Promote data literacy, sound reporting practices, and effective use of organizational data.
• Become familiar with and maintain a working knowledge of CDC Foundation programs and activities.
• Participate in staff activities, projects, and assignments and perform other duties as assigned.

Skills

Smartsheet

Power BI

Tableau

Salesforce

Excel

SQL basics

Data visualization

Data analysis

Stakeholder requirements

Cross-functional collaboration

Education

Bachelor’s degree in data analytics or related field

Tools

Smartsheet

Data visualization tools

CRM systems

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Data Analytics & Insights Specialist

Georgia

6 days ago Requisition ID: 2793

Salary Range: $85,000.00 To $100,000.00 Annually

Position Highlights

Location: This position will work a hybrid schedule based in Atlanta, GA.

Salary Range: $85,000-$100,000

Overview

The Data Analytics and Insights Specialist supports the development of data solutions, dashboards, reporting tools, and visualizations that help the CDC Foundation improve organizational and programmatic effectiveness, assess program performance, and communicate mission impact.

This position works across program and organizational teams to understand reporting needs, analyze operational data, and translate information into clear, actionable insights. The role also supports the configuration and ongoing improvement of Smartsheet solutions, including forms, reports, dashboards, workflows, and automations.

The position is based in Atlanta, Georgia, and follows a hybrid work schedule. Relocation expenses are not provided.

Duties and Responsibilities

Data Analysis and Interpretation

• Analyze operational and program data to identify trends, patterns, risks, and opportunities.
• Perform data exploration, manipulation, validation, and evaluation to support recurring and ad hoc reporting needs.
• Assist stakeholders in interpreting data and understanding the factors that affect program and organizational performance.
• Prepare summaries of analytical findings and communicate results in clear, practical language.
• Support the development and monitoring of key performance indicators, objectives and key results, and other performance measures.
• Contribute to organizational reporting by compiling, validating, and analyzing data from multiple sources.
• Provide data-informed observations and recommendations under the guidance of program, analytics, or operational leadership.

Reporting and Data Visualization

• Design, build, and maintain dashboards, reports, and data visualizations using Smartsheet and other approved reporting or business intelligence tools.
• Transform operational and program data into clear visualizations and reports for leadership, program teams, and other stakeholders.
• Develop recurring reports that provide timely information about program activity, operational performance, and organizational priorities.
• Apply established data visualization and reporting standards to promote consistency, clarity, accuracy, and accessibility.

Smartsheet Solutions and Business Systems Support

• Build, configure, and maintain Smartsheet forms, sheets, reports, dashboards, workflows, automations, and cross-sheet formulas.
• Support the development and maintenance of user-friendly Smartsheet toolkits that align with defined program and business processes.
• Assist with mapping current workflows and identifying opportunities to improve efficiency, reduce manual work, and strengthen reporting.
• Participate in the testing and quality assurance of new solutions, updates, automations, and reporting logic.
• Support the IT department with troubleshooting routine Smartsheet, dashboard, reporting, and workflow issues and elevate complex technical matters as appropriate.
• Assist with connecting information from Smartsheet, customer relationship management (CRM) systems, financial systems, and other approved data sources.
• Support solution enhancements and system updates using established change management, testing, and documentation practices.

Data Quality and Documentation

• Perform quality assurance checks to verify that reports, dashboards, and source data are complete, accurate, consistent, and timely.
• Assist with identifying and resolving data-quality issues in collaboration with system owners and business stakeholders.
• Document report definitions, calculations, data sources, workflows, business rules, and operating procedures.
• Follow established data governance, privacy, security, and records management requirements.
• Support data audits, reconciliations, and other quality-control activities as assigned.
• Contribute to the development and maintenance of reporting standards, data dictionaries, user guides, and technical documentation.

Collaboration, Training, and User Support

• Collaborate with cross-functional teams to support reporting, analytics, solution implementation, and continuous improvement initiatives.
• Provide training, office hours, and one-on-one support to users with varying levels of technical expertise.
• Develop and maintain training materials, job aids, and other resources that support effective use of Smartsheet and reporting tools.
• Explain technical concepts, reporting logic, and analytical findings to nontechnical audiences.
• Promote data literacy, sound reporting practices, and effective use of organizational data.
• Become familiar with and maintain a working knowledge of CDC Foundation programs and activities.
• Participate in staff activities, projects, and assignments and perform other duties as assigned.

Qualifications and Necessary Skills

Required

• Bachelor’s degree in data analytics, public health, program evaluation, information systems, business, computer science, statistics, or a related field, or equivalent relevant experience.
• At least three (3) years of experience in data analysis, business intelligence, reporting, program analytics, business systems support, or a related field.
• Experience analyzing data and translating findings into reports, visualizations, and practical insights.
• Experience developing reports or dashboards using Smartsheet, Power BI, Tableau, Salesforce, Excel, or a comparable platform.
• Experience designing end-to-end Smartsheet solutions incorporating forms, reports, dashboards, formulas, cross-sheet references, automations, and advanced platform capabilities.
• Proficiency with Data Shuttle, DataMesh, and/or Bridge by Smartsheet.
• Working knowledge of spreadsheet analysis, including formulas, pivot tables, lookups, data validation, and data preparation.
• Basic knowledge of relational database concepts and structured queries or demonstrated ability to learn SQL and related data tools.
• Experience gathering business or reporting requirements from stakeholders.
• Strong analytical, problem-solving, communication, and organizational skills with close attention to detail.
• Ability to manage multiple assignments, organize priorities, and meet established deadlines.
• Ability to explain data and technical concepts to users with different levels of technical expertise.
• Demonstrated ability to work collaboratively with cross-functional teams.
• Ability to handle confidential or sensitive organizational and program information with discretion.

Preferred

• Experience with Salesforce reporting, customer relationship management systems, enterprise resource planning systems, or similar platforms.
• Familiarity with data visualization principles and executive-reporting practices.
• Experience supporting nonprofit, public health, healthcare, government, or mission-driven organizations.
• Smartsheet Core Product Certification or willingness to obtain certification within the first year of employment.
• Exposure to data governance, data-quality management, business process mapping, or system implementation projects.

The CDC Foundation is a smoke-free environment.

Relocation expenses are not included.

About the CDC Foundation

The CDC Foundation helps the Centers for Disease Control and Prevention (CDC) save and improve lives by unleashing the power of collaboration between CDC, philanthropies, corporations, organizations, and individuals to protect the health, safety, and security of America and the world. The CDC Foundation is the sole entity authorized by Congress to mobilize philanthropic partners and private-sector resources to support CDC’s critical health protection mission. Since 1995, the CDC Foundation has launched approximately 1,000 programs and raised over $740 million. The CDC Foundation managed over 300 CDC-led programs in the United States and in more than 130 countries last year.