Logo
Franklin Fitch

Data Warehouse Architect

Franklin Fitch, WorkFromHome

Save Job

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.

#J-18808-Ljbffr