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.