Data Analyst/Tool Developer

Atlanta, GA, United States

Bachelor's degree in computer science, computer science engineering, computer information systems, data science, economics, or another relevant field

3 years of professional full-time experience of business intelligence tool development

Advanced data visualization skills in PowerBI

Proficiency in Microsoft Office Suite including Word, Excel, and Powerpoint

Excellent verbal and written communication skills

Required Driving Statement

Do you have professional experience with database management, SQL querying, data modeling, online analytical processing, MS BI including Power Automate, Power Pivot, SSMS, etc.?

Do you have advanced analytical skills in at least one of Excel, ACCESS, R, or Python?

Are you willing to undergo a background check, in accordance with local law/regulations?

Please only include a resume no more than 2 pages

Bachelor's (Required)

Atlanta, GA 30303: Relocate before starting work (Required)

Responsibilities Under the supervision of project managers, this position will lead database management and tool development to support the daily operations of MMP as a consulting firm, and to support the data analysis and visualization for transportation planning and traffic engineering projects and studies

Analyze and understand business and organizational requirements in business intelligence

Transform business and organizational requirements into technical publications and design new systems

Develop data query systems or tools to assist in project and task management

Collect, compile, and review data

Design and manage database and data warehouse

Analyze historical, present, and future forecast data to support decision making

Identify the data requirements and develop custom charts

Design and map data models to provide insights for technical and non-technical audience

Develop data documentation about algorithm, parameter, model, and user guide

Prepare project memorandum and reports

Pay: $85,000.00 - $120,000.00 per year

8 hour shift

Qualifications Bachelor's degree in computer science, computer science engineering, computer information systems, data science, economics, or another relevant field

3 years of professional full-time experience of business intelligence tool development

Advanced data visualization skills in PowerBI

Proficiency in Microsoft Office Suite including Word, Excel, and Powerpoint

Excellent verbal and written communication skills

Required Driving Statement

Do you have professional experience with database management, SQL querying, data modeling, online analytical processing, MS BI including Power Automate, Power Pivot, SSMS, etc.?

Do you have advanced analytical skills in at least one of Excel, ACCESS, R, or Python?

Are you willing to undergo a background check, in accordance with local law/regulations?

Please only include a resume no more than 2 pages

Bachelor's (Required)

English (Required)

Atlanta, GA 30303: Relocate before starting work (Required)

Responsibilities Under the supervision of project managers, this position will lead database management and tool development to support the daily operations of MMP as a consulting firm, and to support the data analysis and visualization for transportation planning and traffic engineering projects and studies

Analyze and understand business and organizational requirements in business intelligence

Transform business and organizational requirements into technical publications and design new systems

Develop data query systems or tools to assist in project and task management

Collect, compile, and review data

Design and manage database and data warehouse

Maintain data security

Analyze historical, present, and future forecast data to support decision making

Identify the data requirements and develop custom charts

Build interactive and visually appealing dashboards and reports through PowerBI, Tableau, JavaScript (such as REST API), etc

Design and map data models to provide insights for technical and non-technical audience

Develop data documentation about algorithm, parameter, model, and user guide

Prepare project memorandum and reports

Benefits Pay: $85,000.00 - $120,000.00 per year

8 hour shift

Modern Mobility Partners, a female and minority-owned transportation planning and traffic engineering firm founded in January 2018, is looking for a Data Analyst / Tool Developer with an interest in transportation planning and traffic engineering field.

Under the supervision of project managers, this position will lead database management and tool development to support the daily operations of... MMP as a consulting firm, and to support the data analysis and visualization for transportation planning and traffic engineering projects and studies. Tasks may include but are not limited to:

· Analyze and understand business and organizational requirements in business intelligence.

· Transform business and organizational requirements into technical publications and design new systems.

· Develop data query systems or tools to assist in project and task management.

· Collect, compile, and review data

· Design and manage database and data warehouse

· Maintain data security

· Analyze historical, present, and future forecast data to support decision making

· Identify the data requirements and develop custom charts

