TransCore (TRN), a subsidiary of ST Engineering, Inc. is seeking a results driven Data Scientist I to join our team in Raleigh, NC.

Summary: The Data Scientist will be a member of our database and reports (Business Intelligence Analytics) team who will write stored procedures, design/modify/support database tables, create and modify reports using Microsoft reporting services and Tableau, perform unit testing, participate in release activities of the database as it goes through the development cycle, and participate in supporting and providing maintenance of the product. We use SSMS, SSRS, Tableau, Visual Studio, DevOps, and Teams/SharePoint regularly.

The ideal candidate for this position is eager to learn, has an analytical mind, a drive to see tasks through to their conclusion, a willingness to work in a multi-location team environment and is receptive to constructive feedback from colleagues. Attention to detail is a must.

Essential Duties and Responsibilities include the following, but are not limited to:

• Write queries and stored procedures.
• Design, modify, and support database tables.
• Create and develop Tableau reports for data analysis.
• Accept and apply feedback and detailed editing requirements.
• Optimize and maintain legacy code.
• Analyze the flow of data throughout the system to validate functionality.
• Develop new backend processes.
• Support database development for report creation.
• Troubleshoot performance problems, fine-tune databases, and perform index analysis.
• Support other members of the team by participating in peer code reviews and testing cycles.
• Work closely with other members of the team to maintain component reusability and integrity of the system.
• Provide maintenance support.
• Other duties as assigned.

• Experience in MS SQL Server, Tableau or Power BI and MS Word and Excel is required.
• Excellent analytical and organizational skills.
• Ability to deliver projects on time and with a high quality of code.
• Excellent verbal and written communication skills, both at the detail and summary levels.
• Visual Studio, .NET development.
• Large database and transaction processing.
• Experience with SQL Server System Integration Services / Data warehousing / Business Intelligence preferred.
• Analysis of business requirements and technical requirements in order to develop and enhance complex code.

• Bachelor's degree in computer science or a related Engineering field with 2 years of relevant experience is preferred.
• Master's degree in computer science, Engineering, Data Science, Data Analytics, or a related field is highly desirable.