Data Integration & Reporting Analyst (31819)

Job Purpose: To maintain Data Integration needs for NEMT line of business and First transit IT needs.

Major Responsibilities:

  • Work directly with application developers, business analysts, and quality assurance personnel for the development of ETL processes.
  • Identifying, documenting and validating data conversion/migration scope, risks, constraints, dependencies and assumptions.
  • Understand existing ETL jobs written in SSIS to streamline and migrate them to Azure cloud-based services
  • Perform ETL by designing, developing various SQL Server Integration Service (SSIS) packages to extract and transform data; scheduling SSIS packages and executing them.
  • Produce high quality ETL code on time and on target to support business reporting and analytics.
  • Scripting and design of ETL packages to enable automation and less manual intervention.
  • Ensure data processes are performing efficiently and are using best practices, standards, and guidelines
  • Ability to build modular, parameter-based code to help reusability.
  • Ability to effectively migrate data from on premises to Azure environment, as and when required
  • Work closely with the System Administrators to support the deployment of data to higher environments
  • Documenting work as required following development standards
  • Work with key users and stakeholders to identify and resolve data issues.
  • Conduct post implementation review and support of ETL, data conversion and migration processes.
  • Maintain and Optimize current processes to meet revised service level objectives and projected use.
  • Demonstrates initiative and works independently with minimal supervision.

Experience & Skills Required:          

  • Working knowledge of Microsoft SQL Server as well as an understanding of database structure
  • 4 year College Degree preferred
  • SQL Server SSIS certification preferred
  • 3-5 years’ experience performing ETL within SQL Server environments using SQL Server Integration Services (SSIS) will be required. Experience in a similar role within an Azure cloud environment using Azure Data Factory, (ADF), would be strong asset.
  • 3-5 years’ experience designing and developing complex SQL Server database schemas and queries in T-SQL
  • Familiarity in a programming language such as C#, Java, JavaScript, Python, etc.
  • Experience with SSRS would be nice to have.
  • Experience within the Transportation/Transit industry preferred
  • Strong interpersonal skills - must be able to work effectively as part of a project team and foster team co-operation
  • Strong quantitative, analytical, problem solving, organizational and communication skills are required

FirstGroup is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status. FirstGroup is also committed to providing a drug-free workplace. For candidates applying to positions in San Francisco or Los Angeles California, FirstGroup will consider for employment qualified applicants with criminal histories consistent with the requirements of the San Francisco Fair Chance Ordinance or Los Angeles Fair Chance Ordinance.

Close large map
55780 - Transit Services MIS
600 Vine Street, Suite 1400, Cincinnati, Ohio, United States, 45202
  • Company:
    First Transit
  • Terms and Conditions Type:
    Full Time
  • City:
  • State:
  • Category:
  • Contact Telephone Number:
Share this page
Share with linkedin
Share with facebook
Share with twitter
Share with email
Vacancy Alerts
Create an alert subscription based on this vacancy