Data Analyst

Applied Governance; Portsmouth, Northern (NH, KY); Hybrid; USD 70,000 - 110,000; Full time

Benefits offered by this job

Casual dress

Dog-friendly office

Summer hours

Sabbaticals after seven years

Job summary

The IAPP in Portsmouth, NH is seeking a Data Operations Specialist to maintain data flows, build reports, and ensure data quality across departments. You will collaborate to support operational metrics and improve reporting capabilities.

You will leverage Power BI, SQL, and AWS to load, clean, and transform data from multiple sources, document processes, and contribute to the organization’s data strategy. A hybrid work arrangement with two remote days and three days in the Portsmouth office is

Qualifications

• Bachelor's degree in a related field.
• 1+ year experience using SQL; read, write, modify complex queries.
• Experience with Power BI to build reports and dashboards.
• Familiarity with AWS or cloud data platforms a plus.
• Experience using AI tools (e.g., Copilot) to support data work.
• Advanced Excel skills (VLOOKUP, cross-sheet references).
• Experience analyzing data for inaccuracies and inconsistencies.
• Ability to translate internal needs into analytics and visuals.
• Experience with modern data tools to inspect/transform data at scale.
• Exposure to Salesforce, Marketo, NetSuite a plus.

Responsibilities

• Collaborate with team to understand and support critical metrics.
• Create reports, visualizations, and dashboards using Power BI.
• Provide ongoing support to maintain departmental reporting capabilities.
• Leverage business knowledge to inform analysis and data flows.
• Contribute to development and execution of data strategy and governance.
• Utilize AI tools to automate tasks, speed analysis, and surface insights.
• Identify root causes of data issues and propose practical solutions.
• Support data integrity and normalization across sources.
• Load, clean, and manipulate data from multiple sources using AWS tools.
• Document processes transforming data for reporting and ensure freshness.
• Assist with SQL-based database support and troubleshooting.
• Monitor data patterns for irregularities and propose improvements.
• Build relationships across staff to promote self-service analytics.

Skills

Data analysis

Data visualization

Curiosity

Cross-functional collaboration

Problem solving

Education

Bachelor's degree (B.S./B.A.) from a four-year college or university

Tools

SQL

Power BI

AWS

Copilot AI tools

Excel

Salesforce

Marketo

NetSuite

Job description

This role is responsible for day-to-day operations including maintaining and building data flows, updating and creating documentation for existing and new business solutions, and assuring data quality, while contributing to IAPP's broader data strategy.

Essential Duties and Responsibilities

• Collaborate with team to understand and support critical metrics that support ongoing operational management needs.
• Create reports, visualizations, and dashboards using tools such as Power BI, and provide other functionality to ensure that all departments have the day-to-day metrics that matter to their operations.
• Provide ongoing support and improvements to maintain departmental reporting capabilities.
• Understand IAPP's reporting environment and leverage knowledge of the business and operational processes to inform analysis or create auxiliary data flows to support organizational operations.
• Contribute to the development and execution of IAPP's data strategy, helping define how data is collected, stored, governed, and used to drive business decisions.
• Utilize AI tools and techniques to automate repetitive tasks, accelerate analysis, and surface insights from data more efficiently.
• Solve complex data problems by identifying root causes, evaluating trade-offs, and recommending practical solutions across multiple systems and data sources.
• Support initiatives for data integrity and normalization.
• Load, clean, and manipulate data from multiple sources including internal, external, and 3rd parties, leveraging AWS-based data infrastructure and tools where applicable.
• Document processes of transforming datasets into efficient structures for reporting and ensure that data is up to date in source systems and data stores.
• Support business operations to ensure that data flows correctly through the database, perform key action items to ensure process flow, and assist with database support and troubleshooting issues, primarily using SQL.
• Monitor and identify irregularities in data patterns in production data and opportunities for improved processes and data integrity. Leverage problem-solving skills to investigate data inaccuracies and inconsistencies, triage next steps, and create a game plan for solutions.
• Develop strong relationships with staff throughout the organization. Support self-service capabilities wherever possible and support learning initiatives that reinforce user adoption of data solutions.
• Collaborate closely with the technology and business operations teams to ensure smooth, ongoing operation and adaptation to evolving business needs.

Additional Duties

• Additional duties as assigned

Education and or Experience

• Bachelor's degree (B.S./B.A.) from a four-year college or university
• 1+ year(s) experience using SQL – must be able to read, write, and modify complex SQL queries with no supervision
• Experience with Power BI (or similar BI tools) to build reports, dashboards, and visualizations
• Familiarity with AWS or other cloud data platforms (e.g., data warehousing, storage, or pipeline tools) a plus
• Experience utilizing AI tools (e.g., Copilot) to support data analysis, automation, or reporting workflows
• Intermediate experience with Excel including vlookup, referencing cross cells/sheets, and creating formulas with no supervision
• Experience analyzing and investigating data, data inaccuracies, and/or inconsistencies, and solving complex, multi-source data problems
• Demonstrated curiosity, ability, and passion for listening to internal customer needs and translating them into actionable analytics
• Ability to deliver results through visual presentation of the data
• Experience using modern data tools and techniques to inspect and transform data at scale
• Familiarity with Salesforce, Marketo, and/or NetSuite a plus
• Exposure to data strategy development, including data governance, quality frameworks, or long-term data architecture planning, a plus

At the IAPP, we value in-person connections fueled by fun, excellence, and communication. To align with this value, we have a hybrid work environment that allows for two remote days and three days in our Portsmouth, NH office.

About the IAPP

The IAPP is a policy neutral, not-for-profit association founded in 2000 with a mission to define, promote and improve the professions of privacy, AI governance and digital responsibility globally . More information about the IAPP is available at iapp.org .

What We Offer

Working at the IAPP is an opportunity like no other. In addition to a competitive compensation package including base salary, bonus and a full range of benefits, the IAPP offers a creative, supportive and flexible environment. Other perks include casual dress, a dog-friendly office, summer hours, and sabbaticals after seven years of service. We work in a "get-stuff-done" culture that values respect, personal and professional growth, and an entrepreneurial attitude. We have been named to Business NH Magazine's Hall of Fame for "Best Small Companies to Work for in NH."

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.