Sales Data Analyst

The Sales Data Analyst is responsible for identifying, understanding, and combining data sources and analytical techniques to empower the sales team and leaders with data driven actionable insights that improve revenue generation, customer targeting and operational efficiency. Position optimizes data quality by reviewing and interpreting data, analyzing results, and working with business owners to improve data information. This includes the use of descriptive analytics tools and techniques to summarize, visualize, and report on historical data to drive actionable strategic decision making.

1. Collaborate with business stakeholders to deliver highly effective data solutions using descriptive data analytics and business knowledge, leveraging tools such as SQL, Excel, Power BI, Tableau, and Qlik for reporting and actionable visualization.

1. Ensure excellence through fact-based decision making by utilizing reports, dashboards, trend analyses, and data auditing practices (with tools such as Excel, SQL scripts, Power BI dataflows, etc) to create operational awareness and ensure decisions are based on accurate and trustworthy information.

1. Analyze relationships between financial results and sales performance data to identify historical trends, variances, and cost drivers. Track, identify trends and opportunities using KPI's like conversion rates, pipeline velocity, and quota attainment.

1. Develop and propose new metrics and work across the organization to make actionable intelligence available to business stakeholders. Include root cause research and descriptive summaries to identify process breakdowns.

1. Gather pertinent data from large datasets and organize it logically. Apply ETL (Extract, Transform, Load) skills and tools (such as Alteryx, Talend, or SSIS) to harmonize disparate data sets. Interpret data using statistical summaries, Excel pivot tables, SQL queries, and BI visualization tools (e.g., Birst, Power BI, Tableau) to provide ongoing reports and dashboards.

1. Create visualizations such as charts, heatmaps, and scorecards that allow the sales team to quickly understand historical performance while incorporating storytelling techniques to highlight key insights and effectively communicate the narrative behind the data.

1. Ensure data integrity by monitoring data quality, removing corrupt data, and establish processes to ensure accuracy and consistency across all reporting systems.

1. Assist in resolving MRP and planning discrepancies, providing ad-hoc descriptive reports as needed.

1. Maintain professional and technical knowledge by leveraging online resources, attending conferences, pursuing certifications, and staying current with emerging descriptive analytics practices.

1. Identify and implement reporting process improvements to streamline recurring analytics deliverables.

1. Perform under the Working Conditions described below.

QUALIFICATIONS FOR ENTRY:

KNOWLEDGE OF:

• Data processing methods, relational tables, procedures, and computer software systems.
• CRM Platforms
• SQL for extracting data from databases, and how that data needs to be joined.
• Systems design and development process, including requirements analysis, feasibility studies, software design, programming, pilot testing, installation, evaluation, and operational management.
• Business process analysis and redesign.
• Design and operation of IS systems.

Equal Opportunity Employer / Disabled / Protected Veterans

The Know Your Rights poster is available here:

The pay transparency policy is available here:

For temporary assignments lasting 13 weeks or longer, AllSTEM Connections is pleased to offer major medical, dental, vision, 401k and any statutory sick pay where required.

We are committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation for any part of the employment process, please contact your staffing representative who will reach out to our HR team.

AllSTEM Connections participates in the E-Verify program in certain locations as required by law. Learn more about the E-Verify program.

We also consider for employment qualified applicants regardless of criminal histories, consistent with legal requirements, including, if applicable, the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance. Pursuant to applicable state and municipal Fair Chance Laws and Ordinances, we will consider for employment-qualified applicants with arrest and conviction records, including, if applicable, the San Francisco Fair Chance Ordinance. For Los Angeles, CA applicants: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.

Additional Skills

(none specified)


AllSTEM Representative Contact Info

Account Executive:


Sturgeon


Branch Phone:


View phone number on click.appcast.io


Location:


Ontario, CA