Back to jobs

Project Environmental Data Analyst

Tampa, FL, USA | Winter Garden, FL, USA | Lenexa, KS, USA | Dallas, TX, USA | Irvine, CA, USA | Pittsburgh, PA, USA

Actively hiring, first seen by us 3 days ago
Pay
$80,000–108,000/yearLocation-specific pay — pay source
Investment into your personal and professional development As of the date of this posting, a good faith estimate of the current pay range for this position is $80K to $108K per year. Compensation depends on several factors including: experience, education, key skills, geographic location of the position, client requirements, external market competitiveness, and internal equity among other employees within APTIM. Employee Benefits
Read the full posting
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting
  • Combine and clean data from Excel workbooks, client exports and vendor reports

  • Design, build and maintain Power BI reports and dashboards

  • Build and maintain project databases with validation rules and data dictionaries

  • Validate calculations and dashboard results against source records

  • Own data refreshes, troubleshooting and updates for existing tools

From the employer’s posting
Combine, clean, standardize, and reconcile data across multiple Microsoft Excel workbooks, client data exports, vendor reports, and project databases
Design, build, and maintain Power BI reports and dashboards, including Power Query transformations, data models, relationships, DAX measures, filters, and clear visualizations tailored to client needs.
Build and maintain project databases and structured datasets, including tables, unique identifiers, relationships, validation rules, and data dictionaries
Validate calculations and dashboard results against source records; document reconciliation checks, assumptions, and unresolved exceptions
Own ongoing tool maintenance, including data refreshes, troubleshooting, updates, and change testing to ensure accuracy.

What you’ll bring

All qualifications

Core experience

  • Bachelor’s degree in data analytics, information systems, computer science, or a related field.
  • Ability to translate loosely defined reporting needs into working solutions, organize concurrent assignments, document methods, and explain results clearly to nontechnical users.

Preferred experience

  • Experience with environmental or EHS data, such as hazardous waste, stormwater, inspection findings, compliance tracking, or sustainability metrics; experience supporting consulting or client project delivery.
  • SQL querying skills and experience with database platforms or environmental data management systems.
  • Experience with Power Automate, VBA, Python, or similar tools to automate data preparation and reporting.
  • Experience applying AI tools to data extraction, reconciliation, analysis, or workflow automation, with validation of outputs and appropriate protection of client information.
Qualification wording
Bachelor’s degree in data analytics, information systems, computer science, or a related field.
Ability to translate loosely defined reporting needs into working solutions, organize concurrent assignments, document methods, and explain results clearly to nontechnical users.
Experience with environmental or EHS data, such as hazardous waste, stormwater, inspection findings, compliance tracking, or sustainability metrics; experience supporting consulting or client project delivery.
SQL querying skills and experience with database platforms or environmental data management systems.
Experience with Power Automate, VBA, Python, or similar tools to automate data preparation and reporting.
Experience applying AI tools to data extraction, reconciliation, analysis, or workflow automation, with validation of outputs and appropriate protection of client information.
Education & alternatives
Basic Qualifications: - Bachelor’s degree in data analytics, information systems, computer science, or a related field. - Minimum of 5 years of experience in data analysis, data management, and support of tools used by project teams or clients.

Benefits in the posting

Full benefits wording
  • APTIM Environmental & Infrastructure, llc is committed to providing an extensive range of benefits that protect and promote the health and financial well-being of our employees and their families through the APTIM Benefits Marketplace https://aptim.makeityoursource.com/.
  • Medical, vision, and dental insurance: Through the marketplace, our employees can choose benefits from five metallic levels and several carriers to find the right benefits that work for them in their location.
  • Company paid and optional Life insurance
  • Short-term and long-term disability insurance
  • Paid holidays, vacation, and sick leave (eligibility based on company policy and applicable law)
  • 401(k) APTIM offers three 401k plans through the Aon Pooled Employer Plan (PEP). The specific plan you are eligible for depends on the business unit you are in. The details of the largest plan are found here:
  • APTIM 401(k) Guide
  • APTIM - Helpful Documents

From the employer’s posting.

About APTIM

APTIM enhances the quality of the environment, wellbeing of people, resilience of communities, and opportunity for employees to make a difference, not just a living.

In the employer’s words · Read in context

Apply at APTIM

Posting record

Report an error

Actively hiringFirst seen by us 3 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20263 days ago
Recorded sightings
4
Last seen by us
Nov 21, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

Lower than most similar jobs

$80K–$108K against $95K–$145K, the middle half of what similar US postings state.

From 2,327 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 3

Early. Similar jobs usually come down between day 5 and day 43.

From 16,009 similar postings that came down. Coming down is not always a hire.

APTIM is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • VBA
  • Excel
  • Power BI
  • Power Query
