Environmental Data Analytics Lead - Power BI & Excel Expert

aptim; Irvine (CA); In loco; USD 80.000 - 108.000; Tempo pieno

Vantaggi offerti da questo lavoro

Medical insurance

Vision insurance

Dental insurance

401(k) plan

Paid holidays

Vacation & sick leave

Descrizione del lavoro

APTIM seeks a Project Environmental Data Analyst to manage client and vendor data sets, turning them into reliable datasets, project databases, and Power BI dashboards. You will work with project managers and environmental specialists to define reporting needs and metrics.

Advanced Excel and Power BI are required; experience with data automation and data workflows is valued. Environmental data experience is a plus but not required.

Competenze

• Bachelor’s degree in data analytics or related field.
• Minimum of 5 years of data analysis and data management experience.
• Advanced Excel, including complex formulas, PivotTables, data validation, Power Query.
• Power BI development experience with data modeling and DAX.
• Ability to translate reporting needs into working solutions and document methods.

Mansioni

• Define reporting objectives with project teams and translate questions into dashboards.
• Transform raw data into automated reporting formats using BI tools.
• Clean, reconcile, and standardize data across multiple sources and workbooks.
• Analyze data for trends, discrepancies, and improvement opportunities.
• Build and maintain Power BI reports, data models, and dashboards.
• Develop repeatable Excel and Power Query processes to improve timeliness.
• Create project databases with validation rules and data dictionaries.
• Validate calculations and document reconciliation checks with technical teams.
• Maintain data refreshes, troubleshooting, and change testing.
• Manage data deliverables and communicate priorities with limited supervision.

Conoscenze

Power BI

Advanced Excel

Power Query

DAX

SQL

Data validation

Formazione

Bachelor’s degree in data analytics

Strumenti

SQL databases

Python

Power Automate

Descrizione del lavoro

APTIM seeks a Project Environmental Data Analyst to manage client and vendor data sets, turning them into reliable datasets, project databases, and Power BI dashboards. You will work with project managers and environmental specialists to define reporting needs and metrics.

Advanced Excel and Power BI are required; experience with data automation and data workflows is valued. Environmental data experience is a plus but not required.