· Build interactive and visually appealing dashboards and reports through PowerBI, Tableau, JavaScript (such as REST API), etc.

· Design and map data models to provide insights for technical and non-technical audience

· Develop data documentation about algorithm, parameter, model, and user guide

· Prepare project memorandum and reports

Required Qualifications

· Bachelor's degree in computer science, computer science engineering, computer information systems, data science, economics, or another relevant field.

· 3 years of professional full-time experience of business intelligence tool development

· Professional experience with database management, SQL querying, data modeling, online analytical processing, MS BI including Power Automate, Power Pivot, SSMS, etc.

· Advanced data visualization skills in PowerBI

· Proficiency in Microsoft Office Suite including Word, Excel, and Powerpoint

· Advanced data analytical skills in at least one of Excel/ACCESS/R/Python

· Excellent verbal and written communication skills

Required Driving Statement

Preferred Qualifications

· Master's degree in computer science, computer science engineering, computer information systems, data science, economics, or another relevant field

· Experience in full stack development

· Experience in optimizing SQL queries

· Experience in creating and running customized DAX queries

· Experience with deploying or publishing data dashboard tools including Tableau, JavaScript

· Scripting and programming language such as Excel VBA, R, Python.

· Experience with ArcGIS or QGIS

• *Relocation assistance is not available for this position**

Why Choose Modern Mobility Partners?

Learn transportation planning methods and practices from some of the most reputable transportation planners and project managers in the industry. Be part of an exciting new firm with great energy and a desire to push the envelope, think outside the box, and provide value to our clients and teaming partners.

This position offers a lot of hands-on experience and provides great opportunities to work on a variety of projects across different transportation arenas.

In 2020, Modern Mobility Partners was awarded Atlanta Business Chronicle’s Best Places to Work.

Modern Mobility Partners, LLC is an equal opportunity and affirmative action employer. Women, minorities, people with disabilities and veterans are strongly encouraged to apply. We are dedicated to a policy of non-discrimination in employment on any basis including race, creed, color, religion, national origin, sex, age, disability, marital status, sexual orientation, gender identity, citizenship status, disability, veteran status, or any other basis prohibited by law.

Job Type: Full-time

Pay: $85,000.00 - $120,000.00 per year

Experience level:

• 3 years

Schedule:

• 8 hour shift

• Monday to Friday

Application Question(s):

• Do you have professional experience with database management, SQL querying, data modeling, online analytical processing, MS BI including Power Automate, Power Pivot, SSMS, etc.?

• Are you proficient in Microsoft Office Suite?

• Do you have advanced analytical skills in at least one of Excel, ACCESS, R, or Python?

• Are you willing to undergo a background check, in accordance with local law/regulations?

• Please only include a resume no more than 2 pages.

Education:

• Bachelor's (Required)

Language:

• English (Required)

Ability to Commute:

• Atlanta, GA 30303 (Required)

Ability to Relocate:

• Atlanta, GA 30303: Relocate before starting work (Required)

Work Location: Hybrid remote in Atlanta, GA 30303 Company information

Modern Mobility Partners, LLC is an Atlanta-based transportation planning and traffic engineering consulting firm. As change agents for modern mobility planning, we not only help our clients to prepare for new and emerging technologies, but we also assist in defining a vision they can achieve in their communities. Modern Mobility Partners, LLC is proud to be a DBE/WBE/MBE/SBE.We provide consulting services in autonomous vehicles, transportation planning, travel demand modeling, traffic & revenue analyses, evaluation criteria & performance measures, and funding analyses & grant applications.

Transportation, Technology, Electric Vehicles, Smart Cities, Urban Planning

Partnership

Atlanta, Georgia

Company Specialties:

Autonomous Vehicles, Transportation Planning, Travel Demand Modeling, Traffic & Revenue Analysis, Evaluation Criteria & Performance Measures, Funding Analysis & Grant Applications, Traffic Engineering, Safety Analysis, Air Quality, and Smart Mobility Planning

#J-18808-Ljbffr