Unreal Gigs is hiring: Lead Data Warehouse Engineer in San Francisco

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 and lead our team in shaping the future of data warehouse engineering.

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. If you're a seasoned engineer with expertise in data warehousing technologies and a track record of leading successful data projects, we want you on our team.

Requirements

Key Responsibilities:

1. Technical Leadership: Lead a team of data warehouse engineers, providing guidance, mentorship, and technical 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: Lead the design and implementation of 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: Lead the development of 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: Lead efforts to 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.

Join Us: Ready to lead the charge in data warehouse engineering? Apply now to join our team and drive the future of data-driven innovation!