📁
Information Technology
📅
72912 Requisition #

Gallagher is a global leader in insurance, risk management and consulting services. We help businesses grow, communities thrive and people prosper. We live a culture defined by The Gallagher Way, our set of shared values and guiding tenets. A culture driven by our people, over 30,000 strong, serving our clients with customized solutions that will protect them and fuel their futures.

 

The Senior SQL Developer is part of the Gallagher Bassett Date Management IT team based in Rolling Meadows, IL.  This position requires a developer who work independently and test very complex data cleansing scripts, SSIS data migration /data conversion packages.  This position is part of the Electronic State Reporting team which handles compliance with State reporting Requirements. This position will work on the conversion of state reporting from our Legacy (Tandem) system to our out sourced vendor using SQL/SSIS and XML data transfer.  After all states are converted (3+ year roadmap) there will be continued enhancements based on state reporting. This is a new position created to accelerate the conversion.

 

Essential Duties and Responsibilities:

  • Directs, prepares, designs, codes, tests, debugs, and maintains complex computer programs 
    • Write complex T-SQL queries
    • Design complex ETL using loop containers and data transformation tasks
    • Tuning SQL queries to improve performance
  • Under general direction, formulates and defines system scope and objectives
    • Provide expert technical feedback to functional spec designers / business analysts
  • Works with users to support business applications, and investigate operational problems/system requirements and solves user inquiries that arise during day-to-day operation
    • After hours and weekend support required approximately 10% (12 hours) in a given month
  • Responsible for completion of development projects
  • Lead and make design decisions to create simple, elegant and re-usable software components as part of a larger enterprise application framework
  • Provide accurate delivery estimates

Required: 

  • Bachelor’s Degree in Computer Science, Information Systems or Business
  • 5 or more years related experience, including the following
    • Microsoft SQL Server 2016 and beyond
    • Stored procedures, T-SQL, temp tables, database performance tuning
    • SOLID principles and design patterns
    • Strong analytical and data management skills
    • Demonstrated skill in understanding relational table design and applying optimized indexes
    • Microsoft SSIS
    • Strong grasp of ETL, XML, and EDI protocals
    • Experience with Microsoft Team Foundation Server (TFS)

 

Desired:

  • Experience with automated unit testing and test-assisted development
  • Experience with Azure
  • Experience with agile software development methodologies
  • Understanding of systems development and project delivery life cycles
  • Knowledge of Worker’s Compensation insurance a plus
  • Typical day:
    • 75% SQL
    • 10% Environment Maintenance
    • 10% Requirements, Analysis and Planning
    • 5% SSIS Development

 

Work Traits:

  • Strong applications analysis and issue resolution (trouble shooting) skills 
  • Strong user and client relationship management skills
  • Excellent written and oral communications with ability to work effectively and provide feedback to senior level managers and vendors
  • Self-starter with strong work ethic and ability to excel in fast paced, high demand environment
  • Competent to work at the highest technical level of all phases of applications systems analysis and programming activities
  • Proven ability to independently manage tasks and priorities, accurately estimate work and meet deadlines
  • Commitment to quality and excellent customer service to end users

 

U.S. Eligibility Requirements:

  • Interested candidates must submit an application and resume/CV online to be considered
  • Must be 18 years of age or older
  • Must be willing to submit to a background investigation; any offer of employment is conditioned upon the successful completion of a background investigation
  • Must have unrestricted work authorization to work in the United States.  For U.S. employment opportunities, Gallagher hires U.S. citizens, permanent residents, asylees, refugees, and temporary residents. Temporary residence does not include those with non-immigrant work authorization (F, J, H or L visas), such as students in practical training status. Exceptions to these requirements will be determined based on shortage of qualified candidates with a particular skill. Gallagher will require proof of work authorization
  • Must be willing to execute Gallagher's Employee Agreement or Confidentiality and Non-Disclosure Agreement which requires, among other things, post-employment obligations relating to non-solicitation, confidentiality and non-disclosure

 

Gallagher offers competitive salaries and benefits, including: medical/dental/vision plans, life and accident insurance, 401(K), employee stock purchase plan, educational expense reimbursement, employee assistance program, flexible work hours (availability varies by office and job function) training programs, matching gift program, and more.  

 

Gallagher believes that all persons are entitled to equal employment opportunity and does not discriminate against nor favor any applicant because of race, sex, color, disability, national origin, religion, creed, age, marital status, citizenship, veteran status, gender, gender identity / expression, actual or perceived sexual orientation, or any other protected characteristic.‚Äč Equal employment opportunity will be extended in all aspects of the employer-employee relationship, including, but not limited to, recruitment, hiring, training, promotion, transfer, demotion, compensation, benefits, layoff, and termination. In addition, Gallagher will make reasonable accommodations to known physical or mental limitations of an otherwise qualified applicant with a disability, unless the accommodation would impose an undue hardship on the operation of our business.

 

#LI-JK1

#LI-Remote

Please Note:

Gallagher never extends an offer of employment or requests any personal identification information without having received an online application and conducted one or more in-person or video interviews. If you have received any communication referencing the offer of a job at Gallagher and you have not submitted an online application or been interviewed by a Gallagher employee, please do not assume that the offer is being sent from a legitimate Gallagher representative.

Similar Listings

Rolling Meadows, Illinois, United States

📁 Information Technology

Requisition #: 71513

Rolling Meadows, Illinois, United States

📁 Information Technology

Requisition #: 71421

Rolling Meadows, Illinois, United States

📁 Information Technology

Requisition #: 72642