Application Developer

Location: Bloomfield Hills

Introduction At Gallagher Benefit Services, you're a trusted partner to organizations navigating some of their most important people decisions. We help clients build better workplaces, where people feel supported, empowered, and inspired to thrive. Whether it's shaping benefit strategies, designing wellbeing programs, or advising on workforce challenges, the work you do here creates meaningful change for businesses and the people who power them.

We're a community of bold explorers, trusted experts, and compassionate partners; working side by side to solve problems, and shape the future of work. Here, curiosity is encouraged, collaboration is second nature, and your ideas have room to grow. If you're looking for a place where your contribution matters and where you can help build a better world of work;

think of Gallagher. Overview Gallagher is looking for an all around Application Developer who is strong with C#/.Net and Database skills. This person needs to be able to work very independantly with little direction. How you'll make an impact
* Main Responsibilities
* Application Development
* Primary responsibility is to write / develop code per user stories developed by our Business Analyst (BA) team.
* Work with our BA's and other developers on new application development in support of our integrated benefits underwriting and management platform.
* Regularly meet with our BA's to review new requirements, progress on existing work and testing in an Agile Development environment
* Conduct thorough Data Exploratory Analysis before starting to code in order to determine potential issues with existing data not identified in the specs
* Application Support
* Work on existing applications within our benefits administration platform regarding new enhancements, new capabilities and fixes on an as needed basis.
* Systems Documentation
* Update appropriate systems documentation to reflect changes in the original requirements documents and use cases, when there are changes to the original requirements documentations.
* Database Design / Scripting
* Work on designing and optimizing relational database schemas based on the defined requirements and understanding of the underlying data
* Create views and stored procedures necessary for use with new or existing applications and reports
* Analyze and refactor existing views or stored procedures as data or requirements change About You

Required:

* Typically requires a University Degree and minimum 3 years of prior relevant experience, or equivalent experience.
* Skills / Experience
* Proficient with the following technology tools / platforms:
* C#
* Microsoft .Net (.Net Framework and/or .Net Core)
* ASP.Net MVC and WebAPI
* Client Server RESTful communication
* Bootstrap/jQuery
* Windows Presentation Framework
* MS SQL
* Git/Bit Bucket
* Skills and experience to provide backup support in the following areas
* Windows Server
* Moderately complex database skills
* Design and implement logical and physical data model
* Moderate to complex SQL
* Database field encryption
* Database tuning and maintenance
* Managing of transactional and data warehouse environments
* Extraction Translation and Loading processes
* 4+ years systems development
* Requirements definition
* Code re-use
* Systems integration
* Application development and testing
* Quality assurance
* Bonus Skills
* SSIS
* WCF
* Azure Devops
* Win Forms
* Single-Page Application (SPA) Frameworks
* Redis
* Other
* Customer-centric, professional approach in working with a variety of people. Sufficient oral and written communication to prepare required reports. Ability to work within a team as well as independently with little supervision. Compensation and benefits We offer a competitive and comprehensive compensation package. The base salary range represents the anticipated low end and high end of the range for this position.

The actual compensation will be influenced by a wide range of factors including, but not limited to previous experience, education, pay market/geography, complexity or scope, specialized skill set, lines of business/practice area, supply/demand, and scheduled hours. On top of a competitive salary, great teams and exciting career opportunities, we also offer a wide range of benefits. Below are the minimum core benefits you'll get, depending on your job level these benefits may improve:
* Medical/dental/vision plans, which start from day one!
* Life and accident insurance
* 401(K) and Roth options
* Tax-advantaged accounts (HSA, FSA)
* Educational expense reimbursement
* Paid parental leave Other benefits include:
* Digital mental health services (Talkspace)
* Flexible work hours (availability varies by office and job function)
* Training programs
* Gallagher Thrive program - elevating your health through challenges, workshops and digital fitness programs for your overall wellbeing
* Charitable matching gift program
* And more... The benefits summary above applies to fulltime positions. If you are not…