Hanover
Hanover
51 – 200 Employees
ConsultingRecruitment

Hanover is an executive search and talent consultancy serving the financial services sector. The firm helps organisations find and strengthen senior leadership through executive search, leadership development, coaching, board advisory, outplacement and strategic talent consulting.

Its work spans asset management, banking, insurance, fintech, private equity and wealth management. With offices in London, New York, Chicago and Los Angeles, Hanover combines sector knowledge and market intelligence with a people-focused approach to leadership and workforce strategy.

Associate Information Data Architect

Build trusted analytics datasets and cloud data solutions while supporting Azure, SQL, Python, BI, governance, and migration work across business domains.

Description

  • Turn reporting and analysis needs into datasets, metric definitions, and reporting solutions
  • Document data mappings, transformations, and lineage across integrated systems
  • Analyze data to validate logic, resolve discrepancies, and support modernization and migrations
  • Handle urgent and ad hoc requests with accurate, timely information
  • Explain complex data topics to business and technical audiences
  • Work with product owners to define KPIs, metric logic, and shared business rules
  • Build and maintain curated datasets, SQL views, tables, and semantic layers for dashboards and self-service analytics
  • Profile data and perform quality checks and reconciliations with SQL and Python
  • Parse, transform, and validate XML and JSON using Python, XPath, and schema rules
  • Maintain mappings for Azure Data Factory, Synapse, and Informatica workflows
  • Improve analytics performance through query tuning, semantic modeling, and scalable dataset design
  • Support governance with documentation, lineage tracking, and data management standards
  • Partner with Data Engineering to turn requirements into cloud data pipelines
  • Align datasets with enterprise models and Azure standards
  • Monitor Azure and Fabric pipeline health, data freshness, validation checks, and SLA performance
  • Validate and analyze data in ADLS containers
  • Check the integrity of Delta Lake and Parquet files
  • Reconcile and verify data quality across cloud storage zones
  • Contribute to tool improvements, process enhancements, and innovation

Requirements

  • A bachelor's degree is preferred
  • Must be authorized to work in the United States without current or future sponsorship; U.S. citizenship or lawful permanent residency is required
  • At least 2 years of related experience in data engineering, ETL, data modeling, analysis, validation, reporting, or analytical solution delivery
  • Strong SQL skills for analyzing, profiling, and assessing the quality of large, complex datasets
  • Property and casualty insurance experience is strongly preferred, including familiarity with operational and financial metrics
  • Strong analytical and problem-solving abilities
  • Advanced Excel, Power BI, and other data visualization skills, with the ability to turn data into useful insights
  • Excellent written and verbal communication
  • Strong time management, prioritization, and organizational skills
  • Knowledge of technical mapping, including database, XML, and JSON schemas
  • Practical experience with Azure Data Factory, Synapse SQL and Spark, ADLS, Azure SQL, and Azure DevOps CI/CD
  • Python skills for data wrangling, XML and JSON parsing, XPath, automation, and validation
  • Experience developing semantic models and analytical datasets for BI platforms
  • Understanding of KPI design, data governance, lineage, and business glossary concepts
  • Ability to work across legacy Informatica and cloud platforms and validate logic during migrations
  • Ability to anticipate future capability needs and support continuous improvement
  • Preferred: data quality frameworks and automated testing with SQL or Python
  • Preferred: Synapse Spark or PySpark, Delta Lake, and notebook development
  • Preferred: Microsoft Fabric datasets, pipelines, and governance
  • Preferred: Microsoft Purview or similar metadata and lineage tools
  • Preferred: Parquet, partitioning, and lakehouse performance optimization
  • Preferred: Azure DevOps CI/CD, including YAML and Git branching
  • Preferred: event streaming with Event Hubs or Service Bus, and REST or SOAP APIs and web services

Benefits

  • Full-time, exempt role
  • Remote work arrangement available
  • Work with a modern Azure-based data ecosystem
  • Contribute to tool enhancements, process improvements, and innovation initiatives

Related Jobs