Environmental Data Specialist

4 weeks ago

Philadelphia, United States AKRF, Inc. Full time
Job DescriptionJob Description

Founded in 1981, AKRF is an award-winning consulting firm with 400 professionals bringing the value of strategic thinking to our land development, transportation, energy, and water clients. We serve our clients through a commitment to technical excellence across our portfolio of professional services, while always acting with integrity and fostering a culture of innovation, collaboration, and environmental stewardship. Offices are located throughout New York, New Jersey, Connecticut, Pennsylvania, Maryland, and Virginia, and the company completes projects around the country.

Professionals join and remain at AKRF for our corporate-casual environment that values flexible work schedules and locations, and balances award-winning planning, engineering, and environmental projects with social impact initiatives, charitable giving, and plenty of fun and games. Our firm fosters a diverse, equitable, and inclusive environment where employees are respected and valued in honor of their identities; we strive to deliver on this promise every day.

The Environmental Data Specialist position will provide in-house support to the Philadelphia Water Department’s (PWD’s) Green Stormwater Infrastructure (GSI) Monitoring, Analysis, and Research Support (MARS) group within the Office of Watersheds (OOW). The OOW is part of the Planning and Environmental Services Division of PWD. A watershed management planning process led to the decision to take the green approach to managing the City’s Combined Sewer Overflows (CSOs). This has evolved into one of the largest green stormwater infrastructure (GSI) programs in the country, known as Green City, Clean Waters.

Job Responsibilities:

  • Develop, document, and maintain the PostgreSQL database and scripting infrastructure used to store GSI monitoring data, fieldwork recordkeeping, and associated datasets necessary for GSI performance analysis.
  • Write, update, and maintain a library of R scripts used for calculating GSI performance metrics.
  • Maintain and modify systems of automated scripts that move data between locations (ETL).
  • Create, modify, and maintain R Shiny web applications to support the fieldwork team as their responsibilities evolve overtime.
  • Train new hires and co-ops in databases, R, and scripting.
  • Program in R and SQL, with occasional forays into Python or Windows batch files.
  • Perform data analysis leveraging the available data in PWD databases including water level data, GIS data, SMP design metrics, etc. to inform the decision-making process within the group such as identifying monitoring candidates.
  • Prepare and present written reports for technical and non-technical audiences, including OOW colleagues, peer groups within PWD, PWD executives, and regulatory bodies.
  • Think critically about the long-term sustainability of technology projects, ensuring that future users and maintainers of their work are set up for success.
  • Take initiative in identifying areas within MARS workflows which can benefit from automation.
  • Take ownership of data products including web apps, ETL scripts, etc. and be proactive with identifying areas to improve data integrity, accuracy, and overall efficiency.
  • Communicate with the team members routinely to identify their data analysis and automation needs, receive feedback, and train them in the use of new software products.

Essential Requirements:

  • Required:
    • 1 plus years of experience coding using R, Python, SQL or similar.
    • 1 plus years of experience in data analysis, database administration, or software development.
    • Degree in engineering, environmental science, computer science, data analytics, data science or similar technical degree.
    • Ability to write and optimize SQL queries and knowledge databases such as PostgreSQL, Microsoft SQL Server, or similar.
    • Strong proficiency in R programming (shiny, rmarkdown, ggplot2, tidyverse, etc), including data manipulation, statistical analysis, and data visualization. Alternatively, experience in Python (django, matplotlib, NumPy, pandas, etc) or similar languages may be considered.
  • Preferred:
    • 1 plus years of work experience in water resources, stormwater, environmental science or similar fields.
    • Experience building R Shiny applications
    • Knowledge of software development methodologies such as agile, and best practices.
    • Proficiency in user interface (UI) and user experience (UX) principles.
    • Proficiency in using RStudio and Version Control software (Git).
    • Familiarity with POSIT Workbench, Connect, and/or Package Manager.
    • Familiarity with ArcGIS and geospatial data processing.

What AKRF is offering:

We provide employees with a benefit package that reflects our respect for your workplace contributions, professional goals, and personal priorities. The benefits program at AKRF includes:

  • Medical, Dental, Vision insurance
  • Vacation and Sick time
  • Flexible and hybrid work schedules and locations
  • 401(k) retirement plan with employer matching
  • Additional Voluntary Life Insurance
  • Short- and Long-Term Disability
  • Tuition Reimbursement
  • Training and professional development courses
  • Opportunities for community outreach through internal networks
  • Charitable donation match
  • Transit/parking program

