Financial Reports Analyst (Excel)

Working at Macro Solutions, a leading provider of IT and management consulting services, is an opportunity to collaborate with great people who have a passion for the services they provide to our clients. We are currently looking for an experienced Financial Reports Analyst (Excel) to join one of our long term Federal projects in Washington, DC. Client required candidates must be a US citizen.

Seeking interested candidates with 4 years of experience with Excel supporting accounting analysis. This person would work with accountants/CPAs to understand their business needs and requirements and bring them to fruition using advanced Microsoft Office tools. We are looking for candidates with strong Excel skills, including macro and VBA development, and a desire to enhance those skills in a challenging, high visibility environment. Strong analytical and written and oral communication skills. Ability to support business process and systems improvement efforts.

Key Responsibilities:

• Develop and support complex accounting models using Excel.
• Identify opportunities for improvements though process change and automation.
• Translate complex accounting processes into sophisticated financial models with built-in reconciliations.
• Document models and processes supported by the Excel models.
• Develop improvements or new capabilities either within Excel or in conjunction with other data analytics tools and databases.

Education and Required Experience:

• BA/BS or equivalent and 4 years of relevant experience.
• Advanced skills in Microsoft Excel, including VBA.
• Must have the ability to pass a Federal background investigation.
• Knowledge of and experience in GAAP accounting.
• Strong understanding of data reconciliation or migration across a variety of data platforms, formats, and technologies.
• Strong analytical and written and oral communication skills.
• Ability to work both independently and with a team to solve problems.
• Self-starter: quick to learn and put new skills to use.
• Ability to handle efficiently and effectively multiple and shifting priorities while meeting deadlines.

Desired Experience

• Experience with Federal accounting.
• Certified Public Accountant (CPA) and/or Certified Government Financial Manager (CGFM) certification.

Macro Solutions is a woman-owned IT and management consulting firm that helps government organizations select, implement, integrate and maintain critical business solutions. A relationship company at our core, we pride ourselves on building high-touch, high-trust environments for our clients and partners, at every level of our business. Assessed at CMMI Maturity Level 3 for both Development and Services and certified with the following- ISO 9001:2015, ISO 20000-1:2011 for ITSM and ISO 27001:2013 for ISMS, Macro delivers honest, powerful results from the inside, outward.

Deeply invested in advancing long lasting employee relationships, our distinctive Consultant Care program ensures that our employees are always a priority at every level of the organization and has been integral to our 94% employee retention rate.

Along with a supportive environment and culture that thrives on dreaming big, getting things done and having fun together, Macro Solutions offers employees a full suite of competitive benefits, including health, dental, 401(k), and paid time off.

If you would like to learn more about Macro, are interested in joining our team, or would like to learn more about our Consultant Care program visit our website.

Macro Solutions is an Equal Opportunity Employer.