Manager, Data Architect

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

📋 Description

• Design and uphold a scalable HR data architecture within Snowflake, comprising databases, schemas, data models, and semantic views.

• Construct and enhance ETL/ELT pipelines using Matillion and Snowflake to fulfill reporting, analytics, and operational requirements.

• Define and uphold data governance, ensuring data quality, consistency, lineage, naming conventions, and adherence to regulatory standards for HR data.

• Develop and sustain data controls to guarantee the integrity and reliability of data throughout systems and workflows.

• Implement and oversee security policies for user views and semantic layers, including role-based access and data protection measures.

• Manage SQL Server environments utilized for metadata management, focusing on performance tuning and reliability.

• Establish DevOps practices (version control, deployment automation, and environment promotion) for schemas, pipelines, and data models.

• Collaborate with Product and Delivery teams, BU Consultants, and BI development teams to transform requirements into scalable, governed data solutions.

• Offer consultation and expert guidance on data architecture, integration, and analytics capabilities.

• Create and maintain detailed documentation for data architecture designs, processes, governance policies, and integrations.

• Support AI-ready and agentic use cases by organizing trusted semantics, metadata, and reusable data products.

⛳️ Requirements

• A University Degree or equivalent experience with a minimum of 8 years of relevant experience, or an Advanced Degree in a related field with at least 5 years of experience.

• Over 7 years of experience in data architecture or data engineering.

• Strong practical experience with Snowflake (design, modeling, performance) and cloud data services.

• Experience in building API integrations and ETL/ELT pipelines.

• Proficient SQL Server skills (design, indexing, performance tuning).

• Demonstrated experience with data governance, metadata management, and data security.

• Familiarity with version control systems (e.g., Git) and automated deployment for data assets.

• Excellent communication skills and ability to collaborate effectively with stakeholders.

🏝️ Benefits

• Health insurance

• Dental

• Vision

• Life insurance

• Short-term disability

• Long-term disability

• 401(k) match

• Flexible spending accounts

• Flexible work schedules

• Employee assistance program

• Employee Scholar Program

• Parental leave

• Paid time off

• Holidays