2

Entry Level Data Analysis Excel Jobs in Lancaster, PA

Serve as a point of contact for ad hoc analysis * Translate complex data into actionable insights ... Advanced Excel skills (pivot tables, formulas, power query) * Experience with Power BI or similar ...

Serve as a point of contact for ad hoc analysis * Translate complex data into actionable insights ... Advanced Excel skills (pivot tables, formulas, power query) * Experience with Power BI or similar ...

Serve as a point of contact for ad hoc analysis * Translate complex data into actionable insights ... Advanced Excel skills (pivot tables, formulas, power query) * Experience with Power BI or similar ...

Junior Business Analyst

York, PA · Hybrid

$26 - $35/hr

Building and maintaining MS Excel databases from source data * Analysing client data using quantitative and qualitative methods to evaluate key performance indicators * Pressure testing source data ...

Junior Business Analyst

York, PA · On-site

$26 - $35/hr

Building and maintaining MS Excel databases from source data * Analysing client data using quantitative and qualitative methods to evaluate key performance indicators * Pressure testing source data ...

Lead Data Engineer

Reading, PA · On-site

$98K - $129K/yr

  • Retirement

Perform data analysis, quality improvements, dashboarding, reporting and visualization of data ... Our goal as an employer is to help you excel as an individual and as part of a team by providing ...

New

Associate Data Review Scientist

Lancaster, PA · On-site

$57K - $57K/yr

  • Medical

  • Dental

  • Vision

  • Life

  • Retirement

  • PTO

Eurofins companies offer a portfolio of over 200,000 analytical methods to evaluate the safety ... The Associate Scientist position is considered an entry-level opportunity that will allow for hands ...

Associate Data Review Scientist

Lancaster, PA · On-site

$57K - $57K/yr

  • Medical

  • Dental

  • Vision

  • Life

  • Retirement

  • PTO

Eurofins companies offer a portfolio of over 200,000 analytical methods to evaluate the safety ... The Associate Scientist position is considered an entry-level opportunity that will allow for hands ...

Conduct data analysis using Excel and SQL to monitor supplier performance, analyze procurement trends, and identify opportunities for cost reduction. * Coordinate logistics and inventory management ...

next page

Showing results 1-20

Entry Level Data Analysis Excel information

See Lancaster, PA salary details

$12

$31

$60

How much do entry level data analysis excel jobs pay per hour?

As of Aug 18, 2026, the average hourly pay for entry level data analysis excel in Lancaster, PA is $32.00, according to ZipRecruiter salary data. Most workers in this role earn between $20.58 and $35.72 per hour, depending on experience, location, and employer.

What is an entry level data analysis Excel job?

Entry level data analysis Excel jobs are positions designed for individuals who are new to the field of data analysis and primarily use Microsoft Excel to organize, analyze, and visualize data. These roles typically involve tasks such as cleaning data, creating reports, building charts, and using formulas to draw insights from datasets. They are ideal for recent graduates or career changers and often serve as a stepping stone to more advanced data analyst roles. Proficiency in Excel, attention to detail, and basic analytical thinking are key skills for these jobs.

What are the key skills and qualifications needed to thrive as an entry level data analyst using Excel?

To thrive as an Entry Level Data Analyst with an Excel focus, you need strong analytical skills, attention to detail, and a foundational understanding of data concepts, often supported by a relevant degree or coursework. Proficiency in Microsoft Excel, including formulas, pivot tables, and data visualization tools, is essential, and familiarity with basic data analysis software or certifications like Microsoft Office Specialist can be advantageous. Strong communication, problem-solving ability, and organizational skills help you interpret and present data insights effectively. These skills are crucial for accurately analyzing data, supporting business decisions, and contributing value to your team from the start.

What are some common challenges faced by entry level data analysts working primarily with Excel, and how can they be addressed?

Entry-level data analysts using Excel often encounter challenges such as managing large datasets that may exceed Excel’s capacity, ensuring data accuracy during manual data entry, and learning to use advanced functions like pivot tables, VLOOKUP, and data visualization tools effectively. To address these, it's helpful to become proficient with Excel shortcuts, regularly validate data for errors, and seek out training resources or mentorship from experienced team members. Collaborating closely with colleagues can also provide insights into best practices for organizing and analyzing data efficiently in a team environment.

What is the difference between Entry Level Data Analysis Excel vs Data Analyst?

AspectEntry Level Data Analysis ExcelData Analyst
Required SkillsBasic Excel, data entry, simple analysisAdvanced Excel, SQL, data visualization, statistical analysis
CertificationsNone or beginner Excel certificationsRelevant certifications like Microsoft Excel Expert, SQL certifications
Work EnvironmentEntry-level roles in various industries, often in office settingsMid-level roles in diverse industries, often involving complex data projects
Job ResponsibilitiesData entry, basic reporting, data cleaningData analysis, reporting, creating dashboards, interpreting data trends

