Franklin Fitch
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
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