Job Description :
Location Saint Louis, MO Duties: This "Software Engineering Advisor" role will be expected to support all aspects of the Strategic Analytics Data Engineering teams mission; which is enable the enrichment, curation, and productization of operational data. Will also play a pivotal role in the team migrating to Postgres. Essential Functions: Partner with other Senior Advisors to optimize our Postgres and Microsoft SQL servers/processes Work with Operations business partners and Strategic Analytics colleagues to evaluate complex user-requests/projects. Partner with subject matter experts to gain a working knowledge of legacy applications/code in need of migration. Work with Senior Software Development Engineers/Architects to deliver products aligned with recommended architectural/design patterns. Test product performance, effectiveness, and compliance. Diagnose and troubleshoot errors. Help to solidify objectives and functional requirements for new or enhanced application capabilities. Help to determine/estimate feasibility, cost and time required, compatibility with current system. Prepare project documentation when needed. Mentor less experienced developers. Skills * Minimum 5 years experience in Postgres, SQL Server, and SSIS. Minimum 1 year experience in Hadoop Experience with Java and/or JavaScript a plus Experience with creating API endpoints. Thorough knowledge of programming concepts, design, procedures and practices. Advanced problem solving skills. Ability to work collaboratively with other departments to resolve complex issues with innovative solutions. Excellent oral and written communication skills. Education * - College degree in Information Systems or related field strongly preferred. - 3+ years of work experience in programming / software development. Technical expertise for SQL related design, performance, security and configuration. Maintaining, monitoring and supporting complex database solutions. Troubleshooting, performance tuning and problem resolution of SQL Server.