Please note - we are unable to support employment-based visa sponsorship (including OPT), therefore, you must be a US Citizen or current US Green Card Holder.

The Role- Senior Data Analyst/ Sales Enablement

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

Reports to: Director, Sales Operations and Enablement

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

QualificationsRequired:

• 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 joints, 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

About Us

When you join AMI, you are part of a leading North American manufacturing business of vinyl windows, cladding, metal siding, trim and other essential exterior building products for residential, light commercial and multifamily projects. In 2022, we introduced our composite cladding system, a first-of-its-kind solution featuring exclusive (GP)2 technology.

Headquartered in Cuyahoga Falls, Ohio, AMI is part of Associated Materials, LLC, which owns and operates 10 manufacturing facilities in North America including a distribution center.

Associated Materials Innovations ... Building Products Better

Additional Information

The actual wage offered to the successful candidate will be based on multiple factors, including, but not limited to, job-related knowledge/skills, experience, business needs, geographical location, and internal pay parity. Compensation decisions are dependent upon the facts and circumstances of each position and candidate. Click to learn more about benefits.