Data Analyst II

Summary

Astreya is seeking a Data Analyst II to provide modeling, data analytics, pricing, and financial planning support for major clients and corporate initiatives. The role supports quoting and pricing approvals, cost analysis, forecasting, reporting, performance measurement, process improvement, and decision-support automation.

Responsibilities

• Participate in day-to-day aspects of quoting and pricing approvals including supporting the sales team in multi–element and complex deal structuring for large client programs
• Collaborate with the Sourcing team to obtain product cost data
• Collaborate with PLM (Product Lifecycle Management) and Engineering team to monitor and verify BoM changes
• Utilize internal cost system to generate BoM (Bill of Materials) cost rollup report and comparison report
• Setup and maintain correct personnel, assembly and commodity settings in the cost system
• Assist in generating bi-weekly product cost reports
• Provide support in calculating monthly forecast, BOD reporting package, and annual and long term planning
• Identify and track appropriate performance measures, leading key performance indicators and associated drivers
• Be proactive in reviewing information, identifying inconsistencies, trends and issues for management
• Assist in maintaining consistent processes and standard formats, as well as design reporting summaries and scorecards
• Identify and understand opportunities and risk potential in the forecasts and help analyze their impact
• Help to prepare communication to management and executive teams on areas of concern and actions required to meet financial commitments
• Help handle automation of reporting within the group; assist in the assessment and implementation of decision support tools
• Other duties as required. This list is not meant to be a comprehensive inventory of all responsibilities assigned to this position

Skills

• Experience with BoMs
• Google Sheets experience is a must. This includes basic functions of pivot tables, Vlookup, validation if data is accurate and being able to create simple macros
• Bachelor's degree (B.S/B.A) from four-college or university and 4 to 6 years' related experience and/or training; or equivalent combination of education and experience

Qualifications

Must Haves

• Experience with BoMs
• Google Sheets experience is a must. This includes basic functions of pivot tables, Vlookup, validation if data is accurate and being able to create simple macros
• Bachelor's degree (B.S/B.A) from four-college or university and 4 to 6 years' related experience and/or training; or equivalent combination of education and experience

Benefits

• Medical provided through UHC (PPO, HSA, Surest options) for Regular, Full-Time Employees
• Medical provided through Kaiser (HMO option only) for California employees only
• Dental provided through UHC
• Nationwide Vision provided by UHC
• Flexible Spending Account for Health & Dependent Care
• Pre-Tax Account for Commuter Benefit/Parking & Transit (location-specific)
• Continuing Education and Professional Development via various integrated platforms, e.g. Udemy and Coursera
• Corporate Wellness Program provided by Goomi Group
• Employee Assistance Program
• Wellness Days
• 401k Plan
• Basic and Supplemental Life Insurance
• Short Term & Long Term Disability
• Critical Illness, Critical Hospital, and Voluntary Accident Insurance
• Tuition Reimbursement (available 6 months after start date, capped)
• Paid Time Off (accrued and prorated, maximum of 120 hours annually)
• Paid Holidays