Remote Lead Data Architect – Snowflake/SQL/Python

Remote Lead Data Architect - Snowflake/SQL/Python


Job ID: mrp-892161

Boston, ,

Information Technology

Full Time,

$100 - $160

On-site

Other/Non Classified

Boston, ,

$100 - $160

Full Time,

Other/Non Classified

On-site

Information Technology

Job details

Job Description
A leading organization in the insurance and risk management space is seeking a Lead Data Architect to drive the design, development, and evolution of a modern enterprise data platform. This individual will play a key role in building scalable cloud-based data solutions while establishing architecture standards and best practices across the organization.

This position is ideal for a senior-level data professional with 5+ years of dedicated Data Architect experience and deep expertise in modern data platforms. The Lead Data Architect will partner with engineering, analytics, and business teams to create trusted, governed, and highly scalable data solutions that support enterprise reporting, operational intelligence, and advanced analytics.
Location: Remote (EST/CST preferred) or Hybrid in Boston, MA
Compensation: Up to $160,000 base salary Required Skills & Experience

  • 5+ years of experience specifically in a Data Architect role
  • 8+ years of overall experience in data architecture, data engineering, or related disciplines
  • Expert-level data modeling experience, including conceptual, logical, and physical modeling
  • Extensive hands-on experience with Snowflake architecture and optimization
  • Strong SQL development skills in large-scale enterprise environments
  • Python development experience for data engineering and automation
  • Experience designing enterprise data platforms and cloud-native data solutions
  • Hands-on ELT/ETL pipeline development experience
  • Experience implementing data quality, metadata, and lineage frameworks
  • Strong understanding of modern data architectures, CDC, event-driven ingestion, and orchestration patterns
  • Ability to mentor engineers and communicate complex architectural concepts to both technical and non-technical stakeholders
  • Must be authorized to work in the United States without sponsorship

Desired Skills & Experience

  • Experience with Databricks
  • Experience with dbt, Airflow, Azure Data Factory, or similar technologies
  • Knowledge of master data management (MDM) and governance frameworks
  • Experience supporting enterprise analytics and business intelligence initiatives
  • Insurance industry experience
  • Snowflake certification
  • Experience with Power BI or other BI platforms

What You Will Be Doing
Daily Responsibilities

  • Lead enterprise-wide data architecture strategy and roadmap development
  • Design scalable data models that support reporting, analytics, and operational use cases
  • Build and optimize Snowflake-based data platforms and solutions
  • Architect and oversee cloud-native ELT/ETL pipelines
  • Establish data standards, governance processes, and architecture best practices
  • Design medallion architecture frameworks and data modernization initiatives
  • Drive performance, reliability, scalability, and cost optimization efforts
  • Partner with business and technology stakeholders to translate requirements into enterprise data solutions
  • Provide architectural oversight across major data initiatives
  • Mentor data engineers, analytics engineers, and developers
  • Help teams understand architectural principles, design decisions, and best practices
  • Review technical designs and provide guidance on complex data challenges
  • Evaluate emerging technologies and lead proof-of-concept initiatives

The Offer

  • Base salary up to $160,000
  • Remote opportunity for candidates located in EST or CST time zones
  • Hybrid option available in Boston, MA
  • Opportunity to influence enterprise-wide data strategy and architecture
  • High visibility role with leadership and mentorship responsibilities

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.

Share this job

I want more jobs like this in my inbox.

Share this job

As part of our promise to talent, Kelly supports those who work with us through a variety of benefits, perks, and work-related resources. Please note: The following benefits reflect Kelly's general offerings. Eligibility may vary by assignment, location, and job type. Kelly offers eligible employees voluntary benefit plans including medical, dental, vision, telemedicine, term life, whole life, accident insurance, critical illness, a legal plan, and short-term disability. As a Kelly employee, you will have access to a retirement savings plan, service bonus and holiday pay plans (earn up to eight paid holidays per benefit year), and a transit spending account. In addition, employees are entitled to earn paid sick leave under the applicable state or local plan. Click here for more information on benefits and perks that may be available to you as a member of the Kelly Talent Community.



About Kelly

Work changes everything. And at Kelly, we’re obsessed with where it can take you. To us, it’s about more than simply accepting your next job opportunity. It’s the fuel that powers every next step of your life. It’s the ripple effect that changes and improves everything for your family, your community, and the world. Which is why, here at Kelly, we are dedicated to providing you with limitless opportunities to enrich your life—just ask the 300,000 people we employ each year.

Kelly is committed to providing equal employment opportunities to all qualified employees and applicants regardless of race, color, sex, sexual orientation, gender identity, religion, national origin, disability, veteran status, age, marital status, pregnancy, genetic information, or any other legally protected status, and we take affirmative action to recruit, employ, and advance qualified individuals with disabilities and protected veterans in the workforce. Requests for accommodation related to our application process can be directed to the Kelly Human Resource Knowledge Center. Kelly complies with the requirements of California’s state and local Fair Chance laws. A conviction does not automatically bar individuals from employment. Kelly participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S.

Kelly may use AI-powered tools during the recruitment and hiring process. For full details, including how Kelly uses AI, your rights, and how to request a reasonable accommodation, visit the Recruitment Artificial Intelligence Notice.