Role 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 maintenance of reports. - Writes complex queries for reporting, creating datasets, and visualization. - Builds and demos 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. - 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. Qualifications - Bachelor’s degree in Computer Science, Data Science, or related technical field. - Minimum of 2 years of relevant work experience in data analysis and visualization. Requirements - 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. - 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, Tableau, 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.

Role Description We are looking for an experienced Amazonian and Excel whiz who is an expert on BOTH the Amazon Seller Central and Amazon Vendor Central platforms to join our Remote Team to create reports. Our ideal candidate for this position should pride themselves as being detail-oriented, extremely accurate, a critical thinker, proactive, and a problem-solver. You would be joining our Amazon Data Team, providing Excel and reporting support directly to company executives. This position requires daily downloading, compiling, and formatting of reports from Amazon Seller Central and Amazon Vendor Central. It is critical that the candidate applying already has knowledge of core report locations and advanced Excel experience in order to succeed. He/She must be comfortable managing large Excel data sets and multi-tasking reporting schedules with accuracy and timeliness. We want someone who really enjoys mining for metrics and turning big data into real insights! Responsibilities - Demonstrated experience locating and downloading all available Amazon reports in Seller Central and Vendor Central - Solid understanding of each report type and the definitions for each Amazon metric found on the report(s) - Demonstrated experience analyzing and interpreting Amazon report(s) to create actionable KPIs - Organized approach to collating and saving data - Strong experience with data presentation using Excel, Google Sheets, and PowerPoint - Maintain and update daily, weekly, monthly, quarterly, and yearly Sales reports/trackers - Maintain and update weekly, monthly, quarterly, and yearly Expense reports/trackers - Prepare and analyze Amazon Sales Performance - Prepare and analyze Amazon Inventory Performance - Prepare and analyze Amazon Advertising Performance - Administrative Database management duties in Google Drive and Microsoft SharePoint Qualifications - Strong Written and Oral Communication; fluent in oral and written English - Minimum of 2 Years of Experience with Amazon Seller Central and Amazon Vendor Central experience - Minimum of 2 Years of Experience handling and presenting core Amazon reporting for external teams (i.e., Sales, Advertising, Inventory, and Finance) - Minimum of 2 Years of Advanced Experience with Excel and Google Sheets - Proven experience with data aggregation, data mining, data manipulation, segmentation techniques, and creating data models using MS Excel and Google Sheets - Proven experience validating data integrity of large Excel data sets including formula validations and data origination - Be able to maintain a high level of accuracy, quality, and presentation of data with dynamic deadlines for multiple departments - Highly inquisitive and self-motivated to “dig deep” to find impactful data insights in big data - High energy and proven team player, always willing to help and problem solve - Preferred: Experience with Amazon 3rd party software, automation, Power BI Education - College Degree or Accreditation for Business Administration, Statistics, Accounting, and/or Finance Requirements - Work hours will be in Pacific Standard Time (7-8am PST start time) - This is a fully remote, work-from-home position for candidates based in eligible offshore locations.

Role Description We are looking for an experienced Looker Data Analyst to join us on a freelance basis, working approximately 10–20 hours per week, fully remote. This role sits within our Growth Team and is focused on turning complex business data into clear, actionable insights. This isn't just a dashboard-building role. We want someone who can dig deep into our data, ask the right questions, and tell a compelling story with the answers. You'll work closely with internal stakeholders to understand business problems and translate them into analysis that drives real decisions. You'll receive thorough onboarding and training on our historical business data so you can hit the ground running. Responsibilities: - Stakeholder partnership: Work closely with teams across the business (marketing, sales, product, customer success) to understand their data challenges, reporting cadence, and decision-making patterns. - Dashboard design & consolidation: Design and maintain a lean set of dashboards in Looker that serve cross-team needs. - Looker Explore development: Build and maintain efficient, well-documented Looker Explores that empower business users to self-serve for ad-hoc questions. - Insight & analysis: Go beyond chart-building — investigate the "why" behind trends and translate findings into clear, actionable recommendations. - Documentation & standards: Maintain consistent metric definitions, dashboard documentation, and naming conventions. Qualifications - Experience building and maintaining dashboards in Looker, with a strong understanding of LookML, Explores, and Looker's modelling layer. - Strong SQL skills - you're comfortable writing and optimising complex queries. - A track record of consolidating or rationalising reporting. - The ability to turn data into a story - not just charts, but insights that lead to action. - Experience running Looker Explores and a solid understanding of data modelling concepts. - Strong analytical judgement and the confidence to draw conclusions independently. - Clear communication skills - you can explain findings to both technical and non-technical audiences. - Self-motivated and comfortable working autonomously in a remote, async environment. Requirements - Experience with Snowflake or similar cloud data warehouses. - Background in SaaS or product-led analytics. - Experience with Salesforce and familiarity with Looker-Salesforce integrations.

• Support the development, maintenance, and administration of the Sustainable Health Care Cost Growth Target Program. • Collect, analyze, and report data from health insurers, hospitals, and health care providers, including health care claims, encounter, and enrollment data. • Produce summary statistics, performance measures, and other indicators used to assess cost growth targets and identify areas for improvement. • Oversee data quality and validation, report generation, data request fulfillment, and ad hoc analyses for internal and external partners. • Plan and manage key initiatives related to data analysis, validation, and internal process improvement. • Collaborate closely with analysts in the Office of Health Analytics, program staff in the Office of Health Policy, and partners across OHA divisions such as Public Health and Health Systems, as well as external partners including the Department of Human Services (DHS) and the Department of Consumer and Business Services (DCBS).