Sr Data Warehouse Architect

The Senior Data Warehouse Architect will lead the
design, development, and optimization of enterprise data warehouse solutions
that support critical business intelligence and analytics needs. This role
requires deep technical expertise in modern cloud data platforms and the
ability to architect scalable, performant data solutions that serve diverse
analytical requirements across the organization. The ideal candidate will
combine technical excellence with strong collaboration skills and a commitment
to delivering high -quality, reliable data solutions.<\/span><\/span><\/span><\/span>
<\/span><\/span><\/p>

<\/span><\/span><\/p>

Job Responsibilities<\/span><\/span><\/b>
<\/span><\/span><\/p>

• Data
  Warehouse Architecture: Design and implement dimensional models, data vault
  structures, and other architectural patterns optimized for analytical
  workloads. Define data integration patterns, data flow architectures, and
  transformation strategies that balance performance, maintainability, and
  flexibility. Lead the architectural evolution of the enterprise data warehouse
  on Snowflake.<\/span><\/span><\/span><\/span><\/span><\/span>
  <\/span>
  <\/span><\/span><\/span><\/li>
• ETL/ELT
  Development and Optimization: Architect and optimize ETL/ELT pipelines using
  modern tools like Coalesce and Wherescape. Design efficient data transformation
  logic including complex recursive CTEs, hierarchical data structures, and
  performance -critical queries. Establish patterns for handling slowly changing
  dimensions, data historization, and temporal data.<\/span><\/span><\/span><\/span><\/span><\/span>
  <\/span><\/span><\/span><\/span><\/span>
  <\/span><\/span><\/span><\/li>
• Performance Optimization: Analyze and optimize
  query performance, implement appropriate clustering strategies, and design
  efficient data structures. Monitor warehouse performance metrics and implement
  solutions for query optimization, resource management, and cost efficiency.
  Establish best practices for performance tuning across the analytics stack<\/span><\/span><\/span><\/span><\/span><\/span>
  <\/span><\/span><\/span><\/span><\/span>
  <\/span><\/span><\/span><\/li>
• Data
  Integration: Lead integration efforts across source systems including policy
  management systems (Atlas, AMS360), CRM platforms, quoting applications, call
  center systems, and financial systems. Design robust data pipelines that handle
  various data formats, frequencies, and quality challenges. Architect solutions
  for real -time and batch data integration needs.<\/span><\/span><\/span><\/span><\/span><\/span>
  <\/span><\/span><\/span><\/span><\/span>
  <\/span><\/span><\/span><\/li>
• Platform
  Migration Leadership: Lead technical aspects of platform migrations and
  modernization initiatives. Develop migration strategies that minimize business
  disruption while improving capabilities. Conduct proof -of -value assessments for
  new technologies and platforms.<\/span><\/span><\/span><\/span><\/span><\/span>
  <\/span><\/span><\/span><\/span><\/span>
  <\/span><\/span><\/span><\/li>
• Technical
  Leadership: Provide technical mentorship to data engineers and analysts.
  Establish architectural standards, design patterns, and best practices for the
  BI&A team. Conduct design reviews and provide technical guidance on complex
  data challenges. Collaborate with stakeholders across Retail Operations and
  Supporting Operations Departments to understand analytical requirements and
  translate them into technical solutions<\/span><\/span><\/span><\/span><\/span>
  <\/span><\/span>
  <\/span><\/li><\/ul><\/div><\/span>
  Requirements<\/h3>

  Experience:<\/b>
  <\/span><\/span><\/p>

  • 8+ years of experience in data warehousing with at least 3 years in architectural roles.
    <\/span><\/span><\/li>
  • Background in data migration projects and platform modernization initiatives
    <\/span><\/span><\/li>
  • Familiarity with additional data integration tools and technologies
    <\/span><\/span><\/li><\/ul>

    
    <\/span><\/span><\/p>

    Scholarship:<\/b>
    <\/span><\/span><\/p>

    • University/College
      <\/span><\/span><\/li>
    • Master's Degree
      <\/span><\/span><\/li><\/ul>

      
      <\/span><\/span><\/p>

      Specialized knowledge:<\/b>
      <\/span><\/span><\/p>

      • Proven track record of designing and implementing enterprise -scale data warehouse solutions
        <\/span><\/span><\/li>
      • Experience in insurance industry with knowledge of policy systems, commission structures, and industry -specific data challenges
        <\/span><\/span><\/li><\/ul>

        
        <\/span><\/span><\/p>

        Computer knowledge:<\/b>
        <\/span><\/span><\/p>

        • Expert -level SQL skills including ad