Data Analyst

MKA International, Inc.

Hagerstown (MD)

On-site

USD 42,000 - 54,000

Full time

44 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

401(k) with matching
Health, dental, vision, and life保险
Flexible spending account
Paid time off
Retirement plan

Job summary

MKA International, Inc. in Hagerstown, MD is seeking a Data Analyst to support its construction consulting and engineering team 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 through correspondence, presentations with charts, and occasional project meetings or site visits.

Qualifications

  • 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 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 environment.
  • Capability to work on a variety of projects simultaneously.
  • Knowledge of accounting and strong mathematical ability.
  • General construction background preferred.

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.

Skills

Advanced MS Office
Strong communication
Attention to detail
Multitasking
Time management
Organizational skills
Mathematical ability
Construction background

Tools

Excel
Word
PowerPoint
VLOOKUP
DATE
TEXT
IF
TRUE
Concatenate
Text to Columns
Removing Duplicates
Pivot tables

Job description

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?
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Onsite Construction Data Analyst - Reports & Analytics Pro
Onsite Construction Data Analyst - Reports & Analytics Pro

MKA International, Inc. • Hagerstown (MD)

On-site
USD 42,000 - 54,000
401(k) with matching
Health, dental, vision, and life保险
Flexible spending account
+2
Construction Contract Administrator & On-Site Liaison
Construction Contract Administrator & On-Site Liaison

McKinley Architecture and Engineering • Charleston (WV)

On-site
USD 55,000 - 75,000
Construction Contract Administrator
Construction Contract Administrator

McKinley Architecture and Engineering • Charleston (WV)

On-site
USD 55,000 - 75,000
Construction Contract Administrator
Construction Contract Administrator

Beyondmk • Charleston (WV)

On-site
USD 50,000 - 70,000
Scheduling / Cost Engineer
Scheduling / Cost Engineer

MKA International, Inc. • Washington

On-site
USD 70,000 - 130,000
401K match
ESOP participation
Medical insurance
+1
Project Manager
Project Manager

Beyondmk • Marietta (OH)

On-site
USD 70,000 - 90,000
Project Management Analyst
Project Management Analyst

Metric Systems LLC • Oklahoma City (OK)

On-site
USD 42,000 - 66,000
Scheduling / Cost Engineer
Scheduling / Cost Engineer

MKA International, Inc. • Boise (ID)

On-site
USD 70,000 - 130,000
401K match
ESOP
Medical insurance
+3
Scheduling / Cost Engineer
Scheduling / Cost Engineer

MKA International, Inc. • Houston (TX)

On-site
USD 70,000 - 130,000
401K match
ESOP participation
Medical, dental, and vision
+1
Data Analyst II
Data Analyst II

Management-Science-Associates,-Inc.-1 • United States

Remote
USD 65,000 - 85,000