Data Analyst

Wednesday, January 15, 2025

TITLE: Data Analyst

LOCATION: Remote or Alexandria, Virginia (HQ)

DATE PREPARED: January 2022

FLSA: Exempt

DIVISION: Technology

DEPARTMENT: Software Engineering

TRAVEL REQUIREMENT:

Less than 10% to fulfill job requirements.

HOURS and SCHEDULE:

Generally, Monday – Friday, 9:00am to 5:30pm (minimum 37.5 hours within five (5) days per week); unless otherwise required or approved by management.

REPORTS TO:

This position reports to the Data Science Manager.

SUPERVISION EXERCISED:

None

RESPONSIBILITY FOR PUBLIC CONTACT:

Daily contact requiring courtesy, discretion, and sound judgment.

LICENSING AND CERTIFICATION:

None

GENERAL DESCRIPTION:

The Data Analyst (DA) is responsible for providing ad hoc and planned analysis to support management, operations, and technology within NCMEC. The DA will ensure accuracy and consistency of analysis and reports through interactions with engineers, stakeholders, managers, and third parties external to NCMEC. This role will also assist in the design and maintenance of dashboards and reports.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

• Writes complex queries for reporting, creating datasets, and visualization.
• Builds and demoes self-service dashboard in Tableau and Palantir Foundry, quickly and efficiently integrating feedback into dashboards.
• Works with project managers and stakeholders to define and detail requirements which are leveraged to build dashboard and reports.
• Coordinates with stakeholders on quarterly reporting needs for divisions across NCMEC.
• Provides database querying and data visualization guidance and best practices to non-technical users.
• Maintains knowledge of reporting needs and databases, while documenting tech debt, dependencies, etc.
• Administers Tableau Server projects, dashboards, and users.
• Prepares ad-hoc solutions when necessary to satisfy data needs in support of software development.
• Promote and exhibit loyalty to the National Center for Missing and Exploited Children and the cause of protecting children worldwide while maintaining a professional image.
• Conform with and abide by all regulations, policies, work procedures, and instructions.

EDUCATION AND EXPERIENCE:

• Bachelor’s degree in Computer Science, Data Science, or related technical field
• Minimum of 3 years of relevant work experience in data analysis and visualization

KNOWLEDGE, SKILLS AND ABILITIES

• Demonstrated proficiency and comfort with SQL or other querying languages.
• Interest in learning and/or proficiency in other data manipulation and coding languages such as Python (Pandas, Pyspark, etc.) or R.
• Demonstrated proficiency with data visualization, dashboarding, and BI tools such as Tableau.
• Advanced data visualization tool knowledge including calculated fields, connecting to and cleaning data.
• Advanced Excel including data cleaning formulas including index/match, nested if statements, and pivot tables.
• Experience developing and implementing data structures/architectures using multiple data sets (structured/unstructured).
• Strong communicator of requirements and solutions with stakeholders.
• Demonstrated proficiency with software needed to succeed in DA role, including MS Office, JIRA, and other visualization tools.
• Excellent organizational, interpersonal, communication, problem solving and analytical skills.
• Ability to learn new technologies and frameworks while keeping up to date with technology developments relevant to NCMEC.
• Adaptability, flexibility and ability to work as part of a team or in an individual capacity.
• Ability to handle and maintain the integrity and confidentiality of highly sensitive material and information.