Sr. Data Analyst - Commercial / Sales Enablement

Sr. Data Analyst

PLEASE NOTE: We do not support employment based visa sponsorship for this role (to include OPT), therefore you must be a US Citizen or current US Green Card Holder.

We may consider a remote based working arrangement for the right individual, however, you must be based in either US Eastern or Central Time zones.

Reports to: Director, Sales Operations and Enablement

The Role

Associated Material’s Innovations’ (AMI) commercial data does not live in one place. Data sets across the sales cycle — opportunity and pipeline, quotes and orders, actual and benchmark revenue — live in different systems. What will we ship next quarter, which opportunities convert to revenue, how is this rep actually performing: none of these can be answered from a single source.

This role exists to close that gap. It is responsible for engineering the connections between commercial systems, and turning the combined result into analytics that frame and change decisions. Building Power BI dashboards is how the work surfaces; joining, modeling, and validating data across systems is the work itself.

This is a hands-on role at the intersection of data engineering, applied analytics, and executive visualization, with a strong bias toward insight delivery and measurable business impact. You will inherit an established Power BI and Excel-based reporting environment, own its evolution, and extend commercial analytics well beyond it. The role reports to the Director, Sales Operations and Enablement, and works directly with commercial, sales, operations, and executive leadership.

What You'll Own

• Connect commercial systems to answer questions no single system can. Link opportunity and pipeline data to actual revenue, orders, and shipment data across separate platforms — so that a closed opportunity can be traced to realized revenue and forecast accuracy measured.
• Build rep and territory performance profiles. Combine actual revenue, prior-year performance, plan/AOP, and open pipeline into a single ongoing view of how each rep and region is performing — gap to plan, gap to prior year, and pipeline coverage in one place.
• Turn transactional data into forward-looking signal. Mine quote, order, and shipment data across the estate to model volume, velocity, and trajectory, and project future performance and gaps.
• Engineer the data infrastructure that makes it possible. Design, build, and maintain scalable data flows to ingest, transform, and model data from multiple enterprise systems, including Palantir Foundry, Salesforce, ERP sources, and operational Excel-based systems. Own workflows end to end, from raw ingestion through curated datasets.
• Deliver the analytics layer. Build and maintain Power BI dashboards and Excel models that make the above usable — intuitive, performant, and built to the decisions they support, not to a report spec.
• Apply analytical rigor. Use statistical methods, modeling, and trend analysis to surface patterns and inform strategy, not just report history.
• Shape the commercial data architecture. AMI is actively evaluating its CRM strategy; this role helps shape and execute the path chosen — influence over the architecture, not just consumption of it.
• Make it durable. Implement data quality checks, validation rules, and monitoring; document systems and logic so critical commercial reporting is not dependent on any single person.

Who You Are

This role offers unusual exposure. The work is consumed weekly by sales leadership and feeds reporting reviewed at the executive and ownership level, in a fast-paced, private-equity-backed environment where priorities evolve quickly and results matter.

• Curious and intellectually sharp — drawn to ambiguous data problems and unfamiliar systems
• Comfortable creating structure where none exists, including in systems that were never designed to talk to each other
• "Knows what questions to ask — not just how to answer the ones they're handed"
• An owner who pushes work across the finish line
• Motivated by scope and visibility — the remit is broad and largely undefined by design, and one person's work reaches the top of the company

Qualifications

Required

• Bachelor’s degree (MBA a plus) and 5+ years in data science, analytics, and/or data reporting
• Advanced Excel data analysis and reporting and power query skills
• Strong Power BI development — dashboards, datasets, and data models / M and DAX proficiency
• Strong SQL — comfortable writing and optimizing complex joins, aggregations, and window functions against large dataset
• Hands-on data engineering: building and maintaining production data pipelines (e.g. Fivetran, Databricks, dbt, Azure Data Factory, or comparable)
• Demonstrated experience integrating data across multiple source systems — joining, reconciling, and validating data that does not share a common key
• Experience with large, complex datasets and dashboard performance optimization

Preferred

• ERP or transactional/financial data experience (order, shipment, revenue)
• Python or PySpark for data transformation and modeling
• Palantir Foundry — or demonstrated ability to learn a new platform quickly, as core concepts transfer
• Salesforce or comparable CRM data experience.

Associated Materials is a leader in exterior building products for residential and commercial remodeling and new construction markets. We produce vinyl windows, vinyl and composite siding and accessories, and metal building products--and distribute other essential building products to ensure customers find everything they need for their exterior.

Headquartered in Cuyahoga Falls, Ohio, more than 4,000 associates across North America support Associated Materials. We operate 11 manufacturing facilities and more than 100 Alside and over 20 Gentek supply centers across the United States and Canada. Through our unique combination of award-winning products, manufacturing and distribution operations, installation solutions, and support services, the opportunities at Associated Materials are endless