Jr. Business Analyst

MPACT Strategic Consulting LLC

Posted 3 months ago

Full Time

Houston, Texas

Hybrid

Smart Summary

Responsibilities

The role involves analyzing complex datasets to provide actionable insights and managing financial operations including accounts payable and receivable. Additionally, the analyst supports consulting projects through research, client deliverables, and process improvement initiatives.

Qualifications

You have advanced data analytics and critical thinking skills, with the ability to manage accounts payable and receivable. You demonstrated strong proficiency in Microsoft Excel, including pivot tables and advanced formulas, and possess a solid understanding of databases like Power BI.

Must Have Skills for ATS

Microsoft Excel

Power BI

data analytics

accounts payable

accounts receivable

financial reporting

budgeting

pivot tables

XLOOKUP

VLOOKUP

Job Description

Houston TX/Hybrid

Job Title: Junior Business Analyst

MPACT Strategic Consulting LLC (MPACT) is a consulting and advisory services firm specializing in Emergency Management and Disaster Recovery, Human Services and Case Management, Compliance and Monitoring and business advisory services. 

Summary

Our team is looking for an entry level Business Analyst to assist our client project and accounting teams. This position will develop and lead analysis and will work alongside our finance team to manage accounts payable and receivable. The ideal candidate will have advanced data analytics skills and critical thinking skills with the ability to adapt to internal and external client needs. Strong creative, innovative, and leadership skills are essential to success.

Position Duties:

Data Analysis & Insights

  • Analyze complex datasets to uncover trends, risks, and opportunities 
  • Build and maintain reports and dashboards using advanced Excel 
  • Translate data into clear, actionable insights for both internal teams and clients 

Financial Management Operations Support

  • Perform accounts receivable and accounts payable tasks, including invoicing, payment tracking, and reconciliation 
  • Support financial reporting and ensure accuracy of internal financial records 
  • Assist with budgeting and project financial tracking as needed 

Client Engagement & Consulting Support

  • Support consulting projects by conducting research, analyzing data, and developing client deliverables 
  • Assist in identifying business challenges and recommending actionable solutions 
  • Collaborate with project teams to implement strategies that improve client operations and performance 
  • Prepare presentations, reports, and materials for client meetings 

Innovation & Continuous Learning

  • Contribute to process improvements and internal initiatives to enhance efficiency 
  • Demonstrate curiosity and adaptability in learning new tools, technologies, and consulting methodologies 
  • Stay informed on industry trends, emerging tools, and best practices 

Required Qualifications:

  • Pursuing or completed a bachelor’s degree in business, finance, economics, data analytics, or a related technical field 
  • Strong analytical, problem-solving, and critical thinking skills 
  • Advanced proficiency in Microsoft Excel (pivot tables, XLOOKUP/VLOOKUP, formulas, data analysis) Word and PowerPoint
  • Understanding of databases such as Power BI
  • Ability to manage multiple priorities and deadlines in a fast-paced consulting environment 
  • Strong written and verbal communication skills, including the ability to present information clearly 
  • High attention to detail and organizational skills 

Competencies:

  • Continuous Learning - Assesses own strengths and weaknesses; seeks feedback to improve performance; pursues training and development opportunities; strives to continuously build knowledge and skills; shares expertise with others.
  • Communication - Speaks clearly and persuasively in positive or negative situations; listens and gets clarification; responds well to questions; demonstrates group presentation skills; participates in meetings. Writes clearly and informatively; edits work for spelling and grammar; varies writing style to meet needs; presents numerical data effectively; able to read and interpret written information.
  • Dependability - Follows instructions, responds to management direction; takes responsibility for own actions; keeps commitments; commits to long hours of work when necessary to reach goals.; completes tasks on time or notifies appropriate person with an alternate plan.
  • Initiative - Volunteers readily; undertakes self-development activities; seeks increased responsibilities; takes independent actions and calculated risks; looks for and takes advantage of opportunities; asks for and offers help when needed.
  • Innovation - Displays original thinking and creativity; meets challenges with resourcefulness; generates suggestions for improving work; develops innovative approaches and ideas; presents ideas and information in a manner that gets others' attention.

The above job description is not intended to be an all-inclusive list of duties and standards of the position. 

MPACT Strategic Consulting LLC

We are a business advisory and consulting company focused on delivering iMPACTful solutions and innovation to public and private sector clients that empower them to achieve measurable and significant performance growth. MPACT Strategic Consulting works collaboratively with our clients to plan, design and implement programs and strategies that lead to better outcomes. Our team of professionals provides relevant experience and expertise to assist clients to implement solutions that are sustainable, based on best practices, and employ rigorous strategic analysis and innovation. Our team provides national capacity and capabilities that have led us to be trusted advisors that excel at planning, program management and deep technical assistance. MPACT works directly with our clients to augment their team’s collective capabilities and capacity to achieve lasting and significant performance growth and leadership. We develop custom solutions that yield the greatest value and competitive advantage for our clients. We match tailored solutions to how our client’s organization actually works.
Runway Icon
Boost Your Interview Chances

With Runway

See Your Fit for This Role

1-5 min

Your Score

?

Top Applicants

90%

Your Job Search Advantage

Key Gaps & Next Steps:

Address these in your resume & Interview

Top Strengths For This Role

Highlight these in your cover letter & interview

Your Interview Guide

A Personalized Interview Strategy

Freshest Opportunities

Never Miss a Good Fit

Get notified when jobs mach your criteria