Data Warehouse Architect

2 days ago


Boston, United States Franklin Fitch Full time

Data Warehouse Architect | Contract-to-Hire | Boston - Hybrid (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.
  • Synapse Analytics experience.
  • 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).


  • Boston, United States Franklin Fitch Full time

    Data Warehouse Architect | Contract-to-Hire | Boston - Hybrid (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...


  • Boston, United States Franklin Fitch Full time

    Data Warehouse Architect | Contract-to-Hire | Boston - Hybrid (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...

  • Data Architect

    2 days ago


    Boston, United States Triverus Consulting Full time

    The data architect will be responsible for the analysis, design, architecture and development of a new data integration, data warehouse and analytic solution. A strong background in data integration, data modeling and cloud architecture with the ability to undertake complex challenges and deliver measurable results is required.What You Can DoLeverage...

  • AWS Data Architect

    1 day ago


    Boston, United States Saxon Global Full time

    Top required skills based on interviews and feedback (Client want to see experience around all of this): Healthcare Payor / Provider client experience REQUIRED. Deep experience working as an AWS Data Solution Architect with 5+ years AWS Cloud. Must excel in client/ stakeholder interactions, bridging the gap between technical complexities and business...


  • Boston, United States CTI Data Full time

    Location: Greater Boston or New York Metro AreasPosition Summary:The Lead Consultant of Data & Analytics Solutions is a project team lead and client-facing position within our organization. The Lead Consultant’s main responsibility is leading the day-to-day delivery and implementation of specified client projects. We are looking for someone who can be...

  • Data Architect

    2 days ago


    Boston, United States Coforge Full time

    Role: Data ArchitectKey Skill: Data Architecture, AWS, Snowflake, Asset Management DomainExperience: 10+ yearsLocation: Boston, MAMode of Hire: Full TimeWe at Coforge are hiring a Data Architect with the following skillset :-Responsibilities :- Design, develop, and maintain scalable data architectures and pipelines on AWS and Snowflake.Collaborate with...

  • Data Architect

    2 days ago


    Boston, United States Coforge Full time

    Role: Data ArchitectKey Skill: Data Architecture, AWS, Snowflake, Asset Management DomainExperience: 10+ yearsLocation: Boston, MAMode of Hire: Full TimeWe at Coforge are hiring a Data Architect with the following skillset :-Responsibilities :- Design, develop, and maintain scalable data architectures and pipelines on AWS and Snowflake.Collaborate with...

  • Data Architect

    7 days ago


    Boston, United States Coforge Full time

    Role: Data ArchitectKey Skill: Data Architecture, AWS, Snowflake, Asset Management DomainExperience: 10+ yearsLocation: Boston, MAMode of Hire: Full TimeWe at Coforge are hiring a Data Architect with the following skillset :-Responsibilities :- Design, develop, and maintain scalable data architectures and pipelines on AWS and Snowflake.Collaborate with...

  • Data Architect

    7 days ago


    Boston, United States Later Full time

    Later is the enterprise leader in social media and influencer marketing software, services, and data, trusted by leading brands and agencies worldwide. Following our acquisition of Mavely, the Everyday Influencer Platform, Later enables brands to scale creator partnerships from nano to premium influencers while managing social media content and campaigns...

  • Data Architect

    2 days ago


    Boston, United States Mindtech Full time

    Data Architect Mindtech is your gateway to exciting and impactful tech projects. We specialize in end-to-end software outsourcing, linking Latin American talent with global opportunities. Our fast, cost-effective approach ensures that our clients receive exceptional service and innovative solutions. With a diverse team of over 70 skilled professionals across...

  • Data Architect

    2 days ago


    Boston, United States Later Full time

    Later is the enterprise leader in social media and influencer marketing software, services, and data, trusted by leading brands and agencies worldwide. Following our acquisition of Mavely, the Everyday Influencer Platform®, Later enables brands to scale creator partnerships from nano to premium influencers while managing social media content and campaigns...

  • Data Architect

    2 days ago


    Boston, United States Tbwa ChiatDay Inc Full time

    Later is founded on two success stories that began in 2014: Mavrck, the industry-leading influencer marketing solution (now Later Influence), and Later, the best social media management platform (now Later Social) and first-to-market link in bio tool, Later Link in Bio. In 2024, Mavrck and Later officially joined together as one unified business, with a...


  • Boston, United States RIT Solutions, Inc. Full time

    Minimum 5 years of experience in working as Solution/Data Architect on cloud platforms (AWS is highly desirable). Minimum 4 years of experience with ETL/ELT design and development using tools like Talend, Informatica, AWS Glue, Oracle Data Integrator (ODI) or equivalent. Minimum 5 years of experience in database architecture using relational SQL (e.g....


  • Boston, Massachusetts, United States Klaviyo Full time

    About UsKlaviyo is a leader in data-driven innovation, empowering creators to own their destiny. Our mission is to make first-party data accessible and actionable like never before.Job OverviewWe are seeking a seasoned Principal Business Intelligence Engineer to lead our data ecosystem's architectural evolution and drive data-driven innovation across the...

  • Oracle Cloud MDM

    2 days ago


    Boston, United States Kapital Data Corp Full time

    MDM Sr Technical engineerThe MDM technical engineer is an experienced consultant who will drive the solution design and implementation for Oracle CDH, PDH, SDH. (Responsibilities Be part of the implementation team, prepare for, and participate in the Oracle MDM - CDH, PDH, SDH integration strategy for the client ERP solution. Be part of the MDM committee...

  • Big Data Modeler

    1 day ago


    Boston, United States Diverse Lynx Full time

    Skill: Big Data Modeler / Architect Big Data Modeler/Architect. Team is involved in the build out of a Data Lakehouse using Databricks, for the FX business line. Team is currently in the process of setting up the Databricks infrastructure and very soon we will be beginning the work for building the ingestion pipelines into the Bronze Zone of Databricks. Team...


  • Boston, United States Saviance Full time

    Job Title: Sr. Data Architect- Data.World Specialist Location: Boston, Massachusetts, United States -Flexible to travel if required Duration: 06-12+ Month contract About BigRio: BigRio is a remote technology consulting firm headquartered in Boston. We deliver a range of solutions including custom machine learning/AI integrations and data warehousing and...

  • REMOTE Architect

    12 hours ago


    Boston, United States Jobot Full time

    Job DescriptionJob Description100% REMOTE Architect - Opportunity to work on cutting edge Data Center projects!This Jobot Job is hosted by: Stephen BrainerdAre you a fit? Easy Apply now by clicking the "Apply Now" buttonand sending us your resume.Salary: $100,000 - $140,000 per yearA bit about us:We are seeking a talented Data Center Architect with a strong...


  • Boston, United States State Street Bank Full time

    Who we are looking forAs Senior Solution Architect for Data, you will play a crucial role in enabling the bank to achieve its goals through strategic investments in technology solutions. Leveraging your experience in AWS or Azure and Data solutions, you will lead technical discussions and design solutions with project teams, guiding them to extract maximum...


  • Boston, Massachusetts, United States MongoDB Full time

    Company OverviewMongoDB is a leading developer data platform, empowering innovators to create, transform, and disrupt industries by unleashing the power of software and data. Our mission-driven company prioritizes professional growth, personal wellbeing, and societal impact.Job DescriptionWe are seeking a Sr. Director of Partner Solution Architects to lead a...