Sales Data Analyst

AllSTEM Connections; Washington; On-site; USD 70,000 - 100,000; Full time

Job summary

AllSTEM Connections is seeking a data analytics professional to collaborate with business stakeholders and deliver descriptive data solutions. You will leverage SQL, Excel, Power BI, Tableau, and Qlik to create reporting and actionable visualizations, driving fact-based decisions across the organization.

You will analyze financial and sales data to identify trends, develop new metrics, and provide ongoing dashboards.

Qualifications

• Proficiency in SQL for extracting data and joining tables.
• Experience with data processing methods and relational databases.
• Familiarity with CRM platforms and business intelligence tools.
• Understanding of IS systems design and software development processes.
• Ability to analyze business processes and redesign workflows.

Responsibilities

• Collaborate with stakeholders to deliver data solutions using descriptive analytics.
• Create reports, dashboards, trend analyses, and data audits for operational awareness.
• Analyze relationships between financial results and sales performance to identify trends and cost drivers.
• Develop metrics and descriptive summaries to identify process issues and opportunities.
• Gather data from large datasets and apply ETL using tools like Alteryx, Talend, or SSIS.
• Interpret data using statistical summaries, Excel pivots, SQL queries, and BI tools (Power BI, Tableau).
• Create visualizations (charts, heatmaps, scorecards) to communicate insights to sales teams.
• Ensure data integrity by monitoring quality and removing corrupt data; standardize reporting across systems.
• Assist in resolving planning discrepancies and provide ad-hoc descriptive reports as needed.
• Maintain knowledge via conferences, certifications, and current descriptive analytics practices.
• Identify and implement reporting process improvements for recurring analytics deliverables.

Skills

SQL

Data analytics

Data visualization

CRM Platforms

Excel

Tools

Alteryx

Talend

SSIS

Power BI

Tableau

Qlik

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_%20English_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.

#3411

Company Description

Guiding P