Where the posting names them
- SQL querying skills and experience with database platforms or environmental data management systems. - Experience with Power Automate, VBA, Python, or similar tools to automate data preparation and reporting. - Project management experience, including coordinating with cross-functional teams, managing schedules and deliverables, communicating risks and priorities, and supporting account managers to deliver successful client project execution.
- Experience with environmental or EHS data, such as hazardous waste, stormwater, inspection findings, compliance tracking, or sustainability metrics; experience supporting consulting or client project delivery. - SQL querying skills and experience with database platforms or environmental data management systems. - Experience with Power Automate, VBA, Python, or similar tools to automate data preparation and reporting.
Job Overview: APTIM is seeking a Project Environmental Data Analyst that will work exclusively on a Key Client National Account to manage client and vendor data sets presented in various formats and turn them into reliable datasets, project databases, and useful Power BI Dashboards. The Environmental Data Analyst will work with project managers and technical specialists to understand reporting needs, recommend meaningful metrics and trend analyses, evaluate data workflows, and independently build and maintain tools from initial requirements through ongoing use. The successful candidate will have advanced Microsoft Excel and Power BI skills, sound analytical judgment, and the ability to deliver accurate, understandable information that supports client reporting and project decisions. Environmental data and AI experience are valued but are not required. Key Responsibilities/Accountabilities:
- Demonstrate expertise in data management, automation, and interactive business intelligence to transform multiple streams of raw data into automated reporting formats. - Combine, clean, standardize, and reconcile data across multiple Microsoft Excel workbooks, client data exports, vendor reports, and project databases; resolve inconsistent identifiers, formats, dates, units, duplicate records, and missing information. - Analyze datasets across sites, reporting periods, and data sources to identify trends, discrepancies, exceptions, and opportunities for improvement; explain findings and data limitations to the project team.
- Minimum of 5 years of experience in data analysis, data management, and support of tools used by project teams or clients. - Advanced Microsoft Excel proficiency, including complex formulas, lookup functions, PivotTables, data validation, Power Query, and combining and reconciling data across workbooks. - Demonstrated Power BI development experience including data preparation, relational modeling, DAX calculations, report design, publishing, and maintaining refresh processes in Power BI Service.
- Analyze datasets across sites, reporting periods, and data sources to identify trends, discrepancies, exceptions, and opportunities for improvement; explain findings and data limitations to the project team. - Design, build, and maintain Power BI reports and dashboards, including Power Query transformations, data models, relationships, DAX measures, filters, and clear visualizations tailored to client needs. - Evaluate existing data collection and reporting workflows; develop repeatable Excel and Power Query processes that reduce manual work and improve consistency and timeliness.
- Advanced Microsoft Excel proficiency, including complex formulas, lookup functions, PivotTables, data validation, Power Query, and combining and reconciling data across workbooks. - Demonstrated Power BI development experience including data preparation, relational modeling, DAX calculations, report design, publishing, and maintaining refresh processes in Power BI Service. - Ability to translate loosely defined reporting needs into working solutions, organize concurrent assignments, document methods, and explain results clearly to nontechnical users.
- Design, build, and maintain Power BI reports and dashboards, including Power Query transformations, data models, relationships, DAX measures, filters, and clear visualizations tailored to client needs. - Evaluate existing data collection and reporting workflows; develop repeatable Excel and Power Query processes that reduce manual work and improve consistency and timeliness. - Build and maintain project databases and structured datasets, including tables, unique identifiers, relationships, validation rules, and data dictionaries that support reliable analysis and reporting.

Your next step

Complete your application on myjobs.adp.com. The employer’s form will show what is required.

Already applied? Track this application

Job description

View original posting ↗

Job Overview:

APTIM is seeking a Project Environmental Data Analyst that will work exclusively on a Key Client National Account to manage client and vendor data sets presented in various formats and turn them into reliable datasets, project databases, and useful Power BI Dashboards. The Environmental Data Analyst will work with project managers and technical specialists to understand reporting needs, recommend meaningful metrics and trend analyses, evaluate data workflows, and independently build and maintain tools from initial requirements through ongoing use. The successful candidate will have advanced Microsoft Excel and Power BI skills, sound analytical judgment, and the ability to deliver accurate, understandable information that supports client reporting and project decisions. Environmental data and AI experience are valued but are not required.

