Description This position will be based in one of the following office locations: St. Louis, MO; Austin, TX; Greenville, SC; or New Orleans, LA. DescriptionAdvantage Capital is an impact investor dedicated to using the lever of capital access to increase economic mobility, lift up underserved communities, create quality affordable housing and generate renewable energy. Our core business line has invested $2.5B in nearly 800 small businesses, the vast majority in highly distressed urban and rural neighborhoods. The firm has built a strong and successful track record of public-private partnerships with state and federal economic development organizations, creating over 70,000 permanent, quality jobs and facilitating the flow of billions of added investment dollars into these communities. Founded in 1992, Advantage employs over 180 people in offices across the country, including St. Louis, New Orleans, New York, Austin and Napa.Advantage’s Partner Services (ACPS) business line provides advisory services to third parties, largely in the area of New Markets Tax Credit finance, helping businesses, CDEs and investors accomplish their financial and programmatic goals. In addition to assisting with application preparation, revolving loan fund management and CDE operational support, ACPS helps QALICBs access NMTC financing from outside CDEs, through education, structuring, negotiation and closing. To date, ACPS Project consultants have collectively closed over $750 million in NMTC transactions in their careers.Location: St. Louis, MO; Austin, TX, Greenville, SC, or New Orleans, LAJob Summary:As an Impact Data Analyst, you will play a critical role in supporting our New Markets Tax Credit (NMTC) advisory services by contributing to the submission of highly competitive federal applications and supporting the marketing and closing of NMTC financing transactions. In this role, you will develop a deep understanding of diverse business models and gain comprehensive knowledge of the NMTC program and impact-driven investing. You will gain hands-on experience implementing advanced Excel formulas and VBA coding, developing data-driven insights, supporting capital-raising for high-impact projects, and occasional financial modeling. You will engage directly with upper management, collaborate with a dynamic team of experienced professionals, and learn the intricacies of NMTC, traditional investment parameters, and Advantage-specific impact metrics. Beyond technical expertise, you’ll develop strategic thinking through brainstorming, problem-solving, and bringing ideas to fruition, all while responding to real-world challenges in community-driven investment. This role provides a strong foundation for professionals looking to expand their knowledge, enhance their quantitative and qualitative skills, and build a well-rounded understanding of financial and impact analysis in a fast-paced, mission-driven environment. We are seeking candidates who are analytical, detail-oriented, and proficient in quantitative analysis and Excel modeling, with the ability to translate complex data into meaningful insights that support broader community investment strategies and specific NMTC financial transactions.Qualifications:Required:•Bachelor’s degree in economics, finance, business, data analytics, or a related field, or 2-4 years of relevant experience.•Strong quantitative analysis skills with proficiency in Excel modeling and advanced formulas.•Ability to work with large datasets, conduct data cleaning, and extract key insights for strategic decision-making.•Strong mathematics and analytical skills, with critical attention to detail and accuracy in work product.•Excellent communication skills, with the ability to convey complex ideas effectively to diverse audiences.•Entrepreneurial mindset, with a proactive approach to problem-solving, innovation, and identifying new opportunities.•Self-driven and highly motivated, with the ability to take initiative, work independently, and deliver high-quality results in a fast-paced environment.•Strong time management and proven ability to manage competing deadlines and priorities. Preferred:•Experience analyzing large public datasets, ensuring data integrity, and applying research-driven methodologies for decision-making.•Experience training individuals in data research and analytics, financial modeling, and/or Excel-based tools to enhance efficiency and data proficiency.•Familiarity with Power BI and/or VBA is a plus.Responsibilities •Create and maintain Excel-based models that allow for tracking and analysis of community investment activity to support data-driven decision-making.•Research and compile insightful company, industry, and impact data.•Conduct quantitative analysis of data sets, including past and prospective investment-related data.•Perform data cleaning to enhance quality and reliability.•Train team members on new tools and essential Excel skills to improve workflow efficiency.Perks at Advantage Capital•Competitive medical, dental and vision insurance•401(k) with company match•Employee assistance program•Employee stock program•Paid personal & vacation time•Life insurance, disability, and long-term care•HRA and HSA with annual company deposit•Firm-wide retreats•Service awards•Company swag•Holiday parties•Gym membership•Training & development opportunities•Paid parental leave•Community service opportunities#LI-ONSITE
