Senior Applications Development Analyst

**Data Engineer - Application Development****What can you expect?**- This role’s primary responsibility is developing, enhancing and supporting Icat Online, Icat's customer facing quoting and policy management system.- Icat Online is the backbone of Icat's business, generating over 200,000 instant quotes a year for Earthquake and Hurricane Exposed Residential and Commercial Customers across the entire United States.**What’s in it for you?**- Culture of internal mobility, collaboration, and valued partnership with stakeholders.- Employee Resource Groups which provide access to leaders, relevant volunteer and mentoring opportunities and interactions with counterparts in industry groups and client organizations.- Full benefits package - starting day one.- Generous Parental Leave and Tuition Reimbursement plan per year and participation in our Employee Stock Purchase Plan (regional specificity required).- Generous paid time off, additional floating holidays, time off to give back to your community.- Multiple medical, dental, and vision plans with choices to fit all needs and budgets.**We will expect you to**:- Write SQL programs or scripts as required for small to large scale data updates.- Implement data models and database designs, data access and table maintenance codes. Assist in the resolution of database capacity issues, replication, and other distributed data issues.- Consult with ICAT personnel to determine business and functional requirements and identify solutions to resolve those needs.- Write and maintain functional and technical specifications.- Gather requirements and convert to SSRS reports both adhoc and scheduled.- Analyze, define and document system requirements for data, workflow, logical processes, interfaces with other systems, auditing, reporting requirements and production configuration.- Analyze code for problem resolution and performance optimization.- Provide technical consulting and respond to error reports, problems or questions.- Lead and promote a team environment, identify best practices and collaborate to implement across various systems.- Participate in QA and Production release teams.- Cross-train team. Work with manager to designate primary/backup for each function.- Write SQL code as required to support business operations, reporting and database management.- Assist Business Information Systems team as needed with functions including- General Administration, Document Issuance, Application Support, Reporting, Support other departments with their database server environment and architecture.- Assist with ad-hoc requests.- Maintain knowledge of and support ICAT’s company values and strategic plan- Additional duties as assigned- Escalate problems as appropriate- Exhibit good troubleshooting and technical skills**What you need to have Experience in**:- A Bachelor's degree in Computer Science, Engineering, a related field and 2-5 Years in industry experience OR 5-7 Years Industry experience without a 4 year degree.- At least eight years of experience with relational databases and writing/maintaining SQL code, preferably Microsoft SQL Server. Primary focus on complex SQL in PL-SQL or Transact-SQL. SSIS/SSRS experience required.- At least six years of experience in a production environment with responsibility for the timely production of business processes and output.- At least six years of experience using a change management system such as VSS, StarTeam or Perforce.- P&C Insurance knowledge, ISO Statutory and/or State DOI reporting experience preferred.- Demonstrated ability to proactively address issues, streamlining processes where possible.- Demonstrated ability to troubleshoot stored procedures by reviewing code, isolating any issues, suggest corrections and/ or enhancements using proper change control methodologies.**What makes you stand out?**- Experience in insurance or finance.- Demonstrated ability to work in a large global company and or complex IT environment preferred- Excellent verbal and written communication skills, comfortable interfacing with business users- Adaptability to changeMarsh McLennan is committed to creating a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age, background, disability, ethnic origin, family duties, gender orientation or expression, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, or any other characteristic protected by applicable law.Marsh McLennan is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh McLennan colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams wi