Description

\n\t\t\t\t\t

We are seeking a skilled Data Analyst with solid experience in data analytics and proficiency in SQL to\njoin our team temporarily. The successful candidate will be key in extracting, analyzing, and interpreting\ndata from our ERP system (M1) to support our business operations and decision-making processes. The\nprimary focus will be assessing gross margins, monitoring key performance indicators (KPIs), and\nproviding actionable insights through reports and dashboards.\nKey Responsibilities:\n• Data Extraction: Utilize SQL to extract material and labor data from the M1 ERP system on a\nper-shipment basis.\n• Gross Margin Analysis: Perform detailed gross margin assessments by analyzing material, labor,\nand overhead costs as a percent of revenue.\n• Reporting: Develop and maintain regular reports to communicate findings, trends, and insights\nto organizational stakeholders.\n• Dashboard Creation: Collaborate with the team to design and implement interactive\ndashboards that visualize crucial metrics and KPIs, enabling real-time monitoring and datadriven decision-making.\n• Data Integrity: Ensure data accuracy and consistency by conducting regular audits and validating\ndata sources.\n• Ad-Hoc Analysis: Respond to requests for specific data analyses, reports, and visualizations to\nsupport various business functions.

\n\t\t\t\t\t

Skills

\n\t\t\t\t\t

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, m1, manufacturing erp

\n\t\t\t\t\t

Top Skills Details

\n\t\t\t\t\t

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

\n\t\t\t\t\t

Additional Skills & Qualifications

\n\t\t\t\t\t

Qualifications:\n• Experience: Proven experience in data analytics, with a strong focus on financial and\noperational data.\n• SQL Proficiency: Advanced SQL skills, including writing complex queries and optimizing\ndatabase performance.\n• ERP Experience: Familiarity with ERP systems, particularly M1, is highly desirable.\n• Analytical Skills: Strong problem-solving abilities, a keen eye for detail, and a deep\nunderstanding of data analysis techniques.\n9355 RUFFIN COURT, • SAN DIEGO, CA 92123 • (858) 974-1600 • FAX (858) 974-1200\n Page 2 of 2\n• Reporting Tools: Experience with data visualization and reporting tools (e.g., Excel, Tableau,\nPower BI) are preferred. Cognytics experience is highly desired\n• Communication: Excellent communication skills, with the ability to present complex data\nclearly and promptly.\nTeam Collaboration: Ability to work independently and collaboratively with cross-functional\nteams.\n\n3.\tWhat do they need to know day 1 that you are not willing to train on? What are the must have’s you need to see on a resume? – deep comfort with data systems, don’t need to be prfcient in debits/credits accounting, or understanding manufacturing process – its just the strength in data, comfort and confidence to go into m1 and learn it\na.\tOn a resume I want to see them moving across multiple platforms, breath of knowledge across various platforms\n\n4.\tWhat are the nice to have’s, that would be like a bonus for this person to have to succeed in the role?\na.\tM1 exposure or some sort of manufacturing ERP would really help\nb.\tProficience in SQL is a big one – that indicates a level of capability that will help them accelerate\n\n5.\tHow many years of experience – learning attitude, enthusiasm for job can make up for a lack of experience. Would love someone more seasoned but, sometimes they are too set in how they do things, less flexible. Need to be an active listener, youthfulness of a learning attitude, don’t want to discount someone at 30 yoe. targeting 3-5 YOE sweet spot

\n\t\t\t\t\t

Experience Level

\n\t\t\t\t\t

Intermediate Level

Pay and Benefits

The pay range for this position is $45.00 - $50.00/hr.

Eligibility requirements apply to some benefits and may depend on your job
classification and length of employment. Benefits are subject to change and may be
subject to specific elections, plan, or program terms. If eligible, the benefits
available for this temporary role may include the following:

• Medical, dental & vision
• Critical Illness, Accident, and Hospital
• 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available
• Life Insurance (Voluntary Life & AD&D for the employee and dependents)
• Short and long-term disability
• Health Spending Account (HSA)
• Transportation benefits
• Employee Assistance Program
• Time Off/Leave (PTO, Vacation or Sick Leave)

Workplace Type

This is a fully onsite position in San Diego,CA.

Application Deadline

This position is anticipated to close on Jul 7, 2025.

\n

\n\nAbout Aston Carter:\n

Aston Carter provides world-class corporate talent solutions to thousands of clients across the globe. Specialized in accounting, finance, human resources, talent acquisition, procurement, supply chain and select administrative professions, we extend the capabilities of industry-leading companies. We draw on our deep recruiting expertise and expansive network to meet the evolving needs of our clients and talent community with agility and excellence. With offices across the U.S., Canada, Asia Pacific and Europe, Aston Carter serves many of the Fortune 500. We are proud to be a ClearlyRated Best of Staffing® double diamond winner for both client and talent service.

\n\n

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

\n

If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please email astoncarteraccommodation@astoncarter.com for other accommodation options.

\n\n