Data Analyst - Transportation

Michael Baker International - Charleston, WV3.8

Full-time
Save
Michael Baker International is a leading provider of engineering, development, intelligence and technology solutions with global reach and mobility. The firm offers a comprehensive range of innovative services and solutions in support of federal, state, and municipal governments, foreign allied governments, and a wide range of private development and commercial clients. Michael Baker International’s focus is on the safety and security of people across the world through planning and engineering improvements to infrastructure and the environment, and through protection of our quality of life and freedom in support of national and international security. With more than $1 billion in annual revenue, Michael Baker International has more than 5,000 employees in over 80 offices located across the U.S. and internationally, and is ranked as the 26th largest design firm in the U.S. by Engineering News Record (ENR). Michael Baker International’s Mission is to make a difference by providing innovative solutions to sustain the future and further the safety, security and quality of life for people across the globe by providing the highest level of expertise, unmatched quality and effective project teams for a diverse range of projects and clients. Michael Baker International offers excellent benefit packages that includes: Medical, Dental, Vision, Disability Insurance, Life Insurance, Flexible Spending Accounts, Additional Paid Time Off, Flex-Time, 401-K Retirement Plan, Tuition Reimbursement and Employee Credit Union. To learn more, please visit us on the web at www.mbakerintl.com . Michael Baker International is an EEO/Affirmative Action Employer - M/F/Disability/Veteran/e-Verify Employer

WHO WE ARE

Supported by more than 3,000 employees in nearly 100 locations across the United States, we provide a full continuum of engineering and consulting services, including design, planning, architectural, environmental, construction and program management. Our clients include U.S. federal, state and municipal governments, foreign allied governments, and a wide range of commercial clients. Michael Baker is committed to delivering a standard of excellence that fosters a culture of innovation, collaboration and technological advancement to help solve our clients' complex challenges.

GEOSPATIAL PRACTICE

We are a national leader in implementing straightforward approaches to development and deployment of scalable enterprise Geospatial Information Technology (GIT) solutions. Michael Baker International has differentiated itself and expanded its capabilities by using the latest technologies. For example, we use aerial, static and mobile Light Detection and Ranging (LiDAR) systems that accurately determine range, elevation, and other critical mapping data. With hundreds of Geographic Information Systems (GIS), survey, mapping and IT professionals in our Geospatial Practice across North America, Michael Baker International possesses in-house experience and resources to support all elements of your program needs, including: needs analysis, digitizing/data conversion, customized mapping applications, and systems documentation, implementation, and training.

DESCRIPTION

As a part of our Geospatial Information Technology Team, the Data Analyst works under the direction of a senior developer or data architect, performing data analysis using Microsoft SQL Server, T-SQL, DDL, SSIS, stored procedures and function. Most days will be spent in the office analyzing a process or workflow examining complex processes and procedures and systematically working through each step to determine where processes fail or are ineffective. Additional responsibilities include strong “data hygiene” and QA/QC; database maintenance, input and tracking of data, procedures and mitigating bugs or issues throughout the development process.

You will feel a sense of pride in knowing that you are helping Michael Baker International provide innovative solutions to application development challenges, big and small, and Making a Difference for the clients and communities we serve!

PROFESSIONAL REQUIREMENTS

Bachelor’s degree in computer science, engineering, mathematics, GIS, or a related field.

5-7 years of experience with Microsoft SQL Server, T-SQL, DDL, SSIS, stored procedures, function

Desired background in data modeling, data analysis, data optimization, ETL

Exposure to GIS with ability to map data in Esri ArcGIS for QA/QC purposes and review

Familiarity with Microsoft software development platform(.NET)

Transportation agency pavement inventory a plus