FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Associate Information Data Architect
The Hanover Insurance Group. Translate reporting and analytical requirements into analytical datasets, metric definitions, and reporting solutions .
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in SQL and Python for data analysis, profiling, and validation, with a strong focus on creating and maintaining analytical datasets and ensuring data governance. Proficient in collaborating with cross-functional teams to define KPIs and optimize data pipelines in cloud environments.
Highest-signal resume keywords
SQL ProficiencyPython ExperienceAzure Data FactoryData GovernanceP&C Insurance Experience
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
Data AnalysisData ProfilingData ValidationETLData ModelingKPI DesignSemantic ModelingQuery OptimizationXML/JSON ParsingAutomated Testing
Soft Skills
Analytical SkillsProblem-Solving SkillsCommunication SkillsTime ManagementOrganizational Skills
Tools & Technologies
Power BIAzure SynapseAzure SQLAzure DevOpsInformaticaDelta LakeMicrosoft FabricMicrosoft PurviewEvent HubsService Bus
Industry Keywords
P&C InsuranceData GovernanceData LineageOperational MetricsFinancial Metrics
Tech Stack
Tools & technologiesAzureCloudETLInformaticaPySparkPythonSOAPSparkSQL
About the role
Key responsibilities & impact- Translate reporting and analytical requirements into analytical datasets, metric definitions, and reporting solutions
- Design and document source-to-target mappings, transformation logic, and data lineage for cross-system integrations
- Conduct deep-dive data analysis to validate logic, resolve discrepancies, and support modernization or migration initiatives
- Respond to ad hoc and urgent requests by delivering accurate, timely information
- Communicate complex data concepts to technical and business audiences
- Collaborate with product owners to define and document KPIs, metric logic, and shared business rules
- Create and maintain curated analytics datasets, including SQL views, tables, and semantic layers
- Perform data profiling, quality checks, and reconciliation using SQL and Python
- Parse, transform, and validate XML/JSON using Python, XPath, and schema rules
- Maintain source-to-target mappings for Azure Data Factory, Synapse, and Informatica workflows
- Improve analytics performance through query optimization, semantic modeling, and scalable dataset design
- Support data governance through documentation, lineage tracking, and data management standards
- Collaborate with Data Engineering to translate requirements into cloud-based data pipelines
- Align datasets with enterprise data models and Azure standards
- Support Azure and Fabric monitoring for pipeline health, data freshness, validation checks, and SLA adherence
- Validate and analyze data stored in ADLS containers
- Perform integrity checks on Delta Lake and Parquet files
- Conduct reconciliation and quality verification across cloud storage zones
- Contribute to tool enhancements, process improvements, and innovation initiatives
Requirements
What you’ll need- Authorization to work in the United States without current or future sponsorship (U.S. citizen or lawful permanent resident)
- 2+ years of experience in a related field such as data engineering, ETL, data modeling, analysis, validation, reporting, or analytical solution delivery
- Strong proficiency with SQL for data analysis, data profiling and quality with large and complex datasets
- P&C insurance experience is strongly preferred, including understanding of operational and financial metrics
- Strong analytical and problem-solving skills
- Advanced Excel, Power BI and other visualization tools; ability to translate data into meaningful insights
- Excellent written and verbal communication skills
- Strong time management, prioritization, and organizational skills
- Knowledge of technical mapping, including database schema, XML schema, and JSON schema
- Hands-on experience with Azure Data Factory, Synapse (SQL & Spark), ADLS, Azure SQL, and Azure DevOps (CI/CD)
- Python experience for data wrangling, XML/JSON parsing, XPath, automation, and validation
- Experience creating 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 plan for future capability needs and continuous improvements
- Preferred skills: data quality frameworks and automated testing with SQL/Python; Synapse Spark/PySpark; Delta Lake and notebook development; Microsoft Fabric; Microsoft Purview or similar metadata/lineage tools; Parquet, partitioning, and lakehouse performance optimization; Azure DevOps CI/CD (YAML, Git branching); event streaming (Event Hubs, Service Bus); REST/SOAP APIs
- Bachelor's degree preferred
Benefits
Comp & perks- Hybrid work arrangement
- Full-time, exempt position