Associate Information Data Architect

This is a fully remote position, open to applicants in Massachusetts.

📋 Description

• Convert reporting and analytical needs into analytical datasets, metric definitions, and reporting solutions.

• Create and document source-to-target mappings, transformation logic, and data lineage for integrations across systems.

• Perform in-depth data analysis to validate logic, resolve discrepancies, and assist with modernization or migration projects.

• Address ad hoc and urgent requests by providing accurate and timely information in a fast-paced environment.

• Clearly convey complex data concepts to both technical and business audiences.

• Work with product owners to define and document KPIs, metric logic, and shared business rules.

• Develop and maintain curated analytics datasets, including SQL views, tables, and semantic layers for dashboards and self-service analytics.

• Conduct data profiling, quality checks, and reconciliation utilizing SQL and Python.

• Parse, transform, and validate XML/JSON using Python, XPath, and schema rules.

• Maintain source-to-target mappings that support Azure Data Factory, Synapse, and Informatica workflows.

• Enhance analytics performance through query optimization, semantic modeling, and scalable dataset design.

• Support data governance by documenting processes, tracking lineage, and adhering to data management standards.

• Collaborate with Data Engineering to convert requirements into cloud-based data pipelines.

• Ensure alignment of datasets with enterprise data models and Azure standards.

• Monitor Azure and Fabric, including pipeline health, data freshness, and validation checks, to ensure adherence to SLAs.

• Validate and analyze data stored in ADLS containers.

• Work with Delta Lake and Parquet files to conduct integrity checks and maintain consistency across storage layers.

• Perform reconciliation and quality verification as data transitions through cloud storage zones.

• Contribute to enhancements of tools, process improvements, and innovation initiatives.

⛳️ Requirements

• Preferred Bachelor’s degree.

• Authorization to work in the United States without current or future sponsorship; must be a 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 expertise in SQL for data analysis, data profiling, and quality assessment of large and complex datasets.

• Preferred experience in P&C insurance, including familiarity with operational and financial metrics.

• Strong analytical and problem-solving capabilities.

• Proficient in advanced Excel, Power BI, and other visualization tools; capable of transforming data into valuable insights.

• Excellent written and verbal communication abilities.

• Strong skills in time management, prioritization, and organization.

• Knowledge of technical mapping, including database schema, XML schema, and JSON schema.

• Practical experience with Azure Data Factory, Synapse (SQL and Spark), ADLS, Azure SQL, and Azure DevOps (CI/CD).

• Proficient in Python for data wrangling, XML/JSON parsing, XPath, automation, and validation.

• Experience in 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.

• Capability to plan for future needs and continuous improvements.

• Preferred knowledge of data quality frameworks and automated testing with SQL/Python.

• Preferred experience with Synapse Spark/PySpark, Delta Lake, and notebook development.

• Preferred familiarity with Microsoft Fabric datasets, pipelines, and governance.

• Preferred experience with Microsoft Purview or similar metadata/lineage tools.

• Preferred knowledge of Parquet, partitioning, and performance optimization in lakehouse architectures.

• Preferred experience with Azure DevOps CI/CD using YAML and Git branching.

• Preferred knowledge of event streaming with Event Hubs or Service Bus and REST/SOAP APIs or web services.

🏝️ Benefits

• Full-time, exempt position.

• Remote work arrangement available.

• Opportunity to work within a modern Azure-based data ecosystem.

• Chance to contribute to tool enhancements, process improvements, and innovation initiatives.