Data Analyst

Job Description

Job Description

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.

Local candidates are eligible for a hybrid schedule. Non-local candidates are eligible for fully remote.

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.

Responsible for managing and analyzing data within the organization's various databases, including 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 in a clear and concise manner.
• 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 : The above-noted job description is not intended to be an exhaustive list of all duties and responsibilities that may be assigned but rather to give the employee a general sense of the responsibilities and expectations of the job.

As the nature of business demands change, so may the essential functions of this specific position and / or the skills and abilities required.

Competencies :

• Proficient in Microsoft Excel, including advanced formulas, functions, pivot tables, and data visualization techniques.
• 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 (e.g., Power BI) preferred.
• 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 and SQL proficiency is preferred but not required.
• Strong communication skills with the ability to present findings and recommendations to non-technical stakeholders 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 recent data analysis or related experience required

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.

Our regular work schedule is 37.5 hours per week, Monday through Friday. Additional hours may be required for this position.

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.

Company Description

Associations exist to establish strength and unity in working toward a common goal. At the heart of every association is its mission and vision, the essence of why it does what it does.

The association management industry offers employment with purpose and allows you to work closely with and learn from professionals in all lines of business, from marketing and sales to budgeting and event planning, or the industry as a whole.

Company Description

Associations exist to establish strength and unity in working toward a common goal. At the heart of every association is its mission and vision, the essence of why it does what it does.

The association management industry offers employment with purpose and allows you to work closely with and learn from professionals in all lines of business, from marketing and sales to budgeting and event planning, or the industry as a whole.