Commercial Analytics
5 days ago
Irvine
Job Title: Commercial Analytics Location: Irvine, CA Hours: M-F, 1st shift, - hybrid position, 3 days a week on site (Mon/Weds and every other Friday. Pay: $39 Commercial Analyst Job Description Are you passionate about turning data into actionable insights? Do you thrive in a dynamic environment where collaboration and innovation drive success? Join our team as a Commercial Analyst and play a key role in shaping strategic decisions, enhancing compliance, and empowering field execution. This is your opportunity to make a meaningful impact within a forward-thinking commercial organization. Job Summary The Commercial Analyst will play a pivotal role in executing analytics and reporting initiatives that focus on contract compliance, sales incentive compensation, sales performance, and commercial operations. This position is tasked with compiling and analyzing sales and contract data to support informed decision-making, enhance compliance, and improve field execution. The analyst will develop tools and dashboards, manage rebate and compliance calculations, and assist in the administration of sales compensation, account alignments, quotas, and territory planning. This role requires collaboration with various departments, including Sales, Customer Service, Finance, HR, Marketing, Legal, Contracts, and IT, to identify trends, generate insights, and foster operational excellence within the commercial organization. The position operates under the guidance of a team leader and does not have direct reports. Key Responsibilities • Design and implement Power Automate flows to streamline data collection, validation, and reporting processes., • Build and publish PowerApps applications, manage data sources, and utilize collections for dynamic data handling., • Parse and manipulate JSON data structures for backend integration and reporting automation., • Support backend development tasks using technologies such as Node.js, .NET, or Python, including error handling and logging., • Perform data scrubbing and transformation to ensure accuracy and integrity of numerical and structured data., • Analyze sales data to ensure customer contract compliance and validate required payments for contractual obligations such as rebates., • Develop and maintain dashboards and analytical tools that provide actionable insights into sales performance and business operations., • Perform sales data analysis to aid strategic projects, territory alignments, and the execution of sales strategies., • Conduct ad hoc commercial data analyses to support field enablement and commercial initiatives., • Work collaboratively with cross-functional teams to synthesize data from various sources and deliver meaningful reporting., • Assist in creating materials for business reviews and performance updates., • Collaborate with business partners to automate and continuously improve reporting processes and tools., • Present complex data in a clear and concise manner for both field and internal stakeholders., • Communicate business-related issues and opportunities to management., • Ensure compliance with all relevant regulations, policies, and procedures., • Perform additional duties as assigned. Experience and Education • Bachelor’s degree in Business, Finance, Sales & Marketing, Contracting, or a related field., • A minimum of 3 years of progressive experience in Analytics, Commercial/Sales Operations, Finance, or a related field, preferably within the medical device, pharmaceutical, or healthcare industry., • Experience working in cross-functional, matrixed environments is highly preferred. Required Knowledge, Skills, and Abilities • Advanced proficiency in Excel (e.g., VLOOKUP, pivot tables, SUMIF) and data visualization tools (e.g., Tableau, Power BI, Qlik Sense)., • Strong critical thinking and problem-solving abilities., • Exceptional attention to detail., • Experience with database management and maintenance is preferred., • Proficiency in Microsoft Power Platform, including PowerApps and Power Automate., • Working knowledge of JSON structure, parsing, and manipulation., • Experience in backend development frameworks such as Node.js, .NET, or Python., • Ability to manage error handling and logging in backend scripts., • Demonstrated experience in data scrubbing, transformation, and cleanup projects., • Ability to manage competing priorities and deliver high-quality work under tight deadlines. Get a complete career fit with Kelly®. You’re looking to keep your career moving onward and upward, and we’re here to help you do just that. Our staffing experts connect you with top companies for opportunities where you can learn, grow, and thrive. Jobs that fit your skills and experience, and most importantly, fit right on your path of where you want to go in your career. About Kelly Work changes everything. And at Kelly, we’re obsessed with where it can take you. To us, it’s about more than simply accepting your next job opportunity. It’s the fuel that powers every next step of your life. It’s the ripple effect that changes and improves everything for your family, your community, and the world. Which is why, here at Kelly, we are dedicated to providing you with limitless opportunities to enrich your life—just ask the 300,000 people we employ each year. Kelly Services is proud to be an Equal Employment Opportunity and Affirmative Action employer. We welcome, value, and embrace diversity at all levels and are committed to building a team that is inclusive of a variety of backgrounds, communities, perspectives, and abilities. At Kelly, we believe that the more inclusive we are, the better services we can provide. Requests for accommodation related to our application process can be directed to Kelly’s Human Resource Knowledge Center. Kelly complies with the requirements of California’s state and local Fair Chance laws. A conviction does not automatically bar individuals from employment. Kelly participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S. Acerca de kelly El trabajo lo cambia todo. Y en Kelly, estamos obsesionados con dónde te puede llevar. Para nosotros, se trata de algo más que simplemente aceptar su próxima oportunidad laboral. Es el combustible que impulsa cada próximo paso de tu vida. Es el efecto dominó que cambia y mejora todo para su familia, su comunidad y el mundo. Es por eso que, aquí en Kelly, estamos dedicados a brindarle oportunidades ilimitadas para enriquecer su vida; solo pregúntele a las 300,000 personas que empleamos cada año. Kelly Services se enorgullece de ser un empleador que ofrece igualdad de oportunidades de empleo y acción afirmativa. Damos la bienvenida, valoramos y aceptamos la diversidad en todos los niveles y estamos comprometidos a construir un equipo que incluya una variedad de orígenes, comunidades, perspectivas y habilidades. En Kelly, creemos que cuanto más inclusivos seamos, mejores servicios podemos brindar. Las solicitudes de adaptaciones relacionadas con nuestro proceso de solicitud pueden dirigirse al Centro de conocimiento de recursos humanos de Kelly. Kelly cumple con los requisitos de las leyes locales y estatales de Oportunidad Justa de California. Una condena no excluye automáticamente a las personas del empleo.