Job Tasks/Responsibilities: Works with the Agile Program Manager (APM), Digital Product Manager (DPM), and Business Systems Analyst (BSA) to accurately capture stakeholder requests and system specifications and translate them into engineering artifacts, which typically include design specifications, source code, test scripts and test results. Coordinates with software architects and Software engineer IVs to ensure that the engineering realization is in accordance with Enterprise Architecture principles and software development best practices. As part of Agile teams, completes software development work which includes application design, coding, code review and testing. Keeps Agile team and APM apprised of project status. Offers suggestions to stakeholders on devising effective and efficient approaches to achieve project and program objectives. Manages engineering risks by proactively tracking and communicating issues, and devising methods to mitigating them. Liaises with other project and program areas to coordinate interdependencies and resolve issues. Supports business units in the resolution of in-depth user questions and issues following production support process and SLA's. Maintains a working knowledge of new technology and software engineering standards, practices and tools. Provides input to APM/DPM in creation of Product Roadmap, High Level Estimates Collaborates with IT management to define and develop documentation & engineering artifact standards, guidelines, processes, and templates. Mandatory/Primary Skills: Required Skills/ Experience: SQL OR SQL Server experience SSIS/SSAS Snowflake Power BI Desired Skills/ Experience: Advanced knowledge of the theoretical and practical application of highly specialized software engineering best practices, methods & techniques. Extensive experience in developing software applications on the assigned technology platform. Extensive knowledge on source code change management and related tools. Knowledge and experience using agile software development principles, process and tools.. Excellent analytical, problem solving and organizational skills. Excellent interpersonal, and written and oral communication skills. Strong customer service skills in order to provide end user/business owner systems support. Knowledge of production support processes such as incident and problem management techniques. Minimum of eight years' of related experience in IT corporate systems environments required. 3 to 5 years' experience with Informatica Power Center designing and developing complex ETL packages 3 to 5 years' experience with writing and debugging complex SQL queries Strong technical knowledge of Enterprise Data Warehouse, design and development of ETL packages, database design, operating systems and Information Management Must have the strong communication skills and ability to develop and present solutions to team and managers Must be able to solve complex problems with direction Experience in working with distributed teams. Experience in managing distributed teams. Ability to work on multiple projects/tasks simultaneously to meet project deadlines as required Ability to establish and maintain positive working relationships with other employees Knowledge of P&C / Specialty insurance is a big plus Education: Required knowledge and skills would typically be acquired through a Bachelor's degree in computer science, business, or related field plus 3 to 5 years of related experience'
