Data Integrator IV

Company: Arch Capital Group Ltd.
Location: Jersey City
Posted on: April 5, 2021

Job Description:

The Position The Data Integrator IV - ETL & SQL Lead 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. Expected to lead teams and provide assistance and direction to less experienced peers. He/she should be an expert level hands on practitioner of Informatica Power Center ETL and with SQL Development and performance tuning. Job Responsibilities Works with the Program Manager and Business Systems Analyst 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 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 team 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 for creation of Product Roadmap, High Level Estimates Collaborates with IT management to define and develop documentation & engineering artifact standards, guidelines, processes, and templates. Working Conditions/Environment & Physical Demands: 1. Normal office environment 2. Off-hours production support as required 3. Position to be based in Arch Jersey City, NJ or Greensboro, NC offices. Required Skills/Experience * Minimum of eight years' of related experience in IT corporate systems environments required.* 7+ years' expert level experience with Informatica Power Center designing and developing complex ETL packages.* 7+ years' expert level experience with writing and debugging complex SQL queries along with performance tuning. MS SQL Server Experience.* Experience using agile software development principles, process and tools.* Strong Experience with SQL/ETL applications involving financial systems in financial services &/or P&C Insurance Industry.* Strong technical knowledge of Enterprise Data Warehouse, design and development of ETL packages, database design, operating systems and Information Management* 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.* 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.* 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 7 or more years of related experience. The Company Arch Insurance is a global insurer offering our clients superior coverage and service. We embody the Arch guiding principle of focusing on retaining experienced and talented employees to differentiate us from the rest of the pack. Our group operates from offices in the US, Canada, Bermuda, UK, and Australia, providing specialty risk solutions to clients worldwide across a wide range of industries. With over ten years of operating history and strong financial ratings, our track record remains solid. Arch Insurance employs a disciplined underwriting approach and prudent risk selection across all types of business. Our mission is to provide our insureds with superb coverage and claims handling through careful and diligent underwriting of risks and business-friendly solutions. Across our global operations, Arch Insurance employees are ready to meet your needs with professionalism and excellence.

Keywords: Arch Capital Group Ltd., Jersey City , Data Integrator IV, Other , Jersey City, New Jersey