Data Architect

Sr. Data Engineer/Architect

Role is augmenting an existing team tasked with the development/building/population of centralized OneSource Data HUB with the long-term objective of containing all global claim information. This effort critically is about the design/governance/process of treating & managing data to gain scale of this data asset. Program is already underway – this role is about augmenting the team with Data Engineering capability to increase the velocity of delivery of product lines into the HUB as well as iterating/enhancing the HUB technology and supportability itself. This individual will specifically be critical in working with a team downstream of the HUB in the creation of a new Data Warehouse/Marts that will be fed from the OneSource HUB allowing for substantial analytics/capabilities to be developed on top of cleansed, rationalized, global product data without sacrificing any performance. 2025 will be a busy year of adding at minimum two additional product lines to the HUB from two different source systems as well as feeding multiple downstream systems such as the new Data Warehouse with valuable/aligned claims data.

Expectations

• Some level of insurance background strongly preferred – with background in Claims/Claims Management ideally
• US based with fluent English skills required – while the role is remote, there will be a significant amount of interaction daily through teleconferencing. In addition, ability to travel to Chicago/home office with some frequency
• Flexibility to consistently work CST/EST hours, but also at times support Australia/UK meeting times
• Required cultural fit with Gallagher Basset – mid-west/family-owned business culture where work needs to be driven & delivered but through a type B mindset
• Need to be a self-starter with a comfort in ambiguity. Needs to work well in an environment that at times can lack structure – individual needs to be comfortable creating the structure for their work as well as delivering it
• Significant role will be to mentor/collaborate with internal FTEs – success is raising the game of the entire team. The team is diverse in most ways, with many of the resources being in Chicago, but also globally.
• Must be able/willing to collaborate with a remote team – work independently/dependently at the same time.

Key Skills

Technical

• Strong proficiency in Python design/engineering as well as SQL
• Generic but deep Architecting/Modeling background – Conceptual/Logical/physical
• Design/implementation experience with cloud/hosted environments such as AWS, Azure, etc.
• Deep experience with implementation of SSIS and T-SQL in both a cloud as well as on prem environment.
• Experience creating executive reports/dashboards

Others

• Ability to work well with other highly intelligent/diverse architects – this is not merely a engineering role – it's expected to be a leadership and collaboration role with other peers of a similar position who are already staffed on the team.
• Experience preferred DevOps and familiarity with Agile Methodologies as well as SDLC processes
• Visio and/or any Arch Documentation Tools experience required
• Excellent communication skills – the ability to work with a wide range of executives as well as team members with varying degrees of experience/technical sophistication. Strong written communication abilities.
• Inquisitive/curious disposition requested – we are looking for folks that find as well as solve problems. Resource needs to be willing to be thoughtfully engaged and utilize their soft skills to collectively make the team better than the sum of its parts.