Vacancy expired!
Description: What is the specific title of the position? Business Support Data Engineer Work location ? Remote Work hours (ex. 9am-5pm day/night shifts rotating shifts etc)? 8-5 Please provide a summary of the project/initiative that this candidate will be working on? This is a technical position within a business organization. The current SQL environment was developed as needed, without a long-term plan. We have reached the point where only 1 person on our team can research and resolve issues or modify code for enhancements. We need an individual to help standardize SQL processes and structure as well as develop current staff so they can assist. 700+ SQL tables 20+ SSIS packages 300+ Views 200+ Stored Procedures Please describe the team the candidate will be working with - how many member? Team of 7 financial, reporting and data analysts What is the break-down of the team s skill sets (ex: 1 PM 4 Developers etc.)? 1 database analyst, 6 financial/reporting analysts. What are the top 5-10 responsibilities for this position (please be detailed as to what the candidate is expected to do or complete on a daily basis)? Modernize, simplify, and enhance the team's SQL processes: Work with Senior Leadership to develop a project plan and proactively communicate progress and questions. Provide recommendations on structure changes and modernization Review and recommend changes for SSIS packages that make them more efficient to run, allow less skilled employees to identify steps, so they can troubleshoot errors and provide more precise business requirements for enhancements Decommission and archive unused services Provide backup to SQL standard processing Educate entire team on research methodology and procedure to decouple complex code and understand intended outcome Maintain SQL server database integrity by validating and troubleshooting Data discovery and enhancements needed to meet requirements Develop tools and hand off to reporting team after processes are standardized What does the ideal candidate background look like (ex: healthcare specific background specific industry experience etc.)? healthcare background, worked as technical individual within a business team prior What skills/attributes are required (please be detailed as to number of years of experience for each skill)? 5+ years Visual Studio (SSIS) 5+ years SQL Server Management Studio (SSMS) 5+ years Visual Studio (SSRS) What skills/attributes are preferred (what will set a candidate apart)? working with complex financial data What will the interview process look like? (Video phone or in person? virtual (video/phone) How many rounds? 2 How technical will the interviews be?)
Vacancy expired!