Get new jobs for this search by email

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