Overview

The Data Analyst is responsible for creating reporting solutions that unlock business insights for IntelliRide and help provide focus to actualize strategic initiatives for individual locations. Deliverables may include the following: reports; dashboards; visualizations; excel reports; stored procedures, views and Adhoc queries; related documentation; and other types as needed to support business requirements.

Responsibilities

The duties and responsibilities of the Data Analyst center around the following:

• Assist in defining and documenting business and technical requirements

• Assist in defining, validating, and implementing data cleanup procedures, transformations, scripts, stored procedures, and execution of test plans for loading data successfully

• Write and performance tune complex T-SQL queries and stored procedures

• Build and maintain reports, dashboards, and visualizations using Power BI or similar

• Interpret data, analyze results using statistical techniques and provide ongoing reports

• Identify, analyze, and interpret trends or patterns in complex data sets

• Work with management to prioritize business and information needs

• Locate and define new process improvement opportunities

• Perform administrative tasks to support reporting.

• Data Quality

• Make recommendations to operations for enhancements to systems of record or business process to improve accuracy of operational data

• Data Security and Compliance

• Utilize automation to create efficiencies and reduce resource allocation for routine tasks and procedures.

• Process confidential data and information according to guidelines

• Train end users on new reports and dashboards.

Qualifications

Qualifications:

• Bachelor's degree in IT or related field, or equivalent work experience.

• Minimum of 1+ years of professional experience with Microsoft BI Stack (SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), Microsoft Reporting Services (SSRS) and Power BI).

• Proficiency with Microsoft Excel

• Proficiency with SQL, T-SQL, Stored Procedures, Views Functions

• Experience with dimensional data modeling

• Proficiency with DAX queries in Power BI desktop

• Ability to prioritize tasks and work independently

• Excellent written and verbal communication and presentation skills

Preferred:

• Experience in Transportation Logistics

About Transdev:

Based near Chicago, Transdev is the largest private-sector operator of multiple modes of transit in North America, including bus, rail, streetcar, paratransit, and shuttle services. Transdev is committed to being the trusted partner of cities and transit authorities through quality execution and innovations in mobility. Its parent company, Transdev Group, is a leading global operator and integrator of mobility operating in 17 countries and provides passengers every day the freedom to connect to what they care about in their cities.www.transdevna.com

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified.

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions upon request.

Transdev is an Equal Employment Opportunity (EEO) employer and welcomes all qualified applicants. Applicants will receive fair and impartial consideration without regard to race, sex, color, national origin, age, disability, veteran status, genetic data, gender identity, sexual orientation, religion or other legally protected status, or any other classification protected by federal, state, or local law.

EEO is the Law Poster: http://www1.eeoc.gov/employers/poster.cfm

Drug free workplace

For more information please visit our website at www.transdevna.jobs

Job Locations USA-NE-Omaha

Posted Date 4 weeks ago (7/16/2022 4:44 PM)

Requisition ID 2022-23126

Position Category Information Technology (IT)

Internal Reference 402

Company/Division IntelliRide