Entry Level Data Analysis Excel focuses on basic data tasks using Excel, suitable for beginners. Data Analysts perform more complex analysis, often requiring additional skills like SQL and data visualization. While both roles work in office environments and require some Excel knowledge, Data Analysts handle more advanced responsibilities and typically have more certifications or experience.

What are the most commonly searched types of Data Analysis Excel jobs in Lancaster, PA?

The most popular types of Data Analysis Excel jobs in Lancaster, PA are:

What are popular job titles related to Entry Level Data Analysis Excel jobs in Lancaster, PA?

For Entry Level Data Analysis Excel jobs in Lancaster, PA, the most frequently searched job titles are:

What job categories do people searching Entry Level Data Analysis Excel jobs in Lancaster, PA look for?

The top searched job categories for Entry Level Data Analysis Excel jobs in Lancaster, PA are:

What cities near Lancaster, PA are hiring for Entry Level Data Analysis Excel jobs?

Cities near Lancaster, PA with the most Entry Level Data Analysis Excel job openings:

Infographic showing various Entry Level Data Analysis Excel job openings in Lancaster, PA as of August 2026, with employment types broken down into 1% As Needed, 81% Full Time, 15% Part Time, and 3% Contract. Highlights an 85% Physical, 4% Hybrid, and 11% Remote job distribution, with an average salary of $66,559 per year, or $32 per hour.

HVAC Inventory Analyst - Travel Required

Johnstone Supply

Lancaster, PA • On-site

$55K - $65K/yr

Full-time

Medical, Dental, Vision, Life, Retirement, PTO

Posted 20 days ago


Johnstone Supply rating

7.5

Company rating: 7.5 out of 10

Based on 107 frontline employees who took The Breakroom Quiz

175th of 419 rated retail wholesalers


Job description

As a full-time HVAC Inventory Analyst - Travel Required with Johnstone Supply, you'll play a key part in our data analysis, demand forecasting, and operational improvement initiatives. You'll need to be able to work with large datasets, uncover valuable patterns and insights, and use this information to support effective decision-making. If you think you're the right fit for the job, keep reading to learn more about joining our Lancaster, PA team!THE PERKS OF BECOMING OUR HVAC INVENTORY ANALYSTJohnstone Supply is a one-stop shop with a variety of options in unitary and specialty equipment, repair and replacement parts, and maintenance supplies for residential, light commercial, refrigeration, and facilities maintenance. We offer the products, programs, and services that help contractors of all sizes succeed. We're committed to being our customers' HVAC/R resource from start to finish.With a friendly, fun, and team-oriented environment, our employees know that they are not just a number. We value their hard work and show it through our bonuses, competitive pay, and great benefits.Salary: $55,000 to $65,000/year (based on qualifications)Benefits: Medical, dental, vision, prescription coverage, 401(k) with match, company-paid life insurance, paid holidays, generous PTO, and a supportive and respectful work environmentINVENTORY ANALYST: YOUR ROLEIn this data analysis position, you will:Maintain accurate records and review data to uncover trends and valuable insightsCollaborate with warehouse, operations, and procurement teams to keep stock levels high and processes efficientIdentify inefficient procedures and data discrepancies and take the appropriate corrective actionsTrack vital KPIs to measure your success (inventory turnover, stockout rate, carrying cost, forecast accuracy, inventory accuracy, and order fulfillment rates)Strategically forecast inventory demands and plan replenishments accordinglyValidate and cleanse inventory record dataBrainstorm methods for reducing carrying costs/stockouts and improving our overall efficiency/productivity/profitabilityOUR IDEAL INVENTORY ANALYSTBachelor's degree in a field like statistics, data analytics, business analytics, supply chain management, or industrial engineering3+ years of experience in inventory, operations, or supply chain analyticsHVAC Experience preferredAdvanced Excel proficiency, with knowledge of macros, pivot tables, and Power QueryExceptional data analysis skills and comfort with statisticsAnalytical problem-solving abilitiesWorking knowledge of inventory management and supply chain methodologiesAbility to use visualization tools (Power BI, Tableau, etc.) to present data insightsComfort using inventory management software and an ERP system like SAP, Oracle, or NetSuiteDo you have what it takes to drive substantial improvements and make a widely felt short- and long-term impact? Prove it by completing our short initial application today!Must have the ability to pass a background check

What Johnstone Supply employees say

Pay

Benefits

Hours and flexibility

Workplace

Get the full story on Breakroom