Compensation will be commensurate with experience.

AKRF enforces a policy of equal employment opportunity in our daily operations. The firm has a demonstrated history of hiring, training, developing, promoting and retaining minority group members and women. All employment-related decisions are based solely on relevant criteria and without regard to race, color, religion, age, sex, pregnancy, national origin, age, physical or mental disability, marital status, sexual orientation, sexual identity, caregiver status, military/veteran status or citizenship status, or any other characteristic protected by federal, state, or local law.


  • Environmental Impact Assessment Specialist

    5 days ago

    Philadelphia, Pennsylvania, United States Environmental Resources Management (ERM) Full time

    Job Description**Job Summary**Environmental Resources Management (ERM) is seeking a highly skilled and experienced Senior Environmental Consultant to join our team. As a key member of our environmental impact assessment team, you will play a critical role in supporting our clients in the Mid-Atlantic and Eastern states.Key Responsibilities:Develop and...

  • Environmental Monitoring Specialist

    7 days ago

    Philadelphia, Pennsylvania, United States Actalent Full time

    Job DescriptionJob Title: Environmental Monitoring SpecialistJob Summary:The Environmental Monitoring Specialist is responsible for performing sampling and testing in support of manufacturing and validation activities, under the direction of a supervisor or higher. This role involves working in a team environment with various laboratory staff.Key...

  • Environmental Protection Specialist

    4 weeks ago

    Philadelphia, United States Federal Emergency Management Agency Full time

    What will I do in this position if hired? In this Environmental Protection Specialist position, you will serve as a Historic Preservation Specialist with the Region Three Mitigation Division. Typical assignments include: Ensuring compliance with environmental laws and regulations or mitigating adverse impacts to environmental and historic resources...

  • Environmental Protection Specialist

    4 weeks ago

    Philadelphia, Pennsylvania, United States Federal Emergency Management Agency Full time

    What will I do in this position if hired?In this Environmental Protection Specialist position, you will serve as a Historic Preservation Specialist with the Region Three Mitigation Division.Typical assignments include:Ensuring compliance with environmental laws and regulations or mitigating adverse impacts to environmental and historic resources as a result...

  • Environmental Noise Specialist

    3 weeks ago

    Philadelphia, United States Arcadis Full time

    Arcadis is the world's leading company delivering sustainable design, engineering, and consultancy solutions for natural and built assets. We are more than 36, people, in over 70 countries, dedicated to improving quality of life. Everyone has an important role to play. With the power of many curious minds, together we can solve the worlds most complex...

  • Environmental Protection Specialist

    2 weeks ago

    Philadelphia, United States Federal Emergency Management Agency Full time

    What will I do in this position if hired? In this Environmental Protection Specialist position, you will support the Region Three Mitigation Division. Typical assignments include: Serving as the point of contact for the Building Resilient Infrastructure and Communities (BRIC) Grant Program. Ensuring compliance with environmental laws and...

  • Utility Infrastructure Environmental Specialist

    2 weeks ago

    Philadelphia, Pennsylvania, United States Merjent Full time

    Position OverviewMerjent, Inc. is in search of an Environmental Compliance Specialist to collaborate with our esteemed clients and project teams in managing and securing permits for various utility infrastructure initiatives, primarily within Pennsylvania. These initiatives encompass both linear projects (such as natural gas and electric lines) and...

  • Senior Environmental Consultant

    5 days ago

    Philadelphia, Pennsylvania, United States Environmental Resources Management (ERM) Full time

    Job Description**Job Summary**Environmental Resources Management (ERM) is seeking a highly experienced and skilled Senior Environmental Consultant to join our team. As a key member of our Environmental Impact Assessment team, you will play a critical role in providing expert advice and guidance to clients on environmental impact assessment and permitting.Key...

  • Acoustic Engineer

    4 days ago

    Philadelphia, Pennsylvania, United States Arcadis Full time

    About ArcadisArcadis is a leading global design and engineering company that delivers sustainable solutions for natural and built assets.We are a team of over 36,000 professionals in over 70 countries, dedicated to improving quality of life. Our diverse team of experts works together to solve complex challenges and deliver impactful results.Role...

  • Industrial Hygienist/Environmental Specialist

    5 hours ago

    Philadelphia, Pennsylvania, United States Tetra Tech Full time

    About the RoleWe are seeking a highly motivated and detail-oriented Industrial Hygienist/Environmental Specialist to join our team at Tetra Tech. As an IH Specialist, you will play a critical role in overseeing the real-time collection of asbestos field data at various sites throughout the City of Philadelphia.Key ResponsibilitiesAssist a multidisciplinary...

  • Environmental Permitting Specialist

    2 months ago

    Philadelphia, United States Merjent Full time

    position summaryMerjent, Inc. (Merjent) is seeking an Environmental Permitting Specialist to work closely with our current clients and Merjent project team(s) to manage and permit a variety of utility infrastructure projects located primarily in the State of Pennsylvania. These projects include linear facilities (natural gas, electric, etc.) and stand-alone...

  • Environmental Protection Specialist

    1 month ago

    Philadelphia, Pennsylvania, United States Federal Transit Administration Full time

    As an Environmental Protection Specialist, you will:Meet with staff of other Federal agencies to discuss environmental processes, issues, and opportunities for expediting project delivery.Represent FTA in interagency environmental activities and workgroups for the primary purpose of developing improved interagency relationships and consultation procedures,...

  • Environmental Compliance Specialist for Utility Infrastructure

    4 days ago

    Philadelphia, Pennsylvania, United States Merjent Full time

    Job SummaryMerjent, a leading environmental consulting firm, is seeking an experienced Environmental Permitting Specialist to join our team. As a key member of our project team, you will be responsible for managing and permitting utility infrastructure projects in Pennsylvania.Key ResponsibilitiesWork closely with project managers to manage utility...

  • Lead Environmental Compliance Specialist

    2 days ago

    Philadelphia, Pennsylvania, United States Amtrak - The National Railroad Passenger Corporation Full time

    Job Summary:The Lead Environmental Compliance Specialist at Amtrak - The National Railroad Passenger Corporation plays a critical role in ensuring the company's compliance with the National Environmental Policy Act (NEPA) and related environmental regulations and permit requirements.Key Responsibilities:Develop and implement strategies to ensure Amtrak's...

  • Environmental (Abatement) Design Specialist

    3 months ago

    Philadelphia, United States Bristol Infrastructure Design Svcs, LLC Full time

    Job DescriptionJob DescriptionBristol Infrastructure Design Services, LLC, is hiring a Senior Environmental Design Specialist to support facilities and projects for the Department of Navy. The Environmental Design professional will have experience in prescribing, reviewing and upholding compliance with Remediation and Abatement of hazardous materials...

  • Environmental (Abatement) Design Specialist

    3 months ago

    Philadelphia, United States Bristol Infrastructure Design Svcs, LLC Full time

    Job DescriptionJob DescriptionBristol Infrastructure Design Services, LLC, is hiring a Senior Environmental Design Specialist to support facilities and projects for the Department of Navy. The Environmental Design professional will have experience in prescribing, reviewing and upholding compliance with Remediation and Abatement of hazardous materials...

  • Environmental Services Specialist

    2 weeks ago

    Philadelphia, Pennsylvania, United States Pennsylvania Medicine Full time

    Pennsylvania Medicine - Environmental Services Specialist Job OverviewPennsylvania Medicine is dedicated to delivering outstanding patient support, pioneering innovative research, and nurturing the next generation of medical professionals. Being part of our organization means working alongside leading experts across diverse disciplines. Position Summary:...

  • Environmental Protection Specialist

    7 hours ago

    Philadelphia, United States Federal Emergency Management Agency Full time

    What will I do in this position if hired? In this position, you will support Region 3 serving as an Historic Preservation Specialist to ensure compliance with all environmental and historic preservation laws and Executive Orders with a focus on Section 106 of the National Historic Preservation Act. Typical assignments include: Ensuring compliance...

  • Data Specialist

    1 week ago

    Philadelphia, United States Amazon Web Services (AWS) USA Full time

    Role DescriptionThis is a part-time remote role for a Data Specialist at Amazon Web Services (AWS) USA. The Data Specialist will be responsible for managing and analyzing large datasets, creating data visualizations and reports, and ensuring data accuracy and integrity. They will collaborate with cross-functional teams to support data-driven...

  • Environmental Health and Safety Specialist

    4 days ago

    Philadelphia, Pennsylvania, United States Axalta Full time

    About the RoleAxalta, a leading global coatings company, is seeking a highly motivated and detail-oriented Environmental Health and Safety (EHS) professional to join our team. As an EHS Specialist, you will play a critical role in ensuring a safe and compliant work environment, participating in various projects, and contributing to the development and...