Staff Data Architect - Remote (EST)

Kelly Services; Boston (MA); Remote; USD 144,000 - 176,000; Full time

Benefits offered by this job

Medical Insurance

Dental Benefits

Vision Benefits

Paid Time Off (PTO)

401(k)

Job summary

Motion Recruitment Partners in the United States seeks a Staff Data Architect to shape and scale its enterprise data ecosystem. The role leads architecture standards, platform modernization, and cloud data solutions across the organization.

The position supports remote (EST/CST preferred) or hybrid work in Boston, MA, with base compensation up to $160,000. Ideal candidates will have extensive Snowflake experience, strong data modeling, and leadership capabilities.

Qualifications

• 5+ years of direct experience as a Data Architect
• 8+ years across data architecture, data engineering, or related data disciplines
• Advanced data modeling skills (conceptual, logical, physical)
• Hands-on Snowflake design and optimization experience
• Strong SQL skills for large-scale enterprise data
• Python for automation and data processing
• Experience designing cloud-based data platforms and modern data ecosystems
• Experience developing ELT/ETL pipelines
• Knowledge of data governance, metadata, lineage, and quality controls
• Understanding CDC, event-driven architectures, orchestration, and modern patterns
• Excellent communication to influence technical and business audiences
• Experience mentoring data engineers and analytics engineers

Responsibilities

• Define and execute the long-term enterprise data architecture strategy
• Create scalable data models supporting operational and analytical workloads
• Design, implement, and enhance Snowflake-based data solutions
• Lead cloud-native data integration and transformation processes
• Establish and enforce enterprise data standards, governance practices, and architectural guidelines
• Drive modernization with medallion architecture and modern data platform patterns
• Improve platform performance, resiliency, scalability, and cost efficiency
• Collaborate with business leaders and technology teams to translate requirements into data solutions
• Provide architectural leadership across enterprise-wide data initiatives
• Coach and mentor data engineers, analytics engineers, and other technical team members
• Champion best practices and sound design principles across teams
• Conduct design reviews and guide complex technical challenges
• Research emerging technologies and run PoCs

Skills

Snowflake

SQL

Python

Data modeling

Data governance

ELT/ETL

Cloud data platforms

CDC

Event-driven

Mentoring

Leadership

Communication

Tools

Databricks

dbt

Airflow

Azure Data Factory

Power BI

MDM

Job description

$130 - $160

Job DescriptionA well-established organization within the insurance and risk solutions industry is hiring a Staff Data Architect to help shape and scale its enterprise data ecosystem. This role will serve as a technical leader responsible for defining architecture standards, guiding platform modernization efforts, and delivering high-impact cloud data solutions that support critical business initiatives.

The ideal candidate brings extensive experience designing enterprise-grade data platforms and has a proven track record building scalable, governed, and high-performing data environments. Working closely with data engineering, analytics, and business stakeholders, the Staff Data Architect will drive architectural decisions that enable reporting, operational insights, and advanced analytics across the organization.

Location: Remote (EST/CST preferred) or Hybrid in Boston, MA

Compensation: Up to $160,000 base salary Required Skills & Experience

• 5+ years of direct experience as a Data Architect
• 8+ years of professional experience across data architecture, data engineering, or related data disciplines
• Advanced expertise in conceptual, logical, and physical data modeling
• Deep hands-on experience designing and optimizing Snowflake environments
• Strong SQL skills with experience supporting large-scale enterprise datasets
• Python programming experience for automation, data processing, and engineering solutions
• Proven success architecting cloud-based data platforms and modern data ecosystems
• Experience developing and maintaining ELT/ETL frameworks and pipelines
• Knowledge of data governance, metadata management, data lineage, and quality controls
• Strong understanding of CDC methodologies, event-driven architectures, orchestration frameworks, and modern data platform patterns
• Excellent communication skills with the ability to influence technical and business audiences
• Experience providing technical leadership and mentoring engineering teams
• Must be authorized to work in the United States without sponsorship

Desired Skills & Experience

• Experience working with Databricks
• Familiarity with dbt, Airflow, Azure Data Factory, or comparable technologies
• Knowledge of Master Data Management (MDM) practices
• Background supporting enterprise reporting, analytics, and business intelligence programs
• Prior experience within the insurance industry
• Snowflake certification
• Exposure to Power BI or other business intelligence platforms

What You Will Be Doing

Daily Responsibilities

• Define and execute the long-term enterprise data architecture strategy
• Create scalable and maintainable data models that support operational and analytical workloads
• Design, implement, and enhance Snowflake-based data solutions
• Lead the architecture of cloud-native data integration and transformation processes
• Establish and enforce enterprise data standards, governance practices, and architectural guidelines
• Drive modernization efforts using medallion architecture and contemporary data platform patterns
• Improve platform performance, resiliency, scalability, and cost efficiency
• Collaborate with business leaders and technology teams to translate requirements into strategic data solutions
• Provide architectural leadership across enterprise-wide data initiatives
• Coach and mentor data engineers, analytics engineers, and other technical team members
• Champion architectural best practices and promote sound design principles across teams
• Conduct design reviews and offer guidance on complex technical challenges
• Research emerging technologies and evaluate new capabilities through proof-of-concept efforts

The Offer

• Base salary up to $160,000
• Fully remote opportunity for candidates located in EST or CST time zones
• Hybrid work option available in Boston, MA
• Opportunity to shape the future direction of enterprise data architecture
• Highly visible leadership role with significant influence across the organization

You will receive the following benefits

• Medical Insurance
• Dental Benefits
• Vision Benefits
• Paid Time Off (PTO)
• 401(k)

Applicants must be currently authorized to work in the US on a full-time basis now and in the future.

Motion Recruitment Partners (MRP) is an Equal Opportunity Employer. All applicants must be currently authorized to work on a full-time basis in the country for which they are applying, and no sponsorship is currently available. Employment is subject to the successful completion of a pre-employment screening. Accommodation will be provided in all parts of the hiring process as required under MRP’s Employment Accommodation policy. Applicants need to make their needs known in advance.