Manager, Data Architect

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

📋 Description

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

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

• Establish and uphold data governance, data quality, consistency, lineage, naming standards, and regulatory compliance for HR data.

• Create and supervise data controls to ensure data integrity and reliability across various systems and workflows.

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

• Manage SQL Server environments designated for metadata management, focusing on performance optimization and reliability.

• Develop DevOps practices such as 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 convert requirements into scalable, governed data solutions.

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

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

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

⛳️ Requirements

• U.S. citizenship is mandatory; only U.S. citizens are permitted to access information related to this program/contract.

• University degree or equivalent experience along with a minimum of 8 years of relevant professional experience, or an advanced degree in a related field and at least 5 years of experience.

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

• Extensive hands-on experience with Snowflake, particularly in design, modeling, and performance optimization.

• Proficiency with cloud data services.

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

• Strong SQL Server skills, including design, indexing, and performance tuning.

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

• Familiarity with version control systems like Git and automated deployment for data assets.

• Excellent communication and collaboration skills with stakeholders.

• Snowflake or relevant cloud data services certification is preferred.

• Scripting skills in Python or Shell are preferred.

• Knowledge of API integrations and microservices architecture is preferred.

• Familiarity with cloud platforms, especially Azure, is preferred.

• Experience with HR systems such as Workday is preferred.

🏝️ Benefits

• Medical insurance

• Dental insurance

• Vision insurance

• 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

• Annual short-term and/or long-term incentive compensation programs may be available