Key Responsibilities/Accountabilities:

  • Partner with project managers and technical specialists to define reporting objectives, identify relevant metrics and trends, and translate project questions into practical data tools and dashboards.
  • Demonstrate expertise in data management, automation, and interactive business intelligence to transform multiple streams of raw data into automated reporting formats.
  • Combine, clean, standardize, and reconcile data across multiple Microsoft Excel workbooks, client data exports, vendor reports, and project databases; resolve inconsistent identifiers, formats, dates, units, duplicate records, and missing information.
  • Analyze datasets across sites, reporting periods, and data sources to identify trends, discrepancies, exceptions, and opportunities for improvement; explain findings and data limitations to the project team.
  • Design, build, and maintain Power BI reports and dashboards, including Power Query transformations, data models, relationships, DAX measures, filters, and clear visualizations tailored to client needs.
  • Evaluate existing data collection and reporting workflows; develop repeatable Excel and Power Query processes that reduce manual work and improve consistency and timeliness.
  • Build and maintain project databases and structured datasets, including tables, unique identifiers, relationships, validation rules, and data dictionaries that support reliable analysis and reporting.
  • Validate calculations and dashboard results against source records; document reconciliation checks, assumptions, and unresolved exceptions, and coordinate technical interpretation with environmental specialists.
  • Own ongoing tool maintenance, including data refreshes, troubleshooting, updates, and change testing to ensure accuracy.
  • Manage assigned data deliverables across the program’s datasets, estimate effort, meet agreed schedules, and communicate priorities and issues with limited day-to-day supervision.

Basic Qualifications:

  • Bachelor’s degree in data analytics, information systems, computer science, or a related field.
  • Minimum of 5 years of experience in data analysis, data management, and support of tools used by project teams or clients.
  • Advanced Microsoft Excel proficiency, including complex formulas, lookup functions, PivotTables, data validation, Power Query, and combining and reconciling data across workbooks.
  • Demonstrated Power BI development experience including data preparation, relational modeling, DAX calculations, report design, publishing, and maintaining refresh processes in Power BI Service.
  • Ability to translate loosely defined reporting needs into working solutions, organize concurrent assignments, document methods, and explain results clearly to nontechnical users.

Preferred Qualifications:

  • Experience with environmental or EHS data, such as hazardous waste, stormwater, inspection findings, compliance tracking, or sustainability metrics; experience supporting consulting or client project delivery.
  • SQL querying skills and experience with database platforms or environmental data management systems.
  • Experience with Power Automate, VBA, Python, or similar tools to automate data preparation and reporting.
  • Project management experience, including coordinating with cross-functional teams, managing schedules and deliverables, communicating risks and priorities, and supporting account managers to deliver successful client project execution.
  • Experience applying AI tools to data extraction, reconciliation, analysis, or workflow automation, with validation of outputs and appropriate protection of client information.

About APTIM

APTIM enhances the quality of the environment, wellbeing of people, resilience of communities, and opportunity for employees to make a difference, not just a living. A leading professional solutions firm, we specialize in environmental, sustainability, resilience, and infrastructure solutions. Our team of experts provide these integrated solutions for forward-thinking government agencies, commercial and industrial clients, and energy customers. Together, we create sustainable and resilient communities for all.

What you can expect from APTIM:

  • Work that is worthy of your time and talent
  • Respect and flexibility to live a full life at work and at home
  • Dogged determination to deliver for our clients and communities
  • A voice in making our company better
  • Investment into your personal and professional development 

As of the date of this posting, a good faith estimate of the current pay range for this position is $80K to $108K per year. Compensation depends on several factors including: experience, education, key skills, geographic location of the position, client requirements, external market competitiveness, and internal equity among other employees within APTIM.

 

Employee Benefits  

APTIM Environmental & Infrastructure, llc is committed to providing an extensive range of benefits that protect and promote the health and financial well-being of our employees and their families through the APTIM Benefits Marketplace https://aptim.makeityoursource.com/. 

  • Medical, vision, and dental insurance: Through the marketplace, our employees can choose benefits from five metallic levels and several carriers to find the right benefits that work for them in their location.   
  • Company paid and optional Life insurance 
  • Short-term and long-term disability insurance 
  • Accident, Critical Illness, and Hospital Indemnity coverage
  • Paid holidays, vacation, and sick leave (eligibility based on company policy and applicable law)
  • 401(k) APTIM offers three 401k plans through the Aon Pooled Employer Plan (PEP).  The specific plan you are eligible for depends on the business unit you are in.  The details of the largest plan are found here: 

 

Watch our video:
About APTIM - In Pursuit of Better

 

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Investment into your personal and professional development As of the date of this posting, a good faith estimate of the current pay range for this position is $80K to $108K per year. Compensation depends on several factors including: experience, education, key skills, geographic location of the position, client requirements, external market competitiveness, and internal equity among other employees within APTIM. Employee Benefits
Location & working pattern

Tampa, FL, USA | Winter Garden, FL, USA | Lenexa, KS, USA | Dallas, TX, USA | Irvine, CA, USA | Pittsburgh, PA, USA

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.