Data Warehouse Architect

Franklin Fitch; Massachusetts; Remote; USD 140,000 - 223,000; Full time

Job summary

A leading consulting firm is seeking a Data Warehouse Architect in a remote-first capacity. This role involves designing and implementing scalable data architectures, managing ETL processes, and providing leadership in analytics to support business growth. Ideal candidates will possess strong skills in data integration, cloud solutions, and big data technologies.

Qualifications

• 5+ years as a Data Warehouse Architect or similar role.
• Experience in designing and building data warehouses.
• Strong knowledge of ETL, data integration, and cloud-based platforms.

Responsibilities

• Lead the design and development of the data warehouse.
• Optimize ETL processes and data modeling.
• Implement data governance and security best practices.

Skills

ETL processes

data integration

API integration

data modeling

SQL

big data technologies

problem-solving

communication

Education

Bachelor's or Master’s in Computer Science

Tools

Azure Synapse Analytics

AWS

Google Cloud

Snowflake

Hadoop

Spark

Job description

Get AI-powered advice on this job and more exclusive features.

Data Warehouse Architect | Contract-to-Hire | Massachusetts - Remote First

As the Data Warehouse Architect, you will be responsible for creating the data architecture for a newly established enterprise data warehouse. You will design, implement, and optimize ETL processes, data models, and integrations from multiple data sources, including APIs. You will also leverage Azure Synapse Analytics for scalable data integration and analytics. This is a key leadership role, working closely with stakeholders to ensure the data warehouse aligns with business goals and scales as the company grows.

Responsibilities:

• Design & Build: Lead the end-to-end design and development of the data warehouse from scratch, including data modeling, ETL pipelines, and integrations from multiple data sources (APIs, databases, etc.).
• Cloud & Big Data Solutions: Leverage cloud platforms (e.g., AWS, Google BigQuery, Snowflake) and big data technologies (e.g., Hadoop, Spark) to build scalable and efficient solutions.
• Synapse Integration: Use Azure Synapse Analytics to enable integrated analytics and seamless data workflows.
• Collaboration & Leadership: Work with BI, analytics, and business teams to define data requirements, mentor junior team members, and ensure successful implementation.
• Data Governance & Security: Implement best practices for data governance, quality, and security, ensuring compliance with relevant regulations.
• Optimization & Innovation: Continuously evaluate and enhance the architecture for performance, cost efficiency, and scalability.

Requirements:

• Experience: 5+ years as a Data Warehouse Architect or similar role, with experience designing and building data warehouses from the ground up.
• Expertise in ETL processes, data integration, API integration, and cloud-based data platforms (AWS, Google Cloud, Synapse, Snowflake).
• Strong knowledge of data modeling, SQL, and big data technologies (e.g., Hadoop, Spark).
• Excellent problem-solving and communication skills.

Qualifications:

• Experience in real-time data processing and stream processing.
• Education: Bachelor's or Master’s in Computer Science, Information Systems, or a related field.
• Cloud certifications are a bonus (e.g., AWS Certified Big Data - Specialty).

You will be working in a remote capacity, with only occasional onsite requirements in Massachusetts.

Seniority level

• Seniority level

  Associate

Employment type

• Employment type

  Contract

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Franklin Fitch by 2x

Sign in to set job alerts for “Data Warehouse Architect” roles.

Data Architect (15+ Yrs ExP)_Milliman Build (HEALTHCARE EXP NEEDED)_Remote_ONLY ON W2

Burlington, MA $140,000 - $222,500 3 hours ago

Marlborough, MA $100,000 - $150,000 2 weeks ago

Cambridge, MA
$177,000.00
-
$263,000.00
2 weeks ago

Cambridge, MA
$147,000.00
-
$216,000.00
2 weeks ago

Staff Clinical Informatics Data Architect

Boston, MA
$177,341.00
-
$186,660.23
6 days ago

Canton, MA
$90,000.00
-
$110,000.00
2 weeks ago

Senior Staff Engineer - Finance Data Specialist (Remote)

Boston, MA
$115,000.00
-
$260,000.00
6 days ago

[FY26] Data Engineer - Industrials & Energy Sector - Senior Manager - Consulting - Location Open

Boston, MA
$142,600.00
-
$325,800.00
3 days ago

Boston, MA
$110,000.00
-
$258,000.00
2 weeks ago

IT Data Protection Security Engineer - Senior Manager

Worcester, MA $144,768 - $209,109.33 1 month ago

Massachusetts, United States $140,000 - $170,000 3 days ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.