Software Engineer II

Arch Insurance Group Inc. • Greensboro, NC

1d • Hybrid

About The Position

With a company culture rooted in collaboration, expertise and innovation, we aim to promote progress and inspire our clients, employees, investors and communities to achieve their greatest potential. Our work is the catalyst that helps others achieve their goals. In short, We Enable Possibility℠. ARCH US MI Services, Inc., seeks Software Engineer II in Greensboro, NC. Job Duties: Perform analysis, design, coding, debugging, testing, and support of software application systems. Develop new applications, enhance existing applications and provide production support. Work with Agile Program Manager (APM), Digital Product Manager (DPM), and Business Systems Analyst (BSA) to accurately interpret systems specifications documented in Agile user stories. Translate specifications into engineering artifacts, which typically include design specifications, source code, test scripts and test results. Obtain approval on final design documents from APM and software architect (software engineer III or IV). Work with senior software development peers to ensure that the the engineering realization is in accordance with Enterprise Architecture principles and software development best practices. As part of Agile team, complete software development work which includes application of creative design, coding and debugging methods and techniques. Collaborate with testers to ensure that all software components are tested adequately. Communicate any identified issues to APM. Offer suggestions to APM, DPM, and/or BSA on alternative approaches to achieve system objectives. Track and communicate issues to senior peers and/or APM for assistance with resolution. Liaise with other project and program areas to coordinate interdependencies. Develop and maintain a working knowledge of new technology and software engineering standards and practices. Design, develop, test, and implement scheduled report deliveries, utilizing automated delivery capabilities. Write complex SQL queries to implement performant data integration and reporting solutions. Focus on information/data quality by continuously evaluating data standards and data profiling. Provide production support on a rotational basis.

Requirements

• Bachelor’s degree or foreign equivalent in Computer Science, Engineering, Business, or related field plus 5 years of experience in the job offered or related software development position.
• 3 years of experience designing, developing, and implementing reporting solutions using IBM Cognos analytics.
• 3 years of experience in working with Enterprise Data Warehouse models using Kimball methodology, and multi-dimensional modeling using star and snowflake schemas.
• 3 years of experience with IBM DB2 and Microsoft SQL Server database version 2012 or later.
• 3 years of experience in developing the planning, budgeting and forecasting solutions using IBM planning analytics (TM1), including advanced knowledge of Turbo integrator processes, TM1 cube rules and feeders.
• 3 years of experience working with Cognos TM1 architect, Cognos TM1 cube modelling and Cognos TM1 performance modeler.
• 3 years of experience in job scheduling and orchestration using Autosys scheduler.
• 2 years of experience with IBM Cognos analytics version 11.x both On-prem and Cognos analytics on Cloud.
• 2 years of experience working with MotioCI to deploy Cognos assets and automate the testing of Cognos artifacts.
• 2 years of experience in building and testing excel interfaces using Cognos TM1 active form.
• 1 year of experience in Cognos configuration and administration.
• Experience with SQL scripting and performance turning.
• Experience with production support processes including incident and problem management techniques.
• Experience using agile software development principles, process, and tools.

Nice To Haves

• Experience with designing and developing ETL flows using Apache NiFi.
• Experience working on upgrading Cognos analytics on prem version to Cognos analytics on Cloud.
• Experience with design, development and maintenance of OLAP cubes using Cognos power play transformer.

Responsibilities

• Perform analysis, design, coding, debugging, testing, and support of software application systems.
• Develop new applications, enhance existing applications and provide production support.
• Work with Agile Program Manager (APM), Digital Product Manager (DPM), and Business Systems Analyst (BSA) to accurately interpret systems specifications documented in Agile user stories.
• Translate specifications into engineering artifacts, which typically include design specifications, source code, test scripts and test results.
• Obtain approval on final design documents from APM and software architect (software engineer III or IV).
• Work with senior software development peers to ensure that the engineering realization is in accordance with Enterprise Architecture principles and software development best practices.
• As part of Agile team, complete software development work which includes application of creative design, coding and debugging methods and techniques.
• Collaborate with testers to ensure that all software components are tested adequately.
• Communicate any identified issues to APM.
• Offer suggestions to APM, DPM, and/or BSA on alternative approaches to achieve system objectives.
• Track and communicate issues to senior peers and/or APM for assistance with resolution.
• Liaise with other project and program areas to coordinate interdependencies.
• Develop and maintain a working knowledge of new technology and software engineering standards and practices.
• Design, develop, test, and implement scheduled report deliveries, utilizing automated delivery capabilities.
• Write complex SQL queries to implement performant data integration and reporting solutions.
• Focus on information/data quality by continuously evaluating data standards and data profiling.
• Provide production support on a rotational basis.

Benefits

• multiple medical plans plus dental, vision and prescription drug coverage
• a competitive 401k with generous matching
• PTO beginning at 20 days per year
• up to 12 paid company holidays per year plus 2 paid days of Volunteer Time Offer
• basic Life and AD&D Insurance as well as Short and Long-Term Disability
• Paid Parental Leave of up to 10 weeks
• Student Loan Assistance and Tuition Reimbursement
• Backup Child and Elder Care

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level