Project Environmental Data Analyst

APTIM • Tampa, FL

2d

About The Position

APTIM is seeking a Project Environmental Data Analyst to work exclusively on a Key Client National Account. The role manages client and vendor datasets in various formats and turns them into reliable datasets, project databases, and useful Power BI dashboards. The analyst partners 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. Advanced Microsoft Excel and Power BI skills, sound analytical judgment, and the ability to deliver accurate, understandable information are central to the position. Environmental data and AI experience are valued but not required.

The analyst combines, cleans, standardizes, and reconciles information from Excel workbooks, client exports, vendor reports, and project databases; analyzes data across sites, periods, and sources; and develops repeatable reporting processes and structured datasets. The role also includes validating results against source records, documenting assumptions and exceptions, coordinating technical interpretation with environmental specialists, maintaining tools and refresh processes, and managing assigned deliverables with limited day-to-day supervision.

APTIM is a professional solutions firm specializing in environmental, sustainability, resilience, and infrastructure solutions for government agencies, commercial and industrial clients, and energy customers. The company describes its purpose as enhancing environmental quality, people’s wellbeing, community resilience, and employee opportunity.

Requirements

• Bachelor’s degree in data analytics, information systems, computer science, or a related field.
• At least 5 years of experience in data analysis, data management, and supporting 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.

Nice To Haves

• 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 coordinating cross-functional teams, managing schedules and deliverables, communicating risks and priorities, and supporting account managers with client project execution.
• Experience applying AI tools to data extraction, reconciliation, analysis, or workflow automation, while validating outputs and appropriately protecting client information.

Responsibilities

• 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.
• Transform multiple streams of raw data into automated reporting formats using data management, automation, and interactive business intelligence.
• Combine, clean, standardize, and reconcile data from Excel workbooks, client exports, vendor reports, and project databases; resolve inconsistent identifiers, formats, dates, units, duplicate records, and missing information.
• Analyze datasets across sites, reporting periods, and sources to identify trends, discrepancies, exceptions, and opportunities for improvement, and explain findings and 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 visualizations tailored to client needs.
• Evaluate data collection and reporting workflows and develop repeatable Excel and Power Query processes to 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.
• Validate calculations and dashboard results against source records; document reconciliation checks, assumptions, and unresolved exceptions; coordinate technical interpretation with environmental specialists.
• Maintain tools through data refreshes, troubleshooting, updates, and change testing to ensure accuracy.
• Manage assigned data deliverables across program datasets, estimate effort, meet agreed schedules, and communicate priorities and issues with limited day-to-day supervision.

Benefits

• Medical, vision, and dental insurance, with choices among five metallic levels and several carriers through the APTIM Benefits Marketplace.
• 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, subject to eligibility under company policy and applicable law.
• 401(k) plans through the Aon Pooled Employer Plan (PEP); eligibility depends on business unit.
• Respect and flexibility to live a full life at work and at home.
• Investment in personal and professional development.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level