Data Specialist
Novi AMS helps associations amplify the impact they create for their members and industries. Our Customer Experience team is central to that mission — and we’re hiring a Data Preparation Specialist with strong technical data skills and proven manipulation, automation and analysis experience.
If you have a strong eye for detail and commitment to accuracy, enjoy customer collaboration and love problem-solving and analyzing data — this role is for you.
What Drives Us
Building community and fostering collaboration is one of our guiding principles. Our primary mission is to help associations by providing them with tools to amplify the change they make within their own industries. We have a relentless drive to improve the lives and experiences of the customers we serve.
"What truly excites me about working at Novi are the connections we build, not just within our team, but also with our customers. There's no greater feeling than hearing feedback that we have made a positive impact on people's lives.”
Where We’re Going
Every day, our team rises with excitement and the mission to help our customers continue to solve problems. We’re proving that with the right people and the right tools, we can continue to make an impact not just for associations, but for the world.
No Barriers – Remote Work
Our company culture is important to us and we want to work with the best talent in the world to support our vision, regardless of location. We can’t let geographic barriers prevent us from great things when we’re on a mission to make a positive impact on society!
Learn More About Our Company Culture
General Position Description
Novi AMS is seeking a detail-oriented Data Preparation Specialist whose primary focus is to format, clean, and transform customer-provided data so it can be accurately imported into our database systems. This role combines strong technical data skills with direct customer collaboration, ensuring that data requirements are clearly understood and that customer data is successfully prepared for import.
You will work closely with customers and internal teams to assess data readiness, define transformation rules, and resolve data issues prior to import.
What You'll Do...
Customer Collaboration & Data Discovery
- Join onboarding specialists in meetings with customers to review their data files and understand data structure, content, and business context.
- Explain data preparation requirements, formatting standards, and import constraints to customers in clear, non-technical terms.
- Identify data gaps, inconsistencies, or risks and collaborate with customers to resolve them prior to import.
- Serve as a subject-matter expert for customer data preparation during onboarding or implementation efforts.
Data Preparation & Transformation
- Receive customer-provided datasets in various formats (CSV, Excel, JSON, XML, etc.) and prepare them for database import.
- Work with customers to clean, deduplicate, and validate data to ensure accuracy, completeness, and consistency.
- Map customer data fields to internal database schemas and document transformation logic
Scripting & Automation
- Write and maintain SQL queries and Python scripts to automate data cleaning, transformation, and validation processes.
- Build repeatable and scalable data preparation workflows to support multiple customers and datasets.
Data Quality & Validation
- Perform quality checks and validation to ensure data meets import requirements.
- Identify, document, and resolve data anomalies and import errors.
Troubleshooting & Support
- Investigate and resolve issues encountered during data preparation or import processes.
- Recommend improvements to data standards and preparation workflows based on recurring customer challenges.
Required Skills & Qualifications
- Strong proficiency in SQL and Python for data manipulation and automation.
- Experience cleaning, transforming, and validating structured data.
- Advanced skills in Excel or Google Sheets for data analysis and review.
- Understanding of ETL concepts and data import processes.
- Ability to communicate technical data concepts clearly to non-technical customers.
- Strong attention to detail and commitment to data accuracy.
- Excellent problem-solving and analytical skills.
Preferred Qualifications
- Experience working directly with customers in a technical or implementation-focused role.
- Familiarity with database schemas, data modeling, or data warehousing concepts.
- Experience with version control (e.g., Git) and process documentation.
- Exposure to APIs or structured data formats (JSON, XML).
Why Join Novi?
- We are fully remote — we’ve operated virtually for over 10 years. Work where you want, and we’ll help you set up your home office with the equipment and technology you need.
- We believe in meaningful benefits: health, dental, vision, generous PTO, paid holidays, and family-friendly leave policies.
- Work-life balance matters: Whether you choose to stay in one place or become a digital nomad, we support it.
- Growth and development are part of our DNA: You’ll have access to professional development, certifications, continuing education, and open paths for internal growth.
- Inclusion and diversity drive innovation: We value different ideas, perspectives, and backgrounds. By joining Novi, you’re becoming part of a team that believes in equity, representation, and making an impact.
- We celebrate wins and each other: From big customer milestones to everyday achievements, we like to bring home the bacon (and celebrate it).