2024-7213_Data Integrator

AGSI was incorporated in April 2016. We are committed to supporting the goals of Arch divisions through exceptional service delivery. We pride ourselves on maintaining flexibility and responsiveness to adapt to business unit and industry demands while focusing on sound project management. We are dedicated to growing and developing our employees as we build strong teams with strategic leadership.

The Data Integrator II - develops, implements, and maintains software solutions that enable business operations to realize company goals & objectives. The incumbent performs analysis, design, coding, debugging, testing, and support of software applications. May be assigned to develop new applications/systems, enhance/upgrade existing systems or provide production support. He/she works independently on moderately complex projects, receiving only general direction. May provide assistance and direction to less experienced peers.

Essential RESPONSIBILITIES and ACCOUNTABILITIES

1. 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.
2. 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.
3. 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.
4. Offers suggestions to stakeholders on devising effective and efficient approaches to achieve project and program objectives.
5. Manages engineering risks by proactively tracking and communicating issues, and devising methods to mitigating them.
6. Liaises with other project and program areas to coordinate interdependencies and resolve issues.
7. Supports business units in the resolution of in-depth user questions and issues following production support process and SLA’s.
8. Maintains a working knowledge of new technology and software engineering standards, practices and tools.
9. Provides input to APM/DPM in creation of Product Roadmap, High Level Estimates
10. Collaborates with IT management to define and develop documentation & engineering artifact standards, guidelines, processes, and templates

Required Skills/Experience
* SQL OR SQL Server experience
* Informatica
* Data Analytics
* Snowflake

Knowledge & Skills:

1. Advanced knowledge of the theoretical and practical application of highly specialized software engineering best practices, methods & techniques.
2. Extensive experience in developing software applications on the assigned technology platform.
3. Extensive knowledge on source code change management and related tools.
4. Knowledge and experience using agile software development principles, process and tools..
5. Excellent analytical, problem solving and organizational skills.
6. Excellent interpersonal, and written and oral communication skills.
7. Strong customer service skills in order to provide end user/business owner systems support.
8. Knowledge of production support processes such as incident and problem management techniques.
9. Minimum of eight years’ of related experience in IT corporate systems environments required.
10. 3 to 5 years’ experience with Informatica Power Center designing and developing complex ETL packages
11. 3 to 5 years’ experience with writing and debugging complex SQL queries
12. Strong technical knowledge of Enterprise Data Warehouse, design and development of ETL packages, database design, operating systems and Information Management
13. Must have the strong communication skills and ability to develop and present solutions to team and managers
14. Must be able to solve complex problems with direction
15. Experience in working with distributed teams.
16. Experience in managing distributed teams.
17. Ability to work on multiple projects/tasks simultaneously to meet project deadlines as required
18. Ability to establish and maintain positive working relationships with other employees
19. Knowledge of P&C / Specialty insurance is a big plus

Required knowledge and skills would typically be acquired through a Bachelors degree in computer science, business, or related field plus 3 to 5 years of related experience.