Lead Data Warehouse Engineer

7 days ago


San Francisco, California, United States Unreal Gigs Full time
Job Description

Company Overview: At Unreal Gigs, we're at the forefront of data-driven innovation, harnessing the power of data to drive transformative change and solve complex problems across industries. Our company is dedicated to building scalable and efficient data warehousing solutions that enable advanced analytics, reporting, and business intelligence.

Position Overview: As the Lead Data Warehouse Engineer, you'll be responsible for leading our data warehouse engineering efforts and driving the design, development, and maintenance of our data warehousing solutions. You'll lead a team of talented engineers and collaborate closely with cross-functional teams to deliver end-to-end data solutions that support the needs of our data-driven organization.

Key Responsibilities:

  1. Technical Leadership: Provide technical guidance, mentorship, and leadership in data warehouse engineering best practices and technologies.
  2. Data Warehouse Design: Lead the design and architecture of our data warehousing solutions, ensuring scalability, reliability, and performance to meet the needs of our growing organization.
  3. Data Modeling: Design and implement data models and schemas to support analytical and operational requirements, ensuring data integrity, consistency, and performance in a data warehouse environment.
  4. ETL/ELT Processes: Develop ETL/ELT processes to extract, transform, and load data from various sources into the data warehouse, ensuring data quality and integrity throughout the process.
  5. Performance Optimization: Optimize data warehouse performance, identifying and addressing bottlenecks and inefficiencies to improve system scalability and reliability.
  6. Data Governance: Implement data governance policies and best practices to ensure data quality, security, and compliance with regulatory requirements.
  7. Monitoring and Alerting: Implement monitoring and alerting systems to track data warehouse performance and health, detecting and mitigating issues proactively to minimize downtime and data loss.
  8. Documentation and Best Practices: Define and promote best practices for data warehouse engineering, documentation, and usage, ensuring clear and comprehensive documentation to facilitate understanding and collaboration among team members.
  9. Collaboration: Collaborate with cross-functional teams, including data scientists, software engineers, and business stakeholders, to understand requirements and deliver data solutions that meet business needs.
  10. Mentorship and Development: Mentor junior engineers, providing guidance, support, and opportunities for growth and development in their data warehouse engineering careers.

Qualifications:

  • Bachelor's degree or higher in Computer Science, Engineering, Mathematics, or related field.
  • 7+ years of experience in data warehouse engineering, with a focus on designing, building, and maintaining data warehousing solutions.
  • Leadership experience, with a demonstrated ability to lead and mentor a team of engineers.
  • Proficiency in SQL and experience with data warehousing technologies such as Snowflake, Amazon Redshift, Google BigQuery, or similar.
  • Strong understanding of data modeling concepts and techniques, with experience designing and implementing data models and schemas for data warehouses.
  • Experience with ETL/ELT processes, data integration, and data governance in a data warehouse environment.
  • Strong problem-solving skills and analytical thinking, with the ability to troubleshoot complex data issues and optimize system performance.
  • Excellent communication and collaboration skills, with the ability to work effectively in cross-functional teams and communicate technical concepts to non-technical stakeholders.

