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 (M1) 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 M1 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, m1, manufacturing erp Top Skills Details 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 Additional Skills & Qualifications Qualifications: • Experience: Proven experience in data analytics, with a strong focus on financial and operational data. • SQL Proficiency: Advanced SQL skills, including writing complex queries and optimizing database performance. • ERP Experience: Familiarity with ERP systems, particularly M1, is highly desirable. • Analytical Skills: Strong problem-solving abilities, a keen eye for detail, and a deep understanding of data analysis techniques. 9355 RUFFIN COURT, • SAN DIEGO, CA 92123 • (858) 974-1600 • FAX (858) 974-1200 Page 2 of 2 • Reporting Tools: Experience with data visualization and reporting tools (e.g., Excel, Tableau, Power BI) are preferred. Cognytics experience is highly desired • Communication: Excellent communication skills, with the ability to present complex data clearly and promptly. Team Collaboration: Ability to work independently and collaboratively with cross-functional teams. 3. What 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 a. On a resume I want to see them moving across multiple platforms, breath of knowledge across various platforms 4. What are the nice to have’s, that would be like a bonus for this person to have to succeed in the role? a. M1 exposure or some sort of manufacturing ERP would really help b. Proficience in SQL is a big one – that indicates a level of capability that will help them accelerate 5. How 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 Experience Level 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. About Aston Carter: 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. 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. 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 (%20astoncarteraccommodation@astoncarter.com) for other accommodation options.