Data Specialist

Graphic Information Systems; Mason (OH); Presencial; USD 65.000 - 85.000; Jornada completa

Descripción de la vacante

Graphic Information Systems is seeking a Data Specialist to oversee the creation and development of new databases, monitor performance, and transform raw data into actionable insights. The role emphasizes data cleaning, accuracy, confidentiality, and accessibility for authorized personnel.

Responsibilities include analyzing data trends, maintaining archives, preparing production-ready data, and coordinating with customer service, sales, and production teams to resolve discrepancies.

Formación

• At least 2 years of professional experience in data analysis, data processing, or database management.
• Advanced Microsoft Excel functions (e.g., VLOOKUP, INDEX/MATCH, pivot tables, Power Query).
• Experience working in multiple databases at the same time.
• Experience creating, cleaning, and formatting large data files for production use.
• Experience working with print production data files or similar.

Responsabilidades

• Perform comprehensive data analysis, including identifying trends, anomalies, and process improvement opportunities.
• Maintain and update the GIS local archive server, ensuring all data files are current, accurately labeled, and stored according to company standards.
• Create, clean, and format both simple and complex data files for print and production applications using advanced Excel functions, SQL queries, or other data tools as required.
• Verify customer-provided data, prepare proofs, and communicate with customers to ensure final outputs meet required formats and specifications.
• Manage multiple client databases simultaneously, ensuring data accuracy, integrity, and confidentiality.
• Serve as the primary point of contact for resolving data discrepancies between customer service, sales, and print/production teams.
• Provide technical support and guidance to internal teams to ensure smooth data integration into quoting, print, and production processes.
• Document all data processing procedures and maintain organized records for audit and reference purposes.
• Follow strict data security protocols to protect confidential and proprietary information.
• Proactively identify potential risks in data handling and recommend corrective actions.

Conocimientos

Advanced Excel

Data analysis

SQL queries

Herramientas

SQL

Descripción del empleo

Graphic Information Systems specializes in warehouse inventory control solutions, including labeling and signage systems for major distribution centers throughout North America.

As a Data Specialist, you will be responsible for overseeing the creation and development of new databases, monitoring database performance, and interpreting and transforming raw data into valuable insights and applications. In addition to deriving meaning from raw data, your duties will include collecting and cleaning data, ensuring its accuracy and integrity, and safeguarding confidential information while making it accessible to authorized personnel.

Duties & Responsibilities

• Perform comprehensive data analysis, including identifying trends, anomalies, and process improvement opportunities.
• Maintain and update the GIS local archive server, ensuring all data files are current, accurately labeled, and stored according to company standards.
• Create, clean, and format both simple and complex data files for print and production applications using advanced Excel functions, SQL queries, or other data tools as required.
• Verify customer-provided data, prepare proofs, and communicate with customers to ensure final outputs meet required formats and specifications.
• Manage multiple client databases simultaneously, ensuring data accuracy, integrity, and confidentiality.
• Serve as the primary point of contact for resolving data discrepancies between customer service, sales, and print/production teams.
• Provide technical support and guidance to internal teams to ensure smooth data integration into quoting, print, and production processes.
• Document all data processing procedures and maintain organized records for audit and reference purposes.
• Follow strict data security protocols to protect confidential and proprietary information.
• Proactively identify potential risks in data handling and recommend corrective actions.

Qualifications and Experience

• At least2 years of professional experience in data analysis, data processing, or databasemanagement
• Advanced Microsoft Excel functions (e.g., VLOOKUP, INDEX/MATCH, pivot tables, Power Query)
• Experience working in multiple databases at the same time
• Experience creating, cleaning, and formatting large data files for production use
• Experience working with print production data files or similar

**Must be located near Cincinnati, OH - Mason area. This is a Full-time, in-office position.

***Graphic Information Systems (GIS) is unable to offer sponsorship for employment visas at this time. All candidates must be legally authorized to work in the United States without current or future sponsorship requirements. We appreciate your understanding and encourage all qualified individuals to apply.