Sr. Data Analyst/Sales Enablement

Associated Materials Innovations; Cuyahoga Falls (OH); On-site; USD 90,000 - 130,000; Full time

Job summary

Associated Materials Innovations (AMI) seeks a Senior Data Analyst to connect commercial systems and turn data into insights. You’ll own Power BI dashboards, join data across Salesforce, ERP, Palantir Foundry, and Excel models, reporting to the Director of Sales Operations and Enablement in a fast-paced, private-equity environment.

The role requires 5+ years in data analytics, advanced Excel and SQL, and hands-on data engineering to build scalable pipelines and dashboards that drive revenue

Qualifications

• Bachelor’s degree (MBA a plus) and 5+ years in data science, analytics, and/or data reporting.
• Advanced Excel data analysis and reporting; Power Query skills.
• Strong Power BI development: dashboards, datasets, and data models (M and DAX).
• Strong SQL; complex joins, aggregations, and window functions on large datasets.
• Hands-on data engineering: building and maintaining production data pipelines (Fivetran, Databricks, dbt, Azure Data Factory).
• Experience integrating data across multiple source systems.
• Experience with large, complex datasets and dashboard performance optimization.

Responsibilities

• Connect systems to link opportunity and revenue across platforms.
• Build rep and territory performance profiles.
• Model volume, velocity, and trajectory from quotes, orders, shipments.
• Design and maintain scalable data flows ingesting from enterprise sources.
• Deliver analytics by building Power BI dashboards and Excel models.
• Apply statistical methods and trend analysis to inform strategy.
• Shape CRM/data architecture and influence roadmap.
• Ensure data quality checks and documentation to avoid single-person reliance.

Skills

Power BI dashboards / data models

Advanced Excel data analysis

SQL

Data engineering pipelines

Data integration

M and DAX

Reporting & analytics

Education

Bachelor’s degree

MBA a plus

Tools

Power BI

Excel

SQL

Fivetran

Databricks

dbt

Azure Data Factory

Palantir Foundry

Salesforce

Job description

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.

Join the Associated Materials Innovations team at Associated Materials, LLC, and be AMazing with us!

Who We Are

At Associated Materials Innovations, we combine our rich history in innovation with an unwavering commitment to continuous improvement of the customer experience. For decades, we have provided vinyl windows, siding, and metal building products that have helped build homes and communities across North America. As a leading manufacturer of exterior building products and preferred product manufacturer for Alside, you'll have the opportunity to contribute ideas in a welcoming and supportive work environment driven by safety and our core values. Join the AMI team where you can be AMazing as we shape our future together.

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

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 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, LLC. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, ancestry, age, disability, medical condition, genetic information, military and veteran status, marital status, pregnancy, gender, gender expression, gender identity, sexual orientation, or any other characteristic protected by local law, regulation, or ordinance. We also make reasonable accommodations for disabled employees and applicants, as required by law.

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.

Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled