Talent.com
Sr Data Warehouse Architect
Sr Data Warehouse ArchitectMass General Brigham • Somerville, New Jersey, USA
Sr Data Warehouse Architect

Sr Data Warehouse Architect

Mass General Brigham • Somerville, New Jersey, USA
19 days ago
Job type
  • Full-time
Job description

Site : Mass General Brigham Incorporated

Mass General Brigham relies on a wide range of professionals including doctors nurses business people tech experts researchers and systems analysts to advance our mission. As a not-for-profit we support patient care research teaching and community service striving to provide exceptional care. We believe that high-performing teams drive groundbreaking medical discoveries and invite all applicants to join us and experience what it means to be part of Mass General Brigham.

MGB Digital is hiring a Full Time Sr Data Warehouse Architect this role is vital to the team handling a major migration to Cloud that is ongoing and vital the MGB system. We will provide extensive and hands on training to understands our system and complex environment.

oDBT is highly preferred the team uses the tool now

oRequired- Experience in data warehousing database design and data modeling 8-10 years required

Job Summary

The Opportunity

MGB Digital is hiring a vital member of the team! The Sr Data Warehouse Architect will be designing developing and maintaining data warehouse solutions for an organization. This position plays a crucial role in ensuring the efficient storage organization and accessibility of data to support the companys business intelligence and reporting needs.

The migration began early 2024 and is going and long term. MGB continues to ensure the quality of this project. You will play a vital role as we continue to move the Cloud. DBT is highly preferred the team uses the tool now.

What Youll Do

  • Develops data warehouse architectures that align with the organizations business goals and requirements.
  • Designs and implements data models that support the reporting and analytical needs of the organization.
  • Establishes data governance policies and procedures to ensure data integrity security and compliance.
  • Identifies performance bottlenecks and optimizes data warehouse processes including ETL (Extract Transform Load) data transformation and query execution.
  • Evaluates and selects appropriate data integration tools and technologies to support the data warehouse architecture.
  • Leads other developers analysts and data warehouse architects providing guidance mentoring and technical expertise.

Qualifications

  • Bachelors Degree Related Field of Study required
  • Can this role consider and review experience in lieu of a degree Yes
  • Experience in data warehousing database design and data modeling 8-10 years required
  • Skills for Success

  • In-depth knowledge of data warehousing concepts methodologies and best practices.
  • Knowledge of Cloud Data Warehouse platforms.
  • Knowledge of Azure.
  • Proficiency in data integration and ETL tools (e.g. Informatica DataStage SSIS). DBT is highly preferred the team uses the tool now.
  • Strong understanding of relational databases (e.g. Oracle SQL Server) and SQL query optimization techniques.
  • Familiarity with dimensional modeling and star schema design.
  • Additional Job Details (if applicable)

    Working Model Requirements

  • M-F Eastern business hours required
  • Hybrid onsite days in office candidate must be flexible for business needs
  • This team is currently onsite 4 days per month with planning
  • On remote workdays employees must use a stable secure and compliant workstation in a quiet environment. Teams video is required and must be accessed using MGB-provided equipment.
  • Remote Type

    Hybrid

    Work Location

    399 Revolution Drive

    Scheduled Weekly Hours

    40

    Employee Type

    Regular

    Work Shift

    Day (United States of America)

    Pay Range

    $115398.40 - $167845.60 / Annual

    Grade

    At Mass General Brigham we believe in recognizing and rewarding the unique value each team member brings to our organization. Our approach to determining base pay is comprehensive and any offer extended will take into account your skills relevant experience if applicable education certifications and other essential factors. The base pay information provided offers an estimate based on the minimum job qualifications; however it does not encompass all elements contributing to your total compensation addition to competitive base pay we offer comprehensive benefits career advancement opportunities differentials premiums and bonuses as applicable and recognition programs designed to celebrate your contributions and support your professional growth. We invite you to apply and our Talent Acquisition team will provide an overview of your potential compensation and benefits package.

    EEO Statement :

    Mass General Brigham Incorporated is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race color religious creed national origin sex age gender identity disability sexual orientation military service genetic information and / or other status protected under law. We will ensure that all individuals with a disability are provided a reasonable accommodation to participate in the job application or interview process to perform essential job functions and to receive other benefits and privileges of employment. To ensure reasonable accommodation for individuals protected by Section 503 of the Rehabilitation Act of 1973 the Vietnam Veterans Readjustment Act of 1974 and Title I of the Americans with Disabilities Act of 1990 applicants who require accommodation in the job application process may contact Human Resources at .

    Mass General Brigham Competency Framework

    At Mass General Brigham our competency framework defines what effective leadership looks like by specifying which behaviors are most critical for successful performance at each job level. The framework is comprised of ten competencies (half People-Focused half Performance-Focused) and are defined by observable and measurable skills and behaviors that contribute to workplace effectiveness and career success. These competencies are used to evaluate performance make hiring decisions identify development needs mobilize employees across our system and establish a strong talent pipeline.

    Required Experience :

    Senior IC

    Key Skills

    Fund Management,Drafting,End User Support,Infrastructure,Airlines,Catia

    Employment Type : Full-Time

    Experience : years

    Vacancy : 1

    Monthly Salary Salary : 115398 - 167845

    Create a job alert for this search

    Data Warehouse Architect • Somerville, New Jersey, USA

    Related jobs
    Sr. Cloud Architect - NoSQL Database Engineer

    Sr. Cloud Architect - NoSQL Database Engineer

    Humana • Trenton, NJ, United States
    Full-time
    Become a part of our caring community and help us put health first.The NoSQL Database Engineer will design, implement, and support MongoDB, Neo4j, and vector database solutions within Humana's ente...Show more
    Last updated: 30+ days ago • Promoted
    Sr Analyst, Managed Markets & Specialty

    Sr Analyst, Managed Markets & Specialty

    J&J Family of Companies • Raritan, NJ, United States
    Full-time
    At Johnson & Johnson,?we believe health is everything.Our strength in healthcare innovation empowers us to build a?world where complex diseases are prevented, treated, and cured,?where treatments a...Show more
    Last updated: 4 days ago • Promoted
    Enterprise Architect

    Enterprise Architect

    ZS • Princeton, NJ, United States
    Full-time
    As a management consulting and technology firm focused on improving life and how we live it, we transform ideas into impact by. Here you'll work side-by-side with a powerful collective of thinkers a...Show more
    Last updated: 30+ days ago • Promoted
    Manager, Enterprise Vendor Data Steward

    Manager, Enterprise Vendor Data Steward

    New Jersey Staffing • Raritan, NJ, US
    Full-time
    Manager, Enterprise Data Management Vendor Data Steward.Johnson and Johnson Enterprise Data Management is recruiting for a Manager, Enterprise Data Management Vendor Data Steward, located in Rari...Show more
    Last updated: 10 days ago • Promoted
    Solution Architect

    Solution Architect

    Mitchell Martin • Chester, NJ, United States
    Full-time
    Experience in the medical devices domain is preferred.Solid understanding of data models, workflows, and configurations.Advantageous experience in migrating data from non-specific environments.Exce...Show more
    Last updated: 30+ days ago • Promoted
    Data Architect - Trenton, NJ - Hybrid

    Data Architect - Trenton, NJ - Hybrid

    Brandon Consulting Associates, Inc. • Trenton, NJ, United States
    Full-time
    Quick Apply
    About the job : This Data Archetect position is to work with Business Teams and bridge the gap between Judiciary business partners and the technology solution provid...Show more
    Last updated: 3 days ago
    Senior Cloud Computing Architect

    Senior Cloud Computing Architect

    Eliassen Group • Trenton, NJ, United States
    Permanent
    Senior Cloud Computing Architect.We are seeking an experienced Senior Cloud Computing Architect to lead the design and implementation of secure, scalable, and modern cloud solutions supporting Publ...Show more
    Last updated: 17 days ago • Promoted
    USA_Solution Architect

    USA_Solution Architect

    Varite • Raritan, NJ, United States
    Full-time
    Make Key architectural decision working with multiple business and Technology stakeholders.Build scalable framework in AzureDatabricks. Work with AI team to build Pipeline for Unstructured data inge...Show more
    Last updated: 17 days ago • Promoted
    Director Enterprise Data & Analytics

    Director Enterprise Data & Analytics

    Capital Health • Hopewell, NJ, US
    Full-time +1
    Director Of Enterprise Data & Analytics.Capital Health is the region's leader in providing progressive, quality patient care with significant investments in our exceptional physicians, nurses and s...Show more
    Last updated: 30+ days ago • Promoted
    Sr. Azure Data Engineer

    Sr. Azure Data Engineer

    Cognizant • None, NJ, US
    Full-time
    Azure Data Engineer , you will make an impact by driving end-to-end data integration and migration initiatives across enterprise data platforms. You will be a valued member of our Data Engineering &...Show more
    Last updated: 10 hours ago • Promoted • New!
    Information Technology_USA - USA_Solution Architect

    Information Technology_USA - USA_Solution Architect

    SysMind Tech • Raritan, NJ, United States
    Full-time
    Please strictly adpersonre to tperson following resume naming convention : .ALL CAPS, NO SPACES B / T UNDERSCORES.Bill Rate market rate - market rate. PTN_US_GBAMSREQID_CANDIDATEBEELINEID.PTN_US_9999999...Show more
    Last updated: 14 days ago • Promoted
    Solution Architect

    Solution Architect

    Omni Inclusive • Raritan, NJ, United States
    Full-time
    Partner with Product teams, Client Technology Services and other architects to design scalable, flexible and supportable technical systems that drive business value in support of Regulatory Strateg...Show more
    Last updated: 30+ days ago • Promoted
    SAP EWM Techno-functional Consultant

    SAP EWM Techno-functional Consultant

    Quantum Integrators • Raritan, NJ, United States
    Full-time
    Role : SAP EWM Techno-functional Consultant.Must Have Technical / Functional Skills.We are seeking a highly skilled SAP EWM S / 4HANA Technical Architect to lead the design, implementation, and optimiza...Show more
    Last updated: 1 day ago • Promoted
    Data Architect

    Data Architect

    vTech Solution • Trenton, NJ, United States
    Full-time
    Quick Apply
    This role involves gathering and documenting technical requirements, writing SQL queries, and ensuring comprehensive test plans to validate technical solutions. The ideal candidate will possess stro...Show more
    Last updated: 3 days ago
    Senior Integration and Solution Architect

    Senior Integration and Solution Architect

    Core Software Technologies Inc. • Trenton, New Jersey, United States
    Full-time
    Quick Apply
    As a Senior Integration Architect, you will be the driving force behind bringing together various tools and systems to create a cohesive and efficient technology ecosystem for our organization.Your...Show more
    Last updated: 30+ days ago
    Solution Architect Cloud & GenAI - Onsite

    Solution Architect Cloud & GenAI - Onsite

    The Dignify Solutions, LLC • Raritan, NJ, United States
    Full-time
    Solution Architecture or Lead cloud Engineering position with at least 2+ years of previous work experience with Generative AI. Gen AI Architect, Cross Cloud experience (AWS+ GCP+Azure); Generative...Show more
    Last updated: 6 days ago • Promoted
    Sr. Solution Architect - Advanced Analytics - Remote (Full Time)

    Sr. Solution Architect - Advanced Analytics - Remote (Full Time)

    The Dignify Solutions LLC • Raritan, NJ, United States
    Remote
    Full-time
    Total 14 to 15 Years of experience.Relevant experience 6 to 7 Years.Experience in solutions architecture or equivalent experience. Experience in technical domains such as AI / ML, multimodal ML, model...Show more
    Last updated: 14 days ago • Promoted
    Data Architect - Mid-Level Data Analyst

    Data Architect - Mid-Level Data Analyst

    RICEFW Technologies Inc • Trenton, NJ, United States
    Full-time
    Quick Apply
    This Data Analyst position is to work with Business Teams and bridge the gap between business partners and the technology solution providers by translating business needs into Warehouse solutions f...Show more
    Last updated: 3 days ago