Quantitative Analyst

Quantitative Analyst page is loaded## Quantitative Analyst locations:
Dearborn, MItime type:
Full time posted on:
Posted Todayjob requisition :
R2053

One Magnify is a global performance marketing organization working at the intersection of brand marketing, technology, and analytics. The Company’s core offerings accelerate business, amplify real-time results, and help set their clients apart from their competitors. One Magnify partners with clients to design, implement and manage marketing and brand strategies using analytical and predictive data models that provide valuable customer insights to drive higher levels of sales conversion.

One Magnify’s commitment to employee growth and development extends far beyond typical approaches. We take great pride in fostering an environment where each of our 700+ colleagues can thrive and achieve their personal best. One Magnify has been recognized as a Top Workplace, Best Workplace and Cool Workplace in the United States for 10 consecutive years and recently was recognized as a Top Workplace in India.

We are seeking a skilled Analyst to act as the technical execution engine for a complex financial model validation project.
*
* What you’ll do:

**
* ** Advanced Excel Forensic Review
** Deconstruct highly sophisticated third-party Excel models by tracing and deciphering intricate logic, including VBA macros, deeply nested formulas, and iterative calculation loops. Able to uncover how interest and payment calculations are constructed, even when the methodology is embedded within layered or opaque spreadsheet structures.
* ** Python Implementation
** Translate financial logic and requirements into robust, well-structured Python scripts. Build independent calculation engines capable of generating accurate amortization schedules and detailed cash flow outputs while maintaining scalability and code transparency.
* ** Reconciliation and Variance Analysis
** Complete side-by-side comparisons between Python-generated outputs and existing Excel models using sample datasets. Investigate variances down to the penny, identifying whether discrepancies stem from data inconsistencies, coding errors, or nuanced calculation logic embedded within Excel formulas or macros.
*
* What you’ll need:

**
* ** Advanced Excel Proficiency
** Must be an Excel power user with the ability to read, trace, and debug VBA, macros, and complex nested formulas. Able to audit spreadsheets with a closed system, reverse engineer calculations, and clearly understand the economic reasoning and math driving the models.
* ** Python Proficiency
** Demonstrated ability to build structured, modular calculation engines and data processing scripts that translate complex spreadsheet logic into scalable code. Capable of implementing high precision financial calculations and automating sophisticated validation routines.
* ** Financial Domain Knowledge in Lending
** Deep understanding of amortization and loan mechanics, with an intuitive grasp of how interest accrues, how principal is reduced, and how payment schedules are structured, adjusted, and validated.
** Benefits
* * We offer a comprehensive benefits package including medical, dental, 401(k), paid holidays, vacations, and more.

Whether it’s awareness, advocacy, engagement, or efficacy, we move brands forward with work that connects with audiences and delivers results. Through meaningful analytics, engaging communications and innovative technology solutions, we help clients tackle their most ambitious projects and overcome their biggest challenges.
** We are an equal opportunity employer
** We believe that Innovative ideas and solutions start with unique perspectives. That’s why we’re committed to providing every employee a workplace that’s free of discrimination and intolerance. We’re proud to be an equal opportunity employer and actively search for like-minded people to join our team.

We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform job functions, and to receive benefits and privileges of employment. Please contact us to request accommodation.locations:
Dearborn, MItime type:
Full time posted on:
Posted Today
#J-18808-Ljbffr