Benefits:

  • Competitive salary: The industry standard salary for Lead Data Warehouse Engineers typically ranges from $200,000 to $300,000 per year, depending on experience and qualifications.
  • Comprehensive health, dental, and vision insurance plans.
  • Flexible work hours and remote work options.
  • Generous vacation and paid time off.
  • Professional development opportunities, including access to training programs, conferences, and workshops.
  • State-of-the-art technology environment with access to cutting-edge tools and resources.
  • Vibrant and inclusive company culture with opportunities for growth and advancement.
  • Exciting projects with real-world impact at the forefront of data-driven innovation.


  • San Francisco, California, United States Unreal Gigs Full time

    Job Title: Lead Data Systems EngineerUnreal Gigs is seeking a highly skilled Lead Data Systems Engineer to join our team. As a key member of our data engineering team, you will be responsible for designing, implementing, and optimizing our data systems infrastructure.Key Responsibilities:Provide technical leadership and guidance to a team of data engineers,...

  • Lead Data Engineer

    2 weeks ago


    San Francisco, California, United States Unreal Gigs Full time

    Job Title: Lead Big Data EngineerAt Unreal Gigs, we're seeking a highly skilled Lead Big Data Engineer to join our team. As a key member of our data engineering team, you'll be responsible for designing, building, and maintaining our big data infrastructure and pipelines.Key Responsibilities:Lead a team of big data engineers, providing guidance, mentorship,...


  • San Francisco, California, United States Jobot Full time

    Job Title: Lead Data Product EngineerWe are seeking a highly skilled Lead Data Product Engineer to join our team at Jobot. As a key member of our data engineering team, you will be responsible for designing, developing, and maintaining large-scale data systems and pipelines.Job Summary:The Lead Data Product Engineer will lead the development of data products...


  • San Francisco, California, United States Unreal Gigs Full time

    Job Title: Lead Data Systems EngineerAt Unreal Gigs, we're seeking a highly skilled Lead Data Systems Engineer to join our team. As a key member of our data engineering team, you will be responsible for leading the design, implementation, and optimization of our data systems infrastructure.Key Responsibilities:Technical Leadership: Provide strategic...


  • San Francisco, California, United States Pendulum™ Full time

    About PendulumPendulum is a pioneering company that is revolutionizing the way we understand and improve physical and mental health by harnessing the power of the human microbiome.Our research has shown that the microbiome plays a critical role in various aspects of our lives, from metabolism and diabetes to longevity, weight loss, and healthy immune...

  • Cloud Data Engineer

    3 weeks ago


    San Francisco, California, United States Stefanini North America and APAC Full time

    Job Title: Cloud Data EngineerStefanini North America and APAC is seeking a highly skilled Cloud Data Engineer to join our team. As a Cloud Data Engineer, you will be responsible for designing, developing, and implementing complex data warehouse and business intelligence solutions.Key Responsibilities:Contribute to the design and development of data...


  • San Francisco, California, United States Unreal Gigs Full time

    Job Title: Lead Big Data EngineerAt Unreal Gigs, we're seeking a highly skilled Lead Big Data Engineer to join our team and drive the future of data-driven innovation.Job SummaryWe're looking for a seasoned engineer with expertise in big data technologies and a track record of leading successful data projects. As the Lead Big Data Engineer, you'll be...


  • San Francisco, California, United States Unreal Gigs Full time

    Unreal Gigs Data Warehouse EngineerAt Unreal Gigs, we're committed to harnessing the power of data to drive insights and innovation. Our mission is to develop scalable and efficient data warehouse solutions that empower organizations to make informed decisions based on high-quality data.Key Responsibilities:Data Warehouse Design: Design and architect...


  • San Francisco, California, United States Unreal Gigs Full time

    Job Title: Lead Big Data EngineerAt Unreal Gigs, we're seeking a highly skilled Lead Big Data Engineer to join our team. As a key member of our data engineering team, you'll be responsible for designing, building, and maintaining our big data infrastructure and pipelines.Key Responsibilities:Technical Leadership: Provide technical guidance and leadership to...


  • San Mateo, California, United States BayInfotech Full time

    Job Title: Data Warehouse EngineerBayInfotech is seeking a highly skilled Data Warehouse Engineer to join our team. As a key member of our data analytics team, you will be responsible for designing, developing, and maintaining our enterprise data warehouse and reporting systems.Key Responsibilities:Design and develop ETL processes using Informatica tool to...


  • San Francisco, California, United States Unreal Gigs Full time

    Job Title: Senior Data Warehouse EngineerAt Unreal Gigs, we're seeking a highly skilled Senior Data Warehouse Engineer to join our team of data-driven innovators. As a key member of our data engineering team, you'll play a critical role in designing, building, and maintaining our data warehousing solutions.Key Responsibilities:Data Warehouse Design: Design...

  • Lead Data Engineer

    4 weeks ago


    San Jose, California, United States InsideHigherEd Full time

    Job SummaryThe Lead Data Engineer is responsible for developing and implementing a comprehensive data strategy to support business decision-making at InsideHigherEd. This position will play a key role in designing, building, and maintaining a robust data warehouse and business intelligence platform to facilitate data-driven insights and strategic...


  • San Francisco, California, United States Unreal Gigs Full time

    Job Title: Lead Data Systems EngineerUnreal Gigs is seeking a highly skilled and experienced Lead Data Systems Engineer to join our team. As a key member of our data engineering team, you will be responsible for leading the design, implementation, and optimization of our data systems infrastructure.Key Responsibilities:Technical Leadership: Provide strategic...

  • Lead Data Architect

    2 weeks ago


    San Francisco, California, United States Unreal Gigs Full time

    Job Title: Lead Data EngineerCompany Overview:Welcome to Unreal Gigs, a pioneering company at the forefront of data-driven innovation. Our mission is to harness the power of data to drive transformative change and solve complex problems across industries. We're committed to building scalable and reliable data infrastructure that enables advanced analytics,...

  • Senior Data Engineer

    2 weeks ago


    San Francisco, California, United States SmithRx Full time

    Transforming Pharmacy Benefits Management with Data Engineering ExpertiseAt SmithRx, we're revolutionizing the Pharmacy Benefits Management (PBM) sector with cutting-edge technology and innovative cost-saving tools. As a Senior Data Engineer, you'll play a crucial role in developing scalable data pipelines, optimizing data workflows, and ensuring data...

  • Senior Data Engineer

    2 weeks ago


    San Francisco, California, United States SmithRx Full time

    Transforming Pharmacy Benefits Management with Data Engineering ExpertiseAt SmithRx, we're revolutionizing the Pharmacy Benefits Management (PBM) sector with cutting-edge technology and innovative cost-saving tools. As a Senior Data Engineer, you'll play a pivotal role in shaping our next-generation drug acquisition platform, driven by data-driven insights...


  • San Francisco, California, United States SmithRx Full time

    Transforming Pharmacy Benefits Management with Data Engineering ExpertiseAt SmithRx, we're revolutionizing the Pharmacy Benefits Management (PBM) sector with cutting-edge technology and innovative cost-saving tools. As a Senior Data Engineer, you'll play a crucial role in shaping our next-generation drug acquisition platform.Key Responsibilities:Design and...


  • San Francisco, California, United States Apex Systems, Inc. Full time

    Job Title: Senior Data EngineerWe are seeking a highly skilled Senior Data Engineer to join our team at Apex Systems, Inc. As a Senior Data Engineer, you will be responsible for designing, developing, and maintaining large-scale data systems and pipelines.Key Responsibilities:Lead the development of data pipelines for machine learning use casesDesign and...


  • San Francisco, California, United States SS&C Technologies Full time

    Senior Data EngineerSS&C Technologies is a leading provider of investment and financial services and software for the financial services and healthcare industries. As a Senior Data Engineer, you will be part of a team responsible for creating a cutting-edge cloud platform using the latest big data, cloud native, and machine learning technologies.Key...

  • Lead Data Analyst

    2 weeks ago


    San Francisco, California, United States Russell Tobin & Associates Full time

    Lead Analyst, Advanced AnalyticsWe are seeking a highly skilled Lead Analyst to join our team in San Francisco, CA. As a key member of our analytics team, you will be responsible for building metrics and dimensions in our data warehouse to support business decisions.Key Responsibilities:Design and execute A/B tests in collaboration with Product Managers and...