Data Analyst

Description

We are seeking a skilled Data Analyst with solid experience in data analytics and proficiency in SQL to

join our team temporarily. The successful candidate will be key in extracting, analyzing, and interpreting

data from our ERP system to support our business operations and decision-making processes. The

primary focus will be assessing gross margins, monitoring key performance indicators (KPIs), and

providing actionable insights through reports and dashboards.

Key Responsibilities:

• Data Extraction: Utilize SQL to extract material and labor data from the ERP system on a

per-shipment basis.

• Gross Margin Analysis: Perform detailed gross margin assessments by analyzing material, labor,

and overhead costs as a percent of revenue.

• Reporting: Develop and maintain regular reports to communicate findings, trends, and insights

to organizational stakeholders.

• Dashboard Creation: Collaborate with the team to design and implement interactive

dashboards that visualize crucial metrics and KPIs, enabling real-time monitoring and datadriven decision-making.

• Data Integrity: Ensure data accuracy and consistency by conducting regular audits and validating

data sources.

• Ad-Hoc Analysis: Respond to requests for specific data analyses, reports, and visualizations to

support various business functions.

Skills

Data analysis, Microsoft excel, sql, sql queries, sql query writing, sql query analyzer, power bi, gross margin, gross margin analysis, data reporting, dashboard, data extraction, tableau, manufacturing erp