Sales Operations Analyst - Affinitiv

Join our award-winning A-Team! 

Ready to produce exceptional results with exceptional people?  Get in touch, we would love to get to know you. 

Affinitiv is the largest provider of end-to-end, data-driven marketing and software solutions exclusively focused on the automotive customer lifecycle. Backed by 20+ years of automotive and marketing expertise, we pride ourselves on being the go-to experts in the industry. Not only do we work with over 6,500 dealerships and every major manufacturer in the country, we're well-versed in OEM standards and the intricacies of a dealership or group's local business.

The Sales Operations Analyst will work to support the Affinitiv sales organization in a multi-faceted role.  This team member will be responsible for supporting our Sales Teams through PowerBI Reporting, Alteryx Workflows, and Salesforce Development. This role will be key in driving understanding of underlying sales data and providing key visualizations/reporting to help improve sales effectiveness across the organization.

• Support Affinitiv Sales Teams, including but not limited to – creating and enhancing PowerBI dashboards and developing automated Salesforce reporting, tracking sales revenue, bookings, performance, churn, retention, and product penetration.
• Provide detailed source analysis, data mappings/transformations, and scheduled data refreshes within PowerBI and Alteryx; additionally, implementing new data sources/integrations.
• Comfortable with data wrangling and transforming variables that enhance data insights.
• Work cross-functionally to identify and fix data quality issues.
• Design auto flows by using Power Automate for developed reports/dashboards to achieve auto refresh, auto archive, and on time delivery.
• Identify key performance indicators (KPIs) tracking and reporting for cross functional business partners, supporting future Salesforce enhancements.
• Perform data uploads. Updating attributes within Salesforce, NetSuite and other sources.
• Perform regular data audits and address any gaps identified.
• Collaborate with sales compensation to ensure sales data is accurate and support commissionable data based on respective Sales Incentives Plans (SIP). 

Successful candidates will have the following required qualifications:

• BA in Business, Computer Science, or related field.
• 2-5 years of relevant experience with PowerBI and Salesforce.
• Relational and Dimensional Data Modeling.
• Knowledge of DAX queries, functions, and measures.
• The ability to learn new systems quickly.
• Ability to work under tight deadlines and manage multiple projects at a time.
• Self-motivated, independent worker.

Additional qualifications that could help you succeed further in this role include:

• Advanced analytical skills.
• Building Alteryx workflows.
• Snowflake database SQL queries.
• NetSuite Knowledge.
• SFDC development using Apex classes, Triggers, Visual Force, Flow, Process Builder.

Work from Here

At Affinitiv, we have the best of both worlds.   Our team members have embraced remote work and our Work from Here program allows for remote working and the utmost flexibility while keeping in person collaborating thriving in a safe work environment.   Our Work from Here approach gives team members a choice to work on campus or remote, leaders can hold in person or virtual team meetings to collaborate and cultivate relationships.

Affinitiv knows you have interests outside of work, which is why we offer a comprehensive benefits package that includes medical, dental, vision and 401K effective day 1 just to name a few.   We also offer generous PTO so you can enjoy off time with family and friends.   

At Affinitiv, we celebrate diversity, equality, and an inclusive environment.

Affinitiv is committed to providing an environment of mutual respect where equal employment opportunities are extended to all employees and applicants for employment. We prohibit discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.

All aspects of employment are decided on the basis of qualifications, competence, merit, and business needs. Affinitiv is proud to be an equal opportunity employer.