Data Warehouse Engineer

2 weeks ago


San Francisco, United States Unreal Gigs Full time
Company Overview: Welcome to the forefront of data-driven decision-making At our company, 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. Join us and be part of a dynamic team dedicated to shaping the future of data warehouse engineering.

Position Overview: As a Data Warehouse Engineer, you'll play a crucial role in designing, building, and maintaining our data warehouse infrastructure and systems. Working closely with cross-functional teams of data analysts, business intelligence developers, and software engineers, you'll ensure the reliability, performance, and scalability of our data warehouse solutions. If you're passionate about data engineering and eager to drive innovation through scalable data warehouse solutions, we want you on our team.

Requirements

Key Responsibilities:
  1. Data Warehouse Design: Design and architect scalable and efficient data warehouse solutions, including data models, schemas, and storage structures.
  2. ETL Development: Develop and maintain ETL (Extract, Transform, Load) processes to extract data from source systems, transform it to meet business requirements, and load it into the data warehouse.
  3. Data Modeling: Design and implement dimensional and normalized data models to support reporting, analytics, and business intelligence applications.
  4. Data Integration: Integrate data from diverse sources, including databases, applications, APIs, and flat files, ensuring data consistency and integrity.
  5. Performance Optimization: Optimize data warehouse performance for query speed, concurrency, and scalability, tuning SQL queries, indexing strategies, and partitioning schemes.
  6. Data Quality and Governance: Implement data quality checks and validation rules to ensure the accuracy, completeness, and consistency of data in the warehouse.
  7. Monitoring and Maintenance: Monitor data warehouse performance and health, proactively identifying and addressing issues to minimize downtime and optimize resource utilization.
  8. Documentation and Collaboration: Document data warehouse architecture, processes, and best practices, and collaborate with cross-functional teams to ensure alignment and transparency.

Qualifications:
  • Bachelor's degree or higher in Computer Science, Engineering, or related field.
  • Strong background in data engineering, with hands-on experience in designing, building, and maintaining data warehouse solutions.
  • Proficiency in SQL and database technologies such as PostgreSQL, MySQL, SQL Server, or Oracle.
  • Experience with data warehouse platforms and technologies such as Amazon Redshift, Google BigQuery, Snowflake, or Microsoft Azure SQL Data Warehouse.
  • Familiarity with ETL tools and technologies such as Apache Airflow, Talend, Informatica, or AWS Glue.
  • Strong problem-solving abilities and analytical thinking, with a keen attention to detail and a passion for tackling complex technical challenges.
  • 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 Data Warehouse Engineers typically ranges from $140,000 to $210,000 per year, depending on experience and qualifications. Exceptional candidates may be eligible for higher compensation packages.
  • 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 team-building activities and social events.
  • Opportunities for career growth and advancement within the company.
  • Exciting projects with real-world impact across diverse industries.
  • Chance to work alongside top talent and industry experts in the field of data warehouse engineering.


Join Us: Ready to shape the future of data warehouse engineering? Apply now to join our team and be part of an exciting journey of innovation and discovery

  • San Francisco, United States Unreal Gigs Full time

    Company Overview: Welcome to the forefront of data-driven decision-making! At our company, 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. Join us and be part of a...


  • San Francisco, United States Unreal Gigs Full time

    Job DescriptionJob DescriptionCompany Overview: Welcome to the forefront of data-driven decision-making! At our company, 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...


  • San Francisco, United States Unreal Gigs Full time

    Company Overview: Welcome to the forefront of data-driven innovation! Our company is dedicated to harnessing the power of data to drive transformative change and solve complex problems across industries. We're committed to building scalable and efficient data warehousing solutions that enable advanced analytics, reporting, and business intelligence. Join us...


  • San Francisco, United States Unreal Gigs Full time

    Company Overview: Welcome to the forefront of data-driven innovation! Our company is dedicated to harnessing the power of data to drive transformative change and solve complex problems across industries. We're committed to building scalable and efficient data warehousing solutions that enable advanced analytics, reporting, and business intelligence. Join us...


  • San Francisco, United States Unreal Gigs Full time

    Job DescriptionJob DescriptionCompany Overview: Welcome to the forefront of data-driven innovation! Our company is dedicated to harnessing the power of data to drive transformative change and solve complex problems across industries. We're committed to building scalable and efficient data warehousing solutions that enable advanced analytics, reporting,...


  • San Francisco, United States Unreal Gigs Full time

    Job DescriptionJob DescriptionCompany Overview: Welcome to the forefront of data-driven innovation! Our company is dedicated to harnessing the power of data to drive transformative change and solve complex problems across industries. We're committed to building scalable and efficient data warehousing solutions that enable advanced analytics, reporting,...


  • San Francisco, United States Unreal Gigs Full time

    Job DescriptionJob DescriptionCompany Overview: Welcome to the forefront of data-driven innovation! Our company is dedicated to leveraging the power of data to drive transformative change and solve complex problems across industries. We're committed to building scalable and efficient data warehousing solutions that enable advanced analytics, reporting,...


  • San Francisco, United States TuneIn Full time

    **Senior Data Warehouse Engineer** San Francisco / Engineering Platform / Full-time Regular **Location: San Francisco, Los Angeles, New York, or Remote** At TuneIn, we are reinventing radio for a connected world, with live sports, up-to-the-minute news, curated music, millions of podcasts, and over 120,000 streaming radio stationsstreamed to tens of...


  • San Francisco, United States People Data Labs Full time

    Job DescriptionJob DescriptionAbout UsAt People Data Labs, we're committed to democratizing access to high-quality B2B data and leading the emerging DaaS economy. We empower developers, engineers, and data scientists to create innovative, compliant data products at scale with our clean, easy-to-use datasets of resume, company, location, and education...

  • Data Analyst

    5 days ago


    San Francisco, United States People Data Labs Full time

    Job DescriptionJob DescriptionAbout UsAt People Data Labs, we're committed to democratizing access to high-quality B2B data and leading the emerging DaaS economy. We empower developers, engineers, and data scientists to create innovative, compliant data products at scale with our clean, easy-to-use datasets of resume, company, location, and education...

  • Senior Data Engineer

    2 months ago


    San Francisco, United States Sephora Full time

    At Sephora we inspire our customers, empower our teams, and help them become the best versions of themselves.  We create an environment where people are valued, and differences are celebrated. Every day, our teams across the world bring to life our purpose: to expand the way the world sees beauty by empowering the ExtraOrdinary in each of us. We are...

  • Data Engineer

    1 month ago


    San Francisco, United States BayOne Solutions Full time

    Senior Data EngineerLocation: (100% Remote)Duration: Full time The Opportunity:TechnologyOur technology team works fast and smart. With San Francisco as our home, we take bringing new tech to market seriously, developing the latest in mobile technologies, scalable architecture, and the coolest in-store client experience. We love what we do and we have fun...

  • Data Engineer

    1 month ago


    San Francisco, United States BayOne Solutions Full time

    Senior Data EngineerLocation: (100% Remote)Duration: Full time The Opportunity:TechnologyOur technology team works fast and smart. With San Francisco as our home, we take bringing new tech to market seriously, developing the latest in mobile technologies, scalable architecture, and the coolest in-store client experience. We love what we do and we have fun...

  • Data Engineer

    2 months ago


    San Francisco, United States BayOne Solutions Full time

    Senior Data EngineerLocation: (100% Remote)Duration: Full time The Opportunity:TechnologyOur technology team works fast and smart. With San Francisco as our home, we take bringing new tech to market seriously, developing the latest in mobile technologies, scalable architecture, and the coolest in-store client experience. We love what we do and we have fun...

  • Data Engineer

    5 days ago


    San Francisco, United States Plaid Full time

    We believe that the way people interact with their finances will drastically improve in the next few years. We’re dedicated to empowering this transformation by building the tools and experiences that thousands of developers use to create their own products. Plaid powers the tools millions of people rely on to live a healthier financial life. We work with...


  • San Francisco, CA, United States Airbnb Full time

    Airbnb is a mission-driven company dedicated to helping create a world where anyone can belong anywhere. It takes a unified team committed to our core values to achieve this goal. Airbnb's various functions embody the company's innovative spirit and our fast-moving team is committed to leading as a 21st century company. Airbnb is a mission-driven...


  • San Francisco, CA, United States Bayone Full time

    Senior Engineer, Data Engineering Job ID: 240167 Location Name: FSC REMOTE SF/NY/DC -173(USA_0173) Address: FSC, Remote, CA 94105, United States (US) Job Type: Full Time Position Type: Regular Job Function: Information Technology Remote Eligible: Yes Company Overview: At Sephora we inspire our customers, empower our teams, and help them...

  • Cloud Data Engineer

    1 week ago


    San Francisco, United States Unreal Gigs Full time

    Company Overview: Welcome to the forefront of cloud data engineering! At our company, we're dedicated to leveraging the power of cloud technology to drive data-driven innovation. Our mission is to develop scalable and robust cloud data solutions that enable organizations to harness the full potential of their data. Join us and be part of a dynamic team...

  • Cloud Data Engineer

    2 weeks ago


    San Francisco, United States Unreal Gigs Full time

    Job DescriptionJob DescriptionCompany Overview: Welcome to the forefront of cloud data engineering! At our company, we're dedicated to leveraging the power of cloud technology to drive data-driven innovation. Our mission is to develop scalable and robust cloud data solutions that enable organizations to harness the full potential of their data. Join us...

  • Data Warehouse Manager

    2 months ago


    San Francisco, CA, United States University of California San Francisco Full time

    As a preeminent health sciences campus and health system, the University of California, San Francisco (UCSF) is at the forefront of creating new knowledge from the exploding volume of clinical, discovery, and educational data that it creates and manages. UCSF believes that the ability to leverage these data assets is an essential differentiator for an...