Sales Data Analyst

AllSTEM Connections; Washington; On-site; USD 85,000 - 110,000; Full time

Job summary

AllSTEM Connections seeks a data analyst to collaborate with business stakeholders and deliver actionable insights using SQL, Excel, Power BI, Tableau, and Qlik. You will build dashboards, track trends, and ensure data integrity across reporting systems.

You will gather data from large datasets, apply ETL using Alteryx, Talend, or SSIS, and translate findings into clear visuals and narratives for decision-makers.

Qualifications

• Experience with SQL, Excel, and BI tools for reporting.
• Knowledge of data governance and data quality.
• Experience with ETL and data integration.
• Ability to translate business needs into metrics.

Responsibilities

• Collaborate with stakeholders to deliver effective data solutions using descriptive analytics and BI tooling.
• Create reports, dashboards, trend analyses, and data audits to support decisions.
• Analyze relationships between financial results and sales data to identify trends and drivers.
• Develop and propose new metrics across the organization to enable actionable intelligence.
• Gather data from large datasets and apply ETL to harmonize disparate data sets.
• Interpret data with statistical summaries and BI visualizations to deliver ongoing reports.
• Design visualizations (charts, heatmaps, scorecards) to convey insights clearly.
• Maintain data integrity by monitoring quality and preventing corrupt data.
• Support resolution of planning discrepancies with ad-hoc descriptive reports.
• Continuously update knowledge of descriptive analytics through resources and training.
• Identify opportunities to improve reporting processes and standardize deliverables.

Skills

Data processing

CRM platforms

SQL

Systems design

Business process analysis

IS systems

Tools

Alteryx

Talend

SSIS

Job description

Job Description

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.

2. 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.

3. 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.

4. 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.

5. 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.

6. 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.

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

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

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

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

11. 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: https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12.pdf

The pay transparency policy is available here: https://www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp_English_formattedESQA508c.pdf

For temporary assignments lasting 13 weeks or longer, the Company 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. https://e-verify.uscis.gov/web/media/resourcesContents/E-Verify_Participation_Poster_ES.pdf

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.

Company Description

Guiding P