Azure Engineer - Database Architect

Role Title: Azure Engineer - Database Architect

• As an Azure Data Architect you will be a key member of the Global GTS M&A team.

• This role will be proficient in investigating, decomposing, and combining data of different data sources and types.

• Ideal candidates are prepared to design appropriate solutions to support merger data needs.

• The Azure Data Architect will partner with other team members on the creation of best-practices approach to capture data from disparate applications into an Azure Data Lake for cleaning, curation and mapping into various application destinations meeting Gallagher approved standards.

• They will identify and explore new data sources and be primarily focused on developing integration processes between systems and create thorough diagrams and documentation.

• They will also be responsible for identifying datasets targeted for on-prem migration and architecting the requisite platform for hosting that data from within the Gallagher datacenter.

Core Responsibilities

• Identifies, designs, and implements internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

• Investigates data, data sources, and performs data quality analysis.

• Collaborates with other Architects and Data Engineers to help adopt best-practices in data system creation, data integrity, test design, analysis, validation, and documentation.

• Creates and maintains optimal data pipeline architecture for extraction, transformation, and loading of data from various data sources – both internal and external.

• Assembles large, complex sets of data that meet non-functional and functional business requirements.

• Builds industrialized analytic datasets and delivery mechanisms that utilize the data pipeline to deliver actionable insights.

• Communicates and maintains master data, metadata, data management repositories, logical data models, data standards.

• Works with stakeholders including the executive, product, data and technology teams to support their data infrastructure needs while assisting with data-related technical issues.

Key Skills and Experience

• Excellent analysis and problem-solving skills

• Effective time-management skills

• Ability to adapt to ever-changing system environments and understand all business applications

• Desire to learn new technologies and adapt requirements for future cloud solutions

• Good organizational skills and a strict attention to detail and proven ability to follow through

• Strong interpersonal skills

• Ability to develop effective working relationships with stakeholders

• Hands-on experienced with designing, moving and transforming data to/from Microsoft SQL Server, Azure SQL, Azure SQL DW, Dynamics CRM, Dynamics 365.

• Hands-on experience integration technologies such as SQL Server Integration Services, Azure Data Factory, Azure Logic Apps, Power Automate Azure Integration Services or similar technologies.

• Mastery of relational SQL and NoSQL databases

• Mastery knowledge of Snowlflake in both AWS and Azure clouds

• Experienced with data wrangling and preparation for use within PowerBI

• Strong written and verbal communication skills including the ability to effectively collaborate with multi-disciplinary groups and all organizational levels.