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, address discrepancies, and assist with modernization or migration projects.

• Address ad hoc and urgent requests by providing precise and timely information in a dynamic environment.

• Clearly communicate intricate data concepts to both technical and business stakeholders.

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

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

• Execute 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 that support Azure Data Factory, Synapse, and Informatica workflows.

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

• Uphold data governance through documentation, lineage tracking, and adherence 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 for pipeline health, data freshness, validation checks, and SLA compliance.

• Validate and analyze data stored in ADLS containers.

• Conduct integrity checks on Delta Lake and Parquet files.

• Execute reconciliation and quality verification across cloud storage zones.

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

⛳️ Requirements

• Bachelor's degree preferred.

• Authorization to work in the United States without needing current or future sponsorship (U.S. citizen or lawful permanent resident).

• Minimum of 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, profiling, and quality assurance with large and complex datasets.

• Prior experience in P&C insurance is highly desirable, including familiarity with operational and financial metrics.

• Excellent analytical and problem-solving capabilities.

• Proficiency in advanced Excel, Power BI, and other visualization tools; ability to transform data into valuable insights.

• Outstanding 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 & Spark), ADLS, Azure SQL, and Azure DevOps (CI/CD).

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

• Experience in creating semantic models and analytical datasets for business intelligence platforms.

• Understanding of KPI design, data governance, lineage, and business glossary concepts.

• Ability to operate across legacy (Informatica) and cloud platforms while validating logic during migrations.

• Capacity to plan for future capability needs and pursue continuous improvements.

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

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

• Preferred: familiarity with Microsoft Fabric (datasets, pipelines, governance).

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

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

• Preferred: experience with Azure DevOps CI/CD (YAML, Git branching).

• Preferred: knowledge of event streaming (Event Hubs, Service Bus) and APIs/Web Services (REST/SOAP).

🏝️ Benefits

• Full-time, exempt position.

• Remote work arrangement available.

• Opportunity to engage with a modern Azure-based data ecosystem.

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