EHS Data Strategy & Reporting Analyst

Ampcus Inc; City of Albany (NY); On-site; USD 70,000 - 100,000; Full time

Benefits offered by this job

Health & Wellness benefits

Life Insurance

Retirement Savings: 401(k)

Job summary

Ampcus Inc. seeks an EHS Data Strategy & Reporting Analyst to modernize EHS operations by building digital processes, standardized workflows, and integrated dashboards consolidating safety, environmental, and compliance data into accessible systems.

Focus is on core Power BI dashboards and Maximo-based incident workflows to enable real-time insight. Responsibilities include designing structured data models, documenting data flows across Power BI, Maximo, SharePoint, and ClearPoint; developing

Qualifications

• Proven ability to model structured datasets for reporting and analytics.
• Strong Power BI skills including DAX, dataflows, and dashboards.
• Experience with Maximo data structures and logic.
• Ability to clean, transform, and validate data across sources.
• Ability to design automated data pipelines across systems.
• Ability to document processes and data transformations clearly.
• Excellent collaboration with EHS, IT, operations, and leadership.

Responsibilities

• Design structured data models to support EHS reporting and KPI tracking.
• Define and document data flows across Maximo, Power BI, SharePoint, ClearPoint.
• Develop standardized data intake, cleaning, transformation, and validation processes.
• Refine Power BI dashboards and migrate legacy reports to automated dashboards.
• Integrate data across systems to automate reporting and reduce manual work.
• Maintain documentation describing dashboard logic and business rules.
• Coordinate tasks, timelines, and deliverables for dashboard development.
• Track progress and communicate updates to stakeholders.

Skills

Data modeling

Data QA/QC

Data cleaning

Data pipelines

Documentation

Stakeholder collaboration

Analytical thinking

Dashboard troubleshooting

EHS domain knowledge

Education

Bachelor’s degree in a relevant field

Power BI Data Analyst (PL 300) or equivalent

Experience managing small projects

Project management tools (WBS, Gantt)

Tools

Power BI

Maximo

SharePoint

ClearPoint

Job description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title: EHS Data Strategy & Reporting Analyst

Job Summary:

This project modernizes EHS program operations by developing foundational digital processes, standardized workflows, and integrated dashboards that consolidate safety, environmental, and compliance data into consistent, accessible systems. The effort focuses on building core Power BI dashboards, establishing Maximo based incident and compliance workflows, and designing streamlined data processes that reduce manual work, improve accuracy, and enable real time insight. These initial components form the baseline needed to evaluate long term maintenance demands and determine future resource requirements.

Key Responsibilities:

• Design structured data models to support EHS reporting, compliance, and KPI tracking.
• Define and document data flows across Maximo, Power BI, SharePoint, ClearPoint, and other enterprise systems.
• Develop standardized, scalable processes for data intake, cleaning, transformation, and validation.
• Rebuild, refine, and standardize existing Power BI dashboards to improve reliability and usability.
• Migrate legacy or manual reporting tools into structured, automated dashboards.
• Integrate data across enterprise systems to automate reporting and reduce manual burden.
• Maintain documentation describing dashboard logic, calculations, assumptions, and business rules.
• Coordinate tasks, timelines, and deliverables related to dashboard development and data process improvements.
• Track progress, maintain project documentation, and communicate updates to stakeholders.

Required Qualifications:

• Strong data modeling and data architecture skills for building and managing structured datasets.
• Proficiency in Power BI, including DAX, dataflows, semantic models, and dashboard development.
• Experience with Maximo data structures, fields, and system logic.
• Ability to perform rigorous data QA/QC to ensure accuracy and reliability.
• Skill in cleaning, restructuring, and standardizing complex or legacy datasets.
• Ability to design automated data pipelines and integrate data across multiple enterprise systems (Power BI, Maximo, SharePoint, ClearPoint).
• Project management skills to plan, track, and deliver digital build-out work.
• Ability to clearly document processes, system logic, and data transformations.
• Strong analytical thinking for interpreting EHS, operational, and compliance data.
• Ability to troubleshoot data issues, system inconsistencies, and dashboard errors.
• Effective communication for collaborating with EHS, IT, operations, and leadership stakeholders.

Education & Certifications:

• Bachelor’s degree in a relevant field (e.g., Data Analytics, Information Systems, Computer Science, Engineering, Environmental Science).
• Equivalent combination of education and professional experience may be considered.0
• Microsoft Power BI Data Analyst (PL 300) or equivalent data analytics certification.
• Demonstrated experience managing small projects, strategic workstreams, or process improvement initiatives.
• Ability to apply basic project management tools (WBS, Gantt charts, schedules, stakeholder coordination, task tracking).

Benefits Overview:

• Health & Wellness: Comprehensive pre-tax health, dental, and vision insurance options.
• Life Insurance: Group term life insurance and voluntary life insurance coverage.
• Retirement Savings: 401(k) retirement savings plan to help you plan for your future.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.