Database Developer

Company Description

Work with Us. Change the World.

At AECOM, we're delivering a better world. Whether improving your commute, keeping the lights on, providing access to clean water, or transforming skylines, our work helps people and communities thrive. We are the world's trusted infrastructure consulting firm, partnering with clients to solve the world’s most complex challenges and build legacies for future generations.

There has never been a better time to be at AECOM. With accelerating infrastructure investment worldwide, our services are in great demand. We invite you to bring your bold ideas and big dreams and become part of a global team of over 50,000 planners, designers, engineers, scientists, digital innovators, program and construction managers and other professionals delivering projects that create a positive and tangible impact around the world.

We're one global team driven by our common purpose to deliver a better world. Join us.

Job Description

AECOM TechWorks has supported our customers in some of their most challenging times. AECOM has helped both public and private sector clients collect, manage, process, store and exploit data for thousands of damaged structures, hundreds of thousands of square miles of imagery, dozens of critical infrastructure components, and has deployed dozens of solutions on mobile, tablet, desktop, and browser-based platforms. Our portfolio of meaningful and high-profile projects continues to expand.

The successful candidate will support AECOM TechWorks in in data analytics, leveraging interdisciplinary techniques to extract knowledge and insights from data in various structured and unstructured forms. We're looking for someone to join our data team who is focused on leveraging data assets to deliver actionable and meaningful insights using analytics to our customers. The candidate will work with large and varied data sets, from multiple data sources, to conduct statistical analysis, generate concise reporting, and present recommendations to clients for future project deliverables. The home office for this position will be Germantown, MD but the position can be hybrid at any AECOM East Coast office. The expectation of the candidate selected for this position is that they will of work collaboratively with the team by utilizing Microsoft Teams, JIRA, Confluence and other collaboration and development tools.

Responsibilities

• Assimilate, validate, analyze, and summarize vast quantities of data into information and insights
• Assist project teams with writing complex queries, stored procedures and views to automate processes and visualize data
• Maintain up-to-date data processes and re-architect as needed based on more advanced and modernized systems/trends.
• Develop, update, implement and maintain procedures
• Develop and prepare reports and relevant presentations
• Proven ability to work in a fast-paced, team environment. Collaborate with other data analysts, developers, testers, managers, and clients (internal and external)

Qualifications

Minimum Requirements

• BA/BS + 2 years of related experience or demonstrated equivalency of experience and/or education or AA/AS + 4 years of related experience or demonstrated equivalency of experience and/or education or HS/GED + 6 years of related experience or demonstrated equivalency of experience and/or education.
• Professional experience developing and utilizing relational databases including SQL Server and MySQL.
• Database experience to include writing SQL queries, views and stored procedures.
• Due to the nature of the work, U.S. Citizenship or Green Card is required.

Preferred Qualifications

• Professional experience developing data models using standard diagramming techniques.
• Professional experience with open-source analysis tools, big data and business intelligence technologies.
• Professional experience and knowledge of open-source spatial data tools including PostgreSQL.
• Professional experience and coding knowledge using Python.
• Ability to learn new software and technologies quickly.
• Excellent verbal and written skills.

Additional Information

• This position does not offer relocation assistance.
• Sponsorship for US Employment Authorization is not available now or in the future for this position.

About AECOM 

AECOM is proud to offer comprehensive benefits to meet the diverse needs of our employees. Depending on your employment status, AECOM benefits may include medical, dental, vision, life, AD&D, disability benefits, paid time off, leaves of absences, voluntary benefits, perks, flexible work options, well-being resources, employee assistance program, business