Job Description :
ETL Reporting Analyst – Travel Data experience required

Our direct client is looking to hire a motivated, detailed oriented data analyst. In this role, you will be supporting the BI team with data analysis and troubleshooting of our ETL process that transforms data from a Microsoft AX Dynamics environment into data used for Client reporting. Specific duties will require the applicant to have a background using MS SQL Server to retrieve and analyze data. The qualified candidate must have a minimum of 1 to 2 years of relevant experience with Travel Data. In this role you will be expected to become familiar with a complex BI platform and backend, and apply that knowledge to assist the AX to troubleshoot and solve data discrepancies.
* Be first point of contact for all AX related queries and issues, and communicate to team lead ongoing issues and statuses.
* Respond to internal support queries, such as data integrity and validation questions.
* Research and validate the source of data discrepancies.
* Liaise with the Microsoft AX Dynamics team and development team regularly to communicate issues with the source data.
* Support ETL solutions.
* Documenting processes and procedures.
* Analyze data and trends, and suggest performance improvement measures.

Required Experience:
* Experience working with travel data. Air data is a very big plus.
* Solid understanding of TSQL syntax and stored procedures.
* Knowledge of relational databases and query concepts.
* Understanding of ETL concepts and processes.
* Analysis and design skills, critical thinking, and analytical problem solving.
* Microsoft Business Intelligence tools, specifically SSIS