MKA International, Inc. is hiring a Data Analyst to support its construction consulting and engineering team in Hagerstown, MD (onsite). In this full-time role, you will help turn incoming information into clear reports, cost and variance analyses, and spreadsheet-based insights using advanced MS Office skills. You will also collaborate as needed through correspondence, presentations with charts, and occasional project meetings or site visits.
Along with the chance to contribute directly to project work, MKA International, Inc. offers a comprehensive benefits package, including 401(k) with matching, health, dental, vision, and life insurance, flexible spending account, paid time off, and a retirement plan. The salary range for this position is $42,000 to $54,000 per year.
Responsibilities
- Prepare and edit correspondence, reports, spreadsheets, and presentations, including graphic elements like charts.
- Perform data entry and assist with comprehensive cost and variance analyses.
- Support efficient workflow by expediting tasks and initiating follow-up when needed.
- Independently systematize and distribute incoming materials.
- Create and maintain cost analysis spreadsheets by interpreting data and reviewing supporting documentation.
- May attend project meetings and site visits.
Requirements
- Excellent verbal and written communication with a professional approach.
- Advanced MS Office capabilities across Excel, Word, and PowerPoint.
- In Excel, strong knowledge of formula tools and the function library, including comfort with VLOOKUP, DATE, TEXT, and logical functions such as IF and TRUE.
- Experience with Concatenate, Text to Columns, Removing Duplicates, and building subtotals, including nested subtotal functions.
- Proficiency with pivot tables and the ability to insert and format graphic elements in charts.
- In PowerPoint, ability to create and format charts and diagrams, modify the slide master, set slide transitions and timings, and add movie and sound clips. Must be able to work with custom animation for text and graphics, and embed and link content.
- Strong organization with impeccable attention to detail.
- Ability to multi-task, prioritize, and meet deadlines in a fast-paced, time-sensitive environment.
- Capability to work on variety of projects simultaneously.
- Knowledge of accounting and strong mathematical ability.
- General construction background preferred.
Application Questions
- What is the highest level of education you have completed?
- What level of proficiency do you have in Microsoft Office [Basic, Intermediate, Advanced]?
- How would you rate your level of accounting experience and mathematical ability?
- When are you available to start work?