Data Analyst

The American Gem Society (AGS) is seeking a passionate and dynamic individual to join our team as a Data Analyst. As a Data Analyst, you will play a crucial role in leveraging data to drive strategic decision-making and business growth. You will work closely with cross-functional teams to analyze and interpret complex datasets, uncover insights, and provide actionable recommendations.

About AGS

The AGS is a trade association that serves an enthusiastic community of fine jewelry
retailers, designers, wholesalers/manufacturers, and service providers who work to instill consumer trust in the jewelry industry. As a Data Analyst, you will have the opportunity to contribute to the organization’s mission and make a significant impact within the industry.

What You’ll Do

Responsible for managing and analyzing data within the organization’s various databases which include our AMS and LMS systems. This role involves ensuring database integrity, system testing and documentation of processes and procedures, security, and efficient operation while extracting valuable insights from data while working closely with all organization departments.

Specific responsibilities include:

• Collect, analyze, and interpret datasets from various sources including AMS and other spreadsheets to identify trends, patterns, and key insights.
• Collaborate with cross-functional teams to understand business requirements and translate them into effective data analysis solutions.
• Design and create visually appealing reports and dashboards using Excel, incorporating charts, graphs, and pivot tables to communicate complex data clearly and concisely.
• Continuously monitor data quality and identify opportunities for data cleansing and improvement.
• Conduct ad hoc analysis and deep dives into specific business areas to uncover opportunities, address challenges, and support decision-making processes.
• Identify and implement process improvements to enhance data collection, analysis, and reporting efficiency.
• Stay updated with industry trends and best practices in data analysis, reporting, and visualization techniques.
• Responds to telephone and electronic inquiries from current and prospective members as needed.
• Other duties as assigned.

Competencies:

• Proficient in Microsoft Excel, including advanced formulas, functions, and pivot tables.
• Strong analytical and problem-solving skills, with the ability to translate data into actionable insights.
• Excellent attention to detail and the ability to work with large datasets while maintaining accuracy.
• Experience in creating reports and dashboards using data visualization tools.
• Ability to ensure data accuracy, consistency, and integrity through data validation, cleansing, and quality control processes. Knowledge of data profiling, data cleansing techniques, and data quality assessment methodologies.
• Solid understanding of database concepts.
• Strong communication skills with the ability to present findings and recommendations in a clear and understandable manner.
• Self-motivated and proactive attitude with the ability to work both independently and collaboratively within a team.

Education:

• Bachelor’s Degree in a related field required

Experience:

• 2-3 years of data analysis or related experience required

Joining the American Gem Society offers a unique opportunity to contribute to the growth and success of a highly esteemed organization in the gem and jewelry industry. If you are dedicated, personable, and thrive in data analysis, we invite you to apply.

We offer a competitive benefits package, including medical, dental, vision, and life insurance as well as short-term and long-term disability and company-matched 401(k) contributions. This position comes with a hybrid schedule.

AGS is an equal-opportunity workplace. All qualified applicants will receive consideration for employment without regard to, and will not be discriminated against based on age, race, gender, color, religion, national origin, sexual orientation, gender identity, veteran status, disability, or any